Well this is not Kannel's topic I guess. Check your my.cnf is it allowing other host to connect? After that add privilege in your MySQL to the host you want to connect from.
On Aug 29, 2011, at 5:39 AM, Vijay kumar Dadhich wrote: > Hello to all, > I am using kannel with dlr-storage = mysql successfully,and i want to > use SQLBOX in kannel application,we > want to connect our sql server(192.168.19.1) to linux's mysql > server(192.168.19.4). > My flow is look like as > web/user interface-->SQL Server(another server)-->KANNEL (i think > after SQLBOX flow is look like > as)-->bearerbox-->send_sms-->sent_sms-->smsbox(mysql) > > >> In LAN we are connected these three server-2 windows > 1.windows server(web/user interface)-192.168.19.3 > 2. database serve (sql server)-192.168.19.3 > 3.192.168.19.4 > Now i am using these step to connect mysql database. > # /sbin/iptables -A INPUT -i eth0 -s 192.168.19.4 -p tcp > --destination-port 3306 -j ACCEPT > # service iptables save > # iptables -F > > #/etc/init.d/mysqld restart > # service iptales start > when i do telnet then it is not connect with mysql telnet is showing > this message. please find the attachemts,which is snapshoots of telnet > with three ipaddress 1. 192.168.19.4 2. 127.0.0.1 > 3.192.168.19.1 it is showing like this for linux ip. > > telnet 192.168.19.4 3306 > trying 192.168.19.4... > connected to 192.168.19.4 (192.168.19.4). > Escape charcter is '^]'. > EHost '192.168.19.4' is not allowed to connact to this MySQL > serverConnection closed by foriegn host > please help me it's urgent. > > telnet 192.168.19.1 3306 > trying 192.168.19.1... > telnet: connect to address 192.168.19.1 : connection refused > telnet: unable to connect to remote host : connection refused > > telnet 192.168.19.4 3306 > trying 192.168.19.4... > connected to 192.168.19.4 (192.168.19.4). > Escape charcter is '^]'. > 4. > 5.0.77c/%@PU7T,$QMof2e(5qYM after some second Connection closed by foriegn > host > > I can't undestand,please help me.please help me it's urgent. > -- > Vijay Kr. Dadhich > Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/
