Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need Help w/MySql username during install on hosted server


wweasel

Recommended Posts

I am trying to install osCommerce 2.2 on a hosted server. My URL is www.seatbags.com. The SQL database is seatbags3_com. I can log into the seatbags3_com database using myphpadmin, userid [email protected], password xxxxxx. I manually ran the oscommerce.sql script from within myphpadmin and it worked fine.

 

But, when I try to do an install through the osCommerce install.php script, I get an error message because it thinks I am user [email protected]. What is up? I can't find in the database.php or configuration.php scripts where it appends the ns3.nukezone.com to my username seatbags, which is all I specify in the config file.

 

Any help appreciated.

 

osCommerce

Open Source E-Commerce Solutions

 

New Install

 

Step 1: Database Import

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: '[email protected]' (Using password: YES)

 

Please click on the Back graphic to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

-------------------------------------

Manual install- changed configuration.php to have

// define our database connection

define('DB_SERVER', 'www.seatbags.com'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'seatbags');

define('DB_SERVER_PASSWORD', 'xxxxxx');

define('DB_DATABASE', 'seatbags3_com');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

 

and did the same in admin/configuration.php

 

Got the error:

Warning: Access denied for user: '[email protected]' (Using password: YES) in /home/virtual/site118/fst/var/www/html/catalog/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: YES) in /home/virtual/site118/fst/var/www/html/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

Link to comment
Share on other sites

Set your db server name to localhost and let me know if that helps.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Hey daemon J that worked i changed the db server name from a IP addy to local host and now it works!!

 

Wweasl you should try that as well

Link to comment
Share on other sites

Great! 8)

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Thanks, using localhost cut through the problem. What was the underlying problem, something with the hosting configuration that was appending the wrong domain?

 

Thanks so much! Rob

Link to comment
Share on other sites

When accessing a mysql server (or any database server for that matter) your login credentials always consist of your user name and a domain.

 

With your previous entry in the database server name, it thought that you were someone from outside of the server's domain. If you had setup your database user to allow remote access this would have worked.

 

Normally you will use localhost since the server that is hosting your site is also typically your database server.

 

Let me know if the above does not make any sense.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

  • 4 weeks later...

I always had it as "localhost" but now I'm getting:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'DB_SERVER_USERNAME@localhost' (Using password: YES) in [path]/includes/functions/database.php on line 19

Unable to connect to database server!

 

but I checked my username and password in configure.php (both admin and catalog) and they are set as before: username=fusion.

 

What else could it be?

Link to comment
Share on other sites

I always had it as "localhost" but now I'm getting:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'DB_SERVER_USERNAME@localhost' (Using password: YES) [path]includes/functions/database.php on line 19

Unable to connect to database server!

 

but I checked my username and password in configure.php (both admin and catalog) and they are set as before: username=fusion.

 

What else could it be?

 

 

You need to reinstall mysql.

Link to comment
Share on other sites

Verify that the 'DB_SERVER_USERNAME' define in both of the configure files has all of the single quotes. For example:

define('DB_SERVER_USERNAME', 'fusion');

When you see an entry that is all caps, that means that it is not being replaced with it's value for some reason. This is usually because that line or the line above or sometimes both are missing a single quote.

 

You do not have to reinstall MySQL.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

It was actually single quotes missing from 'false':

 

define('ENABLE_SSL', false);

 

but it always worked without them?

 

Actually I was testing SSL so I made this to true (also without the quotes)when I started getting the error message I changed it to false (without the quotes) again and same thing. So I just added the single quotes.

 

I think this came without quotes from the install (but I'm actually using Loaded 5). Can someone check and mention as a bug or omission if deservedly so? Hope this helps!!!

Link to comment
Share on other sites

That is a tricky one actually.

 

The configure file in admin uses single quotes for the ENABLE_SSL define while the catalog configure file does not.

 

PM me your catalog configure.php file and I will take a look at it.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Does anyone else have problems with host that DOES NOT ALLOW YOU TO USE "SYMLINKS" (with it you don't have to copy files to HTTPS://)?

 

Any chat users out there? my yahoo id= uzoc2000 or other chats let me know...

Link to comment
Share on other sites

  • 2 weeks later...
If you had setup your database user to allow remote access this would have worked.

 

How do I do this? I have a shared secure server and uploaded all the files to both the store server and the secure server (duplicate files, as my hosting company says I must do it this way).

 

Should the includes/configure and admin/inclues configure files both be the same on both the store server and the secure server?

 

I have MS2.2 and no contributions yets. The store has the sample products and I have the admin working, but when I pretend to be a shopper and go to create an account, I get this error message:

 

Access denied for user....blah, blah, blah...error on Line 19 (that so many others have quoted, but none of their solutions have worked for me)

and then "unable to connect to database server!"

 

Should I change localhost to the Web address on the secure server set of files in the configure file?

 

Anything else I can try?

Link to comment
Share on other sites

You have to change the configure.php in the secure side.

Mainly the line: define('DB_SERVER', 'localhost')

it's not localhost anymore!

 

Gotta get this from your host it will probably look something like the long line from: define('DIR_FS_CATALOG', '/usr/local/psa/home/vhosts/yourserver.com/httpdocs/')

 

But like mines it will probably be different and you'll never know unless the host gives it to you. Also the DB password might say it's wrong cause it will add something like "server@user" wrong id or password will be the error message. If this happens let the host know so he'll fix it on his side.

 

I'm playing with the /images of configure.php of the secure side so it loads the pics from the un-secure side let me know if this helped!

Link to comment
Share on other sites

Thanks for you response. I did request the path from my host, but have heard nothing back. hmmm...

 

I tried every single scenario with what I had available and that was like finding the numbers for a combination lock. :D

 

I contacted my hosting company, but...

 

Thanks for trying to help!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...