JHouse Posted December 10, 2002 Share Posted December 10, 2002 Hi, The shopping cart system works great, that is, until I enable ssl. I've transferred all the necessary files over to the ssl server, however it appears that when trying to checkout, it can't connect to the database remotely. I've tried changing the configuration several times, however thus far it's been fruitless. Here are the error messages: ============================================= Warning: Access denied for user: 'JHouse@216.32.208.240' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Warning: MySQL Connection Failed: Access denied for user: 'JHouse@216.32.208.240' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Unable to connect to database server! ============================================= And here's how it's configured: // define our database connection define('DB_SERVER', 'Dollstoysandmore.com'); // eg, localhost - should not be NULL for productive servers define('DB_SERVER_USERNAME', 'JHouse'); define('DB_SERVER_PASSWORD', '******'); define('DB_DATABASE', 'catalog9'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' Any help would be mighty appreciated. Thanks in advance. JHouse Link to comment Share on other sites More sharing options...
Ajeh Posted December 10, 2002 Share Posted December 10, 2002 Try defining: define('DB_SERVER', 'Dollstoysandmore.com'); // eg, localhost - should not be NULL for productive servers As: define('DB_SERVER', 'localhost'); // eg, localhost - should not be NULL for productive servers Link to comment Share on other sites More sharing options...
JHouse Posted December 10, 2002 Author Share Posted December 10, 2002 Wow, that was quick. Thanks. Well, I updated the config file on the ssl side, but I get virtually the same error message: Basically, as it shows below, it's listing "localhost" instead of the former web address. ============================================== Warning: Access denied for user: 'JHouse@localhost' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Warning: MySQL Connection Failed: Access denied for user: 'JHouse@localhost' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Unable to connect to database server! ============================================== I'm using 2.2, if that makes a difference. Thanks again for your help. JHouse Link to comment Share on other sites More sharing options...
Ajeh Posted December 10, 2002 Share Posted December 10, 2002 Do you have $DOCUMENT_ROOT in one of your definitions? If so, put in the real path. Link to comment Share on other sites More sharing options...
JHouse Posted December 10, 2002 Author Share Posted December 10, 2002 Thanks again for your help... Well, I changed the $DOCUMENT_ROOT to: define('DIR_FS_DOCUMENT_ROOT', /usr/home/nettransactions.com/secure); and it appears we may be getting somewhere as I don't get the "unable to connect to db" message. Here's the latest error message: Parse error: parse error, unexpected '/' in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/configure.php on line 30 Fatal error: Failed opening required 'DIR_WS_FUNCTIONSsessions.php' (include_path='.:/usr/local/lib/php') in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/application_top.php on line 160 ======================================== Does this now mean that I am connecting to the database? Thank you. Take care. JHouse Link to comment Share on other sites More sharing options...
JHouse Posted December 10, 2002 Author Share Posted December 10, 2002 Okay, I fixed the parsing prob, now I get this: +++++++++++++++++++++++++++++++++++++++++ Warning: Division by zero in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/configure.php on line 30 Warning: Division by zero in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/configure.php on line 30 Warning: Division by zero in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/configure.php on line 30 Warning: Division by zero in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/configure.php on line 30 Warning: Access denied for user: 'JHouse@216.32.208.240' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Warning: MySQL Connection Failed: Access denied for user: 'JHouse@216.32.208.240' (Using password: YES) in /usr/home/nettransactions.com/secure/kalkids/catalog/includes/functions/database.php on line 19 Unable to connect to database server! ++++++++++++++++++++++++++++++++++++++++++++++ Seems like I'm back to square one, thus I can't access the db remotely. D'oh. Hmmm.... JHouse Link to comment Share on other sites More sharing options...
Ajeh Posted December 10, 2002 Share Posted December 10, 2002 Check your configure.php file and see if around line 30 you might be missing a ; after a define or a ' or something. Almost sounds like you are missing due to a syntax error something that thinks you are attempting a division command that results in an invalid calculation due to a typo. Link to comment Share on other sites More sharing options...
JHouse Posted December 10, 2002 Author Share Posted December 10, 2002 Okay, it looks like I fixed that prob, however now I'm back to the original message/problem. So, it appears that I still can't access the db remotely. Hmmm... Well, thanks again for your help. JHouse Link to comment Share on other sites More sharing options...
JHouse Posted December 10, 2002 Author Share Posted December 10, 2002 Bump. JHouse Link to comment Share on other sites More sharing options...
JHouse Posted December 11, 2002 Author Share Posted December 11, 2002 Still no luck, huh J? JHouse Link to comment Share on other sites More sharing options...
JHouse Posted December 11, 2002 Author Share Posted December 11, 2002 Okay, I may have found the solution... I did some research (via google) regarding remote database logins, and I've come to learn that it's quite possible I don't have remote server and/or remote database access. I've contacted my host about this, so that they can set this stuff up correctly (assuming they haven't), but I haven't heard back yet. We'll see. In the meantime, maybe the info below can be of some service to related victims. PEace. +++++++++++++++++++++++++++++++++++++++++++++++ Field "Remote server login" This field contains the name of the user for getting access to the remote server. At creating of the new profile this field contains such a line: "your_login_to_remote_server". You must replace this expression with your real login to the remote server, e.g. "User". Field "Remote server password" Password for the access to your remote server. When being entered, this information is shown as stars (*). Field "Remote database name" It is the name of a database, the information of which is necessary to backup. Field "Remote database port" Database port number by which the connection will be carried out (by default 3306) Field "Remote database login" This field contains the name of the user for getting access to the remote database. At creating of the new profile this field contains such a line: "your_login_to_database". You must replace this expression with your real login to the remote database, e.g. "pesonnel_list". Field "Remote database password" Password for access to the database server. When being entered, this information is shown as stars (*). JHouse Link to comment Share on other sites More sharing options...
unistar Posted July 28, 2003 Share Posted July 28, 2003 OK I had the same problem and I just fixed it! For some reason I never had single quotes around 'false' & it always made me think: define('ENABLE_SSL', false); but it worked so I never changed them. But when I started getting the error message: Warning: mysql_connect() [function.mysql-connect <http://www.php.net/function.mysql-connect>]: Access denied for user: 'DB_SERVER_USERNAME@localhost' (Using password: YES) in /usr/local/psa/home/vhosts/myserv/httpdocs/includes/functions/database.php on line 19 Unable to connect to database server! I added single quotes around false and fixed it! Link to comment Share on other sites More sharing options...
airolg Posted August 6, 2003 Share Posted August 6, 2003 I tried the quote thing, but it didn't work. Anyone have another idea for me to try? TIA Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.