Page 1 of 1

PostPosted: Thu Aug 24, 2006 1:58 pm
by errata
I'm attempting to install Dataface on a shared host, necessitating manual configuration since shell access isn't permitted. my conf.ini contains a "dbuser" = aaaaaa@bb-ccc.net, which leads to the error message:


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'aaaaaa@bb-ccc.ne'@'localhost' (using password: YES) in /var/www/html/dface/Dataface/Application.php on line 182
Error connecting to the database: Access denied for user 'aaaaaa@bb-ccc.ne'@'localhost' (using password: YES)

This seems to me to be due to a limitation of the length of the dbuser variable, which then gets truncated. Any way to increase this length (as I cannot change my username)?

PostPosted: Fri Aug 25, 2006 11:06 am
by shannah
This is very strange. Dataface pretty much passes the info from the conf.ini file straight through to the mysql_connect() function.

This may or may not be the issue, but it appears that you are misusing the username field (I could be wrong). I think that the "user" to "aaaaaa" instead of aaaaa@bb-ccc.net". The @bb-ccc.net will automatically by added to the end by MySQL as this indicates where you are connecting from. You can't pass this to MySQL - it figures it out for itself.

Hope this helps a little.

-Steve

PostPosted: Fri Aug 25, 2006 6:42 pm
by errata
Steve,

You're right, and I'm a noob. That unwieldy username was required by the host for ftp access, and I thought a similar format was needed for mySQL - not so. Thanks for the help (and the great framework).