Topic: osCommerce on SME How-To

[Craig Jensen]

Just completed for those interested:

http://www.acenet-tech.org/cdj/osCommerce_on-SME_howto/osCommerce-on-SME_5.5-how-to.htm

Craig Jensen

[James Tenniswood]

I'm probably doing something really dumb but I keep getting the same password error on the oscommerce install web pages...



. Please enter your database server information:

>192.168.1.1

The database server can be in the form of a hostname, such as db1.myserver.com, or as an IP address, such as 192.168.0.1.

>catalog

The username is used to connect to the database server. An example username is mysql_10.

Note: If the catalog is to be imported (selected above), the account used to connect to the database server needs to have Create and Drop permissions.

>password

The password is used together with the username, which forms the database user account.

>catalog

The database used to hold the catalog data. An example database name is catalog.


......



But then it just says...

A test connection made to the database was NOT successful.

The error message returned is:

Access denied for user: 'catalog@Netserve.network.net' (Using password: YES)



I've copied and pasted from the how-to but with no luck, can anyone point me in the right direction?

Cheers
James

[Craig Jensen]

Hi James,

Try replacing 'Netserve.network.net' in the install page with 'localhost'.

Then, if you have done the mysql setup with:

"grant all on catalog.* to catalog@localhost identified by 'your_chosen_password';"

and: "flush privileges;"

you should be able to connect to the database.

Email me if you have further problems.

Craig Jensen

[Karl McElwain]

Okay I bet I know what your problem is...you haven't setup the username and password and host in MySQL yet.  I was having the same problems but I got a book and started playing with MySQL.  There's actually a database that is setup by default which has all your usernames and passwords for accessing the databases.  This is separate from the Linux username and passwords.  So now you have to access them.  A really easy way for managing MySQL is PhPmyAdmin.  If you do a search somebody dir a RPM for it.

The problem you'll have is getting it to work once you get it installed....it doesn't setup the usernames and passwords in MySQL....you have to do that.

I'd be more than happy to help you .... it was frustrating for me but once I got it working...it's great.

TTYL,
Karl