I am installing 2.1.1 on my 1and1.com test dedicated server to play around with the new version. I know 1and1 has a strange MySQL configuration. Has anyone gotten cscart to install on these types of servers? They use port tmp/mysql5.sock for their mysql5 databases. How do I enter this in cs-cart?
I tried
localhost:/tmp/mysql5.sock
localhost
localhost%3A%2Ftmp%2Fmysql5.sock
all with no luck.
Normal hosts use 3306 but 1and1 is … special 
Database name dbxxxxxxxxx
Host name localhost:/tmp/mysql5.sock
Port 3316
User name dboxxxxxxxxx
Password xxxxxxxx
Socket /tmp/mysql5.sock
Where do I place the port? I do not see that option during the install. I looked through some php files and did not see it either?
Socket is the port
(Sorry, ignore it) can’t find it.
[COLOR=#000000][COLOR=#DD0000]localhost:/tmp/mysql.sock
try that
[/COLOR][/COLOR]
As stated above, I tried that. Any other suggestions. There has to be a way to tell cscart to use a different port (socket).
I would search in the installation script first. If no luck, get in touch with CS guys so they can provide a quick fix for it. I think, there should be an option to specify the port number when installing. I already heard about other big guys doing the same trick with mySQL.
Whatever comes out of it, please give us a shout.
localhost:3361
try that?
Unfortunately, still a NOGO
1and1 does have weird setups. However you need to determine the issue.
Have you tried this?
1, From the 1and1 Control Panel - Go to the server Administration section and make sure PHP is running as a module.
2, Create a .htaccess file and put the following line into it.
php_value mysql.default_socket “/tmp/mysql5.sock”
And put this .htaccess file into the root of the CS-Cart directory.
3, Enter the following settings into the vB config.php file.
$config[‘MasterServer’][‘servername’] = ‘localhost’;
$config[‘MasterServer’][‘port’] = ‘/tmp/mysql5.sock’;
If you still cannot get to work you may have to contact 1and1 I have seen IP issues cause database connection issues before.
Good luck!
Why not to change the host instead of scratching your head and wasting another day? Time is money. Are they 1$ per month or what?
I just use 1and1 to host my non ecommerce sites. It works well for them. Since I already pay for the dedicated server, I thought I would use it as a test bed for the new cs-cart. I would never use 1and1 as a real host for cs-cart.
[quote name=‘Triplets’]I just use 1and1 to host my non ecommerce sites. It works well for them. Since I already pay for the dedicated server, I thought I would use it as a test bed for the new cs-cart. I would never use 1and1 as a real host for cs-cart.[/QUOTE]
If on a dedicated server, why not adjust your MySQL config to use the default port# so you won’t have this problem?
This is done simply by editing my.cnf and restarting MySQL.
If you require external database connections then you may also need to adjust firewall rules to open the new port but this isn’t recommended unless absolutely necessary and should be allowed only to specific IP addresses. This article may help [url]http://www.cyberciti.biz/tips/linux-iptables-18-allow-mysql-server-incoming-request.html[/url]
In case anybody else runs into this problem, I finally figured it out.
1And1 does not support mysqli
So in the install index.php file I had to force cs-cart to use mysql and NOT mysqli
if (IS_MYSQLI == true) {?>