Topic: phpShop config problems

[Stone Linton]

I'm trying to set this up on my e-smith 4.1 box. So far, I've created an ibay called 'webshop' and then followed the instructions to the best of my understanding, using my /home/e-smith/files/ibays/webshop/html as my web server root, and ..webshop/demo as my WEBROOT -- per my interpetation of the instructions.

Any of you familar with getting phpShop up and running? I saw some earlier posts.

As it is now, I get the following message on my attaching client:

Warning: Host 'hostname.domain.com' is not allowed to connect to this MySQL server in /home/phpshop/db/db_mysql.inc on line 73
Database error: connect(hostname,root,PASSWORD) failed
MySQL Error: ( )

I know nothing of PHP or MySQL so respond accordingly . . . please. Thanks.

[Brandon Friedman]

"Warning: Host 'hostname.domain.com' is not allowed to connect to this MySQL server in /home/phpshop/db/db_mysql.inc on line 73
Database error: connect(hostname,root,PASSWORD) failed
MySQL Error: ( )"

You need to setup a user in on mysql that has right to your database...

mysql>grant all on databasename.* to username@localhost identified by 'password';

alternatively... you haven't setup your dbuser entry correctly on your application!

Brandon

[Dan Brown]

When you created the mysql user, you probably specified localhost (dbuser@localhost).  If this is the case, you need to tell phpShop to connect to "localhost", not "hostname.domain.com", for the MySQL server.  This will probably fix your problem.

[Stone Linton]

Thanks.  That was it.  I was about two hundred pages in to MySQL's manual . . . looking for answers and not understanding a thing!