[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
the solution to your problem : add AuthBasicAuthoritative Off AuthUserFile /dev/null to your Directory or your .htaccess -file. Its a known bug - it is also mentioned in the platform-specific USAGE-file. -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
Hi Daniel, As you might see, I told in my report that it doesn't work even with these options. Here you are: https://bugs.launchpad.net/ubuntu/+source/libapache-mod-auth-mysql/+bug/506540 . Even in this Bug there are those lines given multiple times. -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
@Adam Did you try Daevid's work around in comment 15[0]? [0] https://bugs.edge.launchpad.net/ubuntu/+source/libapache-mod-auth- mysql/+bug/150649/comments/15 -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
Tested on brand new install of Lucid Lynx, also affected. -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
I've been struggling with this in a brand new 8.10 server myself that I just setup yesterday. Not sure how or why, but i got this magic incantation to work (do note however, I'm storing the passwords in plaintext in mySQL): Directory /home/dae51d/public_html/examples/crimson AuthName CRiMson -- use: test/test1234 AuthType Basic require valid-user AuthUserFile /dev/null AuthBasicAuthoritativeOff # http://www.daevid.com/server-info#mod_auth_mysql.c Auth_MYSQLOn Auth_MySQL_Host localhost Auth_MySQL_User crimson_user Auth_MySQL_Password crimson_password Auth_MySQL_DB crimson_database Auth_MySQL_Authoritative On Auth_MySQL_Password_Table rep_table Auth_MySQL_Encryption_Types Plaintext MySQL Auth_MySQL_Encrypted_PasswordsOff Auth_MySQL_Empty_PasswordsOff Auth_MySQL_Username_Field rep_login Auth_MySQL_Password_Field rep_password /Directory But what I don't understand is when I do this one: Directory /home/reviewit/public_html/admin Options All +Includes AllowOverride None AuthName SYMCELL Administration AuthType Basic require valid-user AuthUserFile /dev/null AuthBasicAuthoritativeOff # http://www.daevid.com/server-info#mod_auth_mysql.c Auth_MYSQLOn Auth_MySQL_Host localhost Auth_MySQL_User reviewit_user Auth_MySQL_Password reviewit_pass Auth_MySQL_DB reviewit_db Auth_MySQL_Authoritative On Auth_MySQL_Password_Table users Auth_MySQL_Encryption_Types SHA1Sum Auth_MySQL_Encrypted_PasswordsOn Auth_MySQL_Empty_PasswordsOff Auth_MySQL_Username_Field username Auth_MySQL_Password_Field password # Auth_MySQL_Where type = 'Admin' AND enabled = 1 Auth_MySQL_Where enabled = 1 /Directory Everything works except for the Auth_MySQL_Where part which says: [Tue Feb 10 18:26:34 2009] [error] Query call failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type = Admin AND enabled = 1' at line 1 (1064) But removing the type = 'Admin' then it works. I've tried reversing the quotes. without any on the ends. \'Admin\' and I can't figure out the magic incantation. Also, my mod_auth_mysql.c shows Auth_MySQL_Where as the directive, but this page (http://modauthmysql.sourceforge.net/CONFIGURE) shows AuthMySQLUserCondition and NO Auth_MySQL_Where... Come on man! it's bad enough the directives keep changing slightly with underscores and such with each version but now you don't even have the same directive names. Is this project dead? it's v3.0.0 was on 2005-6-22 -- that's 3.5 YEARS ago! What pisses me off more is that this USED to work with an older version of mod_auth_mysql I had on my Gentoo box which was v3.0.0. And there is no current documentation that I've found for the current apt-get version... # dpkg -s libapache2-mod-auth-mysql Package: libapache2-mod-auth-mysql Status: install ok installed Priority: optional Section: web Installed-Size: 108 Maintainer: Ubuntu Core Developers ubuntu-devel-disc...@lists.ubuntu.com Architecture: i386 Source: mod-auth-mysql Version: 4.3.9-9 Depends: libc6 (= 2.4), libmysqlclient15off (= 5.0.27-1), apache2.2-common (= 2.2.3-3) Description: Apache 2 module for MySQL authentication A module for the Apache 2 web server which enables HTTP authentication against information stored in a MySQL database. Original-Maintainer: Joey Schulze j...@debian.org -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
SOLVED: THIS IS STUPID!! The Where clause requires that YOU put an additional AND in there. Auth_MySQL_Where AND type = 'Admin' AND enabled = 1 So the auth_mysql code must be making a SELECT * FROM user WHERE username = 'foo' AND password = 'bar' WHERE 1 or some other completely retarded logic, when it should simply be putting a WHERE (with the intentional trailing space) and the string you gave it in the directive. UGH! -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
I can also reproduce this bug in Intrepid. Are there any work-arounds? I have tried using DBD as an alternative - it works fine but does not support MD5 passwords and as it is a drupal database I am trying to authenticate off I am stuck with MD5. Is this module really deprecated? Without DBD supporting MD5 mysql users are a bit stuck without it. My only alternative is to write my own custom one. -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 150649] Re: gutsy does not have a working apache+mysql authentication solution
I can reproduce this bug on Hardy ** Changed in: libapache-mod-auth-mysql (Ubuntu) Status: Incomplete = Confirmed -- gutsy does not have a working apache+mysql authentication solution https://bugs.launchpad.net/bugs/150649 You received this bug notification because you are a member of Ubuntu Server Team, which is a direct subscriber. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
