2 server setup

[tommyinnn]

I have this working with a different server, but for some reason, this new server I just installed vicidial on will not let me connect a second server to it

2 servers

1 (main server) will hold mysql & also be used as dialer (71.43.11.111 )

2 (second server will be used only as a dialer - have pointed mysql ip to main server (71.43.11.113)

> below is from file etc/astguiclient - off server #2

Code: Select all

# Database connection information
VARDB_server => 71.43.11.111
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_port => 3306


but this gives me this error

Code: Select all

MySQL connect ERROR: Lost connection to MySQL server at 'reading initial communication packet', system error: 113

I have also change the DB settings in /var/www/html/vicidial/dbconnect.php and /var/www/html/agc2/dbconncet.php

now I have a different main server and this works fine - so this must have somethign to do with a setting in my main server - even though I just dumped the database from the old to new server ... any one have any ideas??

[omarrodriguezt]

Do you have a firewall activated in your DB server?

Are you able to connect to the data base server from other PC?

[tommyinnn]

I ran /etc/init.d/iptables stop

From another pc??

[tommyinnn]

Can someone else help me out on this? I've checked over everything I know of, made sure the etc/astguiclient.conf file is correct, set the /etc/httpd/conf.d/phpmyadmin.conf file to accept from all -

I do have this working on another server, 2 servers, 1 database
VERSION: 2.2.1-237
BUILD: 100510-2015

But can't figure out why it won't work on my newest installation/server



any ideas would be very appreciated.

[omarrodriguezt]

Are you able to loggin to your DB server from another PC?

[tommyinnn]

From another PC ?? Yes, I can access both databases on both servers for a PC ?@#?

[omarrodriguezt]

"
re: Lost connection to MySQL server at 'reading initial communication packet'

Odd, after playing around with removing the bind address and restarting, it seems to be working fine again. It wasn't before, but oh well, it's working! Thanks for everyone's time.
"
From:

http://bytes.com/topic/mysql/answers/84 ... ion-packet

Let us know if work for you.

[tommyinnn]

Thanks for that tip omarrodriguezt ... I'm going to look into this...

[omarrodriguezt]

Ok

[tommyinnn]

That just tells me to edit bind-adress - which is not in my my.cnf file

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-name-resolve
skip-host-cache
max_connections=200

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


The problem is only on this server - works fine on other servers with same installation method

any other ideas??

[williamconley]

what happens when you try

Code: Select all

mysql -h xxx.xxx.xxx.xxx -u cron -p

from another box?

also, you SHOULD have

Code: Select all

bind-address            = xxx.xxx.xxx.xxx

if you want to access this box via mysql from another box
and you should NOT have skip-networking