Lost connection to MySQL server at 'reading initial communication packet', system error: 0

1 reply
spkane
spkane's picture
Joined: 04/29/2009
User offline. Last seen 1 year 8 weeks ago.

When I try to verify that greensql is working I see this:

$mysql -h 127.0.0.1 -P 3305 -u root -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

It is running:
$ps auxwww | grep greensql
root 401 0.0 0.0 90968 1228 pts/2 S 15:53 0:00 /sbin/runuser -s /bin/sh -c greensql-fw -p /etc/greensql/ greensql
greensql 403 0.0 0.0 58012 2740 ? Ss 15:53 0:00 greensql-fw -p /etc/greensql/
root 27692 0.0 0.0 61144 752 pts/2 S+ 16:17 0:00 grep greensql

$netstat -anp | grep green
tcp 0 0 127.0.0.1:3305 0.0.0.0:* LISTEN 403/greensql-fw
tcp 0 0 12.223.85.13:54358 12.223.85.14:3306 ESTABLISHED 403/greensql-fw
unix 3 [ ] STREAM CONNECTED 10725444 403/greensql-fw
unix 3 [ ] STREAM CONNECTED 10725443 403/greensql-fw

Any help troubleshooting would be appreciated. This is on RHEL5.

Thanks,
Sean

spkane
spkane's picture
Joined: 04/29/2009
User offline. Last seen 1 year 8 weeks ago.

hmmm....So I think that I fixed this by getting the console up and running and editing the Default listener and the name of the default database. Not really sure, but it is working now.

Thanks,
Sean

Back to top