Author Topic: Installation problems on Yahoo Web hosting  (Read 3132 times)

Offline Shaggy

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Installation problems on Yahoo Web hosting
« on: September 22, 2017, 11:33:26 AM »
I am trying to install  AbanteCart cart on yahoo web hosting.  Yahoo interfaces with MySQL through phpMyAdmin. I have created a database with a table name AbanteCart with all rights and privileges granted.  The version info is as follows
Database server
•   Server: mysql via TCP/IP
•   Server type: MySQL
•   Server version: 5.1.55 - Source distribution
•   Protocol version: 10
•   User: Mowattm1@localhost
•   Server charset: UTF-8 Unicode (utf8)
Web server
•   Apache
•   Database client version: libmysql - 5.1.55
•   PHP extension: mysql 
phpMyAdmin
•   Version information: 4.0.10.16l

When I call upon AbanteCart installation file index.phb  and enter my logon info, local host and database name. I keep getting this error
Name   Info
2::warning   mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /Custombuiltpc/AbanteCart/public_html/core/database/mysql.php on line 47


Sql query show variables like '%socket%';  results in     tmp/mysql5.1.55.10920.sock
I tried using this command
$host = 'localhost:/tmp/mysql.sock';
Where I substituted the socket value
$host = ‘localhost:/tmp/mysql5.1.55.10920.sock’;
But got a syntax error, tried $hostname, instead of $host and got same syntax error.
Also Did query on
SHOW VARIABLES WHERE Variable_name = 'hostname'
hostname    p8db9.geo.ne1.yahoo.com  for mysql database   
            p8db9.geo.ne1.yahoo.com   same for AbanteCart
When I entered the above as local host , I still got database connection and socket error.


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2048
  • Karma: +319/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Installation problems on Yahoo Web hosting
« Reply #1 on: September 22, 2017, 01:24:00 PM »
Hello.
You should to ask your hosting provider support about it.
Looks like firewall issues between php and mysql apps.
This problem not related to AbanteCart directly. It's a server misconfiguration trouble.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Shaggy

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Installation problems on Yahoo Web hosting
« Reply #2 on: September 23, 2017, 04:52:14 PM »
Thanks for responding. Yahoo is currently researching the issue.
In phbmyadmin I entered this sql SHOW VARIABLES WHERE Variable_name = 'hostname'
And got hostname p8db9.geo.ne1.yahoo.com
If I use this as local host, I get the system 111 communication connection error
If I use localhost as host name, I get the socket 96 error
2::warning   mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (96) in /Custombuiltpc/AbanteCart/public_html/core/database/mysql.php on line 47

 

Powered by SMFPacks Social Login Mod