mod\u dbd与authquery一起处理md5&salt不工作

ykejflvf  于 2021-06-18  发布在  Mysql
关注(0)|答案(1)|浏览(294)

运行centos 7.5、mysql 8、php7.2、apache2.4.6试图让mysql身份验证为我使用的php应用程序工作,该应用程序将密码存储为md5(md5('pass').salt)
我已经确认加载了正确的模块(如果需要,可以提供列表)
密码不匹配_basic:error][pid 5195][client 10.10.10.111:49234]ah01617:用户ecourt:验证“/central”失败:密码不匹配
以下是/etc/httpd/conf.d目录下我的central.conf文件中的代码


# mod_dbd configuration

# UPDATED to include authentication cacheing

DBDriver mysql
DBDParams "host=localhost dbname=bb user=userU pass=somepass"

DBDMin  4
DBDKeep 8
DBDMax  20
DBDExptime 300

<Directory "/webroot/test/www/central">
  # mod_authn_core and mod_auth_basic configuration
  # for mod_authn_dbd
  AuthType Basic
  AuthName "central login" 

  # To cache credentials, put socache ahead of dbd here
  AuthBasicProvider socache dbd

  # Also required for caching: tell the cache to cache dbd lookups!
  AuthnCacheProvideFor dbd
  AuthnCacheContext my-server

  # mod_authz_core configuration
  Require valid-user
  # Require group 10 8 6

   # mod_authn_dbd SQL query to authenticate a user
   #AuthDBDUserPWQuery "SELECT password FROM user WHERE username = %s"
   AuthDBDUserPWQuery "SELECT MD5(MD5(password) + 'salt') AS password FROM     user WHERE username = %s"

</Directory>

感谢您的帮助。谢谢

afdcj2ne

afdcj2ne1#

'salt'是一个字符串('single quotes'),也许您指的是'salt'('backticks')列?
请参见:
在字段名周围使用反勾号
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html

相关问题