apr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From koszi <ko...@mail.tvnet.hu>
Subject Re: apr_dbd_mysql.c
Date Thu, 04 May 2006 22:16:01 GMT

WOW that was THE THING. Thank you soooo much!
Apache is now trying to authenticate me. 


I get an error upon connection, here are the apache error_log
...
[Fri May 05 00:55:30 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:30 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:55:30 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:30 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:55:30 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:30 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:55:30 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:30 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:55:30 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:30 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:55:55 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:55:55 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:56:02 2006] [crit] DBD: Can't connect to mysql[dbname=vizsga
user=root password=xxxx]
[Fri May 05 00:56:02 2006] [crit] DBD Pool: failed to initialise
[Fri May 05 00:56:02 2006] [error] [client 127.0.0.1] Error looking up koszi
in database
...
Here is the relevant part of my httpd.conf:

###########################################################

DBDriver mysql

#Connection string: database name and login credentials
DBDParams "dbname=vizsga user=root password=xxxx"

#Parameters for Connection Pool Management
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60


<Directory "/var/www/html"> 

    AllowOverride None 
    Order allow,deny 
    Allow from all 

    #mod_auth configuration for authn_dbd
    AuthType Basic
    AuthName "Vizsga"
    AuthBasicProvider dbd

    #authz configuration
    Require valid-user

    #SQL query to verify a user
    #(note: DBD drivers recognise both stdio-like %s and native syntax)
    AuthDBDUserPWQuery "select eha from users where login_name = %s"
    
</Directory> 

Any ideas about this one please?  Is the config OK or am I screwing up
something here? I am absoltely sure about credentials.
Thanks guys you have been very helpful
Hugs
Peter.


Peter Wojciechowski wrote:
> 
> Try this link http://dweller.dwellersoul.com/apr/apr-util_dbd.m4.patch
> 
--
View this message in context: http://www.nabble.com/apr_dbd_mysql.c-t1451411.html#a4238357
Sent from the APR Dev (Apache Portable Runtime) forum at Nabble.com.


Mime
View raw message