localhost.localdomain

[aland]

I have built a test site and found most of the information I needed and it worked as expected. I am now trying to set up a live version on new web server but when I try to install I keep getting the error message 'localhost.localdomain is not allowed acess to this mysql server' I am not using localhost in the set up configuration so can any please tell me why I'm getting this error so I can complete the install. TIA.

[kobra]

As you state that you are not entering localhost in the setup screen for the DB access???

What are the details of your server? LINUX or win, php version, mysql version etc.

[aland]

Debian server. PHP4, MYSQL 5.0

[aland]

I built my test site on the following:

Linux 10.2 with VMWare running Debian Server
I installed Zen-Cart and set it up and used that to learn how to configure and to add products.

This install used the defaults for Database ect i.e. Host = localhost

Now I am building a Web server that will just run Zen-Cart with the following config.


Database Type: MYSQL
Database Host: shop
Database Username: root
Database Name: shop

Host file has been configured with:
127.0.0.1 shop.domainname.com shop
127.0.0.1 localhost.localdomain localhost shop

I do not use localhost at all in the configuration so why am I getting the error from Zen-Cart 'localhost.localdomain is not allowed to connect to the MYSQL server'

[kobra]

You can search but generally 127.0.0.1 is by default "localhost"

[aland]

Is this a bug in the new version...

When I set up Zen cart the first time to try it out and learn how to configure it all I installed in on the same version of Debian, MYSQL and PHP.
I accepted all the defaults i.e. localhost and it worked fine, no problem then.

Now I am trying to install the latest version with Paypal and I am not able to connect to the MYSQL server when I change from localhost to what it should be on a live server.

I have rebuilt the server with Debian, MYSQL 5.0 and PHP and tried to install ZenCart again and I still get the same error 'Lost Conection to MYSQL server during query'

Using Paypal is necessary for this project so going back to the older version is not an option.

[kobra]

When I set up Zen cart the first time to try it out and learn how to configure it all I installed in on the same version of Debian, MYSQL and PHP.
I accepted all the defaults i.e. localhost and it worked fine, no problem then.

Now I am trying to install the latest version with Paypal and I am not able to connect to the MYSQL server when I change from localhost to what it should be on a live server.

This is confusing???

Is this on the same server as the first install that worked?

If so, why have you attempted to change from localhost?

Are you using a host for this live install or is this on your own server?

If on a hosted server, contact them for the DB connection details.

If your own, what is your uplink speed/connection? As most uplinks are about 1/10th of the download speed and trying to serve a site will be slow.

This is really not a difference between versions, but more to your LAMP setup. How to access the DB can be configured differently as the SU desires, and these factors need to be passed to Zen Cart to be able to connect successfully.

[aland]

The first install I did was on my laptop running Linux 10.2 with VM running Debian/MYSQL/PHP with ZenCart 1.3.6

The new install is on a stand alone computer (not connected to the internet at this point) running Debian/MYSQL/PHP which will be my own web server once I get Zen Cart installed and configured.

The database configuration page is:

Host: shop.bluediamondartgallery.com
User Name: root
Password: **************
Datebase Name: shop
Database Session: Yes
SQL Cache: Database

I have tried to change the User and Host to localhost and get a different error with each change, all to do with connecting to the MYSQL server, either Access denied for localhost or lost connection with the above settings

When MYSQL was installed it was given the root password so this should not be the problem.

[kobra]

This is really a forum for Zen Cart and not for LAMP installs...but try this to verify that the mysql is accessible by executing this command as SU:

shell> mysql -u root test

The server should let you connect without error.