#337 Incorrect sql field name in config.ini

Database
closed
Reini Urban
5
2012-10-11
2004-06-04
No

Line 539 in config-dist.ini in 1.3.10 is currently:

; DBAUTH_AUTH_CHECK = "SELECT password FROM user where
userid='$userid'"

It should probably be:

; DBAUTH_AUTH_CHECK = "SELECT PASSWORD(passwd) FROM
user where userid='$userid'"

There is no password field in the user table.

Discussion

  • Logged In: YES
    user_id=378576

    I don't know much about the format of the config.ini file.
    However, it seems like several sql-statements are not
    enclosed in quotes. See for example lines 564-5.
    Uncommenting these lines causes the rest of the ini file to
    be ignored.

     
  • Logged In: YES
    user_id=378576

    I don't know much about the format of the config.ini file.
    However, it seems like several sql-statements are not
    enclosed in quotes. See for example lines 564-5.
    Uncommenting these lines causes the rest of the ini file to
    be ignored.

     
  • Logged In: YES
    user_id=378576

    I don't know much about the format of the config.ini file.
    However, it seems like several sql-statements are not
    enclosed in quotes. See for example lines 564-5.
    Uncommenting these lines causes the rest of the ini file to
    be ignored.

     
  • Reini Urban
    Reini Urban
    2004-06-06

    Logged In: YES
    user_id=13755

    This line is only an example for External DB Auth, not
    necesserely against the phpwiki.user table.

    But I fixed it nevertheless. The missing quotes also.