hi, I had the same problem. you need to define port if you want to use remote db
port = 3306 (or the proper one of course) Regards, Cezary -----Original Message----- From: Juan Nin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 14, 2007 5:45 PM To: users@kannel.org Subject: Re: Re[2]: sqlbox does not connect to remote MySQL i'm using MySql 5, but the thing is that sqlbox is not trying to connect to the remote server I've already enabled the mysql logging, and I see nothing, and even more, I made a tcpdump on the remote DB server, and no packets arrive.. On 11/14/07, Alejandro Guerrieri <[EMAIL PROTECTED]> wrote: > Hmm, pretty strange. > > The only thing I can think of is about auth libraries. There's a > difference between 3.x and 4.x mysql authentication protocol, and if > for some reason the wrong protocol is used the login fails though the > mysql client library works fine. > > I'd check on the remote side to see if kannel is trying to connect > and, if possible, I'd raise the log level on mysql to see if there's > something on logfiles worth noting. > > Regards, > > Alejandro > > > On Nov 14, 2007 3:10 PM, Juan Nin <[EMAIL PROTECTED]> wrote: > > don't think so > > > > on my previous post i pasted some changes i made where it logs the > > panic error, and the host, username, passwd and db are fine > > > > not sure where the problem is :( > > > > > > On Nov 14, 2007 2:30 PM, Alejandro Guerrieri > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > No, this is to be able to connect to a remote bearerbox. > > > > > > Maybe there's a similar issue with mysql host? I'll check it out. > > > > > > Regards, > > > > > > Alejandro > > > > > > > > > > > > On Nov 14, 2007 1:53 PM, Juan Nin < [EMAIL PROTECTED]> wrote: > > > > Alejandro, > > > > > > > > is this needed for sqlbox to be able to connect to a remote mysql? > > > > > > > > thanks! > > > > > > > > Juan > > > > > > > > On Nov 14, 2007 1:41 PM, Alejandro Guerrieri > > > > > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > Here is my patch for sqlbox to take host into account: > > > > > > > > > > Index: gw/sqlbox.c > > > > > ============================== > > > > > ===================================== > > > > > RCS file: /home/cvs/ sqlbox/gw/sqlbox.c,v retrieving revision > > > > > 1.2 diff -u -r1.2 sqlbox.c > > > > > --- gw/sqlbox.c 30 May 2006 17:52:46 -0000 1.2 > > > > > +++ gw/sqlbox.c 3 Oct 2007 13:42:58 -0000 > > > > > @@ -600,7 +600,6 @@ > > > > > > > > > > /* some default values */ > > > > > sqlbox_port_ssl = 0; > > > > > - bearerbox_host = octstr_create(BB_DEFAULT_HOST); > > > > > bearerbox_port = BB_DEFAULT_SMSBOX_PORT; > > > > > bearerbox_port_ssl = 0; > > > > > logfile = NULL; > > > > > @@ -624,6 +623,10 @@ > > > > > if (grp == NULL) > > > > > panic(0, "No ' sqlbox' group in > > > > > configuration"); > > > > > > > > > > + bearerbox_host = cfg_get( grp, > octstr_imm("bearerbox-host")); > > > > > + if (bearerbox_host == NULL) > > > > > + bearerbox_host = octstr_create(BB_DEFAULT_HOST); > > > > > + > > > > > sqlbox_id = cfg_get(grp, octstr_imm("smsbox-id")); > > > > > global_sender = cfg_get(grp, > > > > > octstr_imm("global-sender")); > > > > > > > > > > > =========================================================== > > > > > > > > > > Hope it helps, > > > > > > > > > > Alejandro > > > > > > > > > > > > > > > > > > > > On Nov 14, 2007 1:06 PM, seik < [EMAIL PROTECTED]> wrote: > > > > > > I am about to do the same for sqlbox_pgsql.c :) > > > > > > > > > > > > no time so far :/ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Juan Nin [ [EMAIL PROTECTED] ] > > > > > > Sent: 14 ??????? 2007 ?. > > > > > > To: seik > > > > > > Subject:sqlbox does not connect to remote MySQL > > > > > > > > > > > > > mhmhm, I edited gw/sqlbox_mysql.c from the sqlbox source > > > > > > > and > > > modified > > > > > > > the panic line in the end so the code is like here below, > > > > > > > and > the DB > > > > > > > params are shown ok > > > > > > > > > > > > > > > > > > > /* > > > > > > > * ok, ready to connect to MySQL > > > > > > > */ > > > > > > > db_conf = gw_malloc(sizeof(DBConf)); > > > > > > > gw_assert(db_conf != NULL); > > > > > > > > > > > > > db_conf->mysql = gw_malloc(sizeof(MySQLConf)); > > > > > > > gw_assert(db_conf->mysql != NULL); > > > > > > > > > > > > > db_conf->mysql->host = mysql_host; > > > > > > > db_conf->mysql->username = mysql_user; > > > > > > > db_conf->mysql->password = mysql_pass; > > > > > > > db_conf->mysql->database = mysql_db; > > > > > > > if (have_port) { > > > > > > > db_conf->mysql->port = mysql_port; > > > > > > > } > > > > > > > > > > > > > pool = dbpool_create(DBPOOL_MYSQL, db_conf, pool_size); > > > > > > > gw_assert(pool != NULL); > > > > > > > > > > > > > /* > > > > > > > * XXX should a failing connect throw panic?! > > > > > > > */ > > > > > > > if (dbpool_conn_count(pool) == 0) > > > > > > > panic(0,"SQLBOX: MySQL: database pool has no > connections! > > > host > > > > > > > '%s' user '%s' pass '%s' db '%s'", > > > > > > > octstr_get_cstr(mysql_host), octstr_get_cstr(mysql_user), > > > > > > > octstr_get_cstr(mysql_pass), octstr_get_cstr(mysql_db)); > > > > > > > //panic(0,"SQLBOX: MySQL: database pool has no > > > connections!"); > > > > > > > > > > > > > > > > > > > > > > > > > On Nov 14, 2007 12:41 PM, seik < [EMAIL PROTECTED]> wrote: > > > > > > >> Err, > > > > > > >> i think its the same issue as the one with the bearerbox > > > > > > >> host > :/ > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> -----Original Message----- > > > > > > >> From: Juan Nin [ [EMAIL PROTECTED] > > > > > > >> Sent: 14 ??????? 2007 ?. > > > > > > >> To: seik > > > > > > >> Subject:sqlbox does not connect to remote MySQL > > > > > > >> > > > > > > >> > > > > > > >> > Hi! > > > > > > >> > > > > > > >> > I'm trying sqlbox, and I can't get it to connect to a > > > > > > >> > remote > > > MySQL > > > > > server... > > > > > > >> > It's really strange... > > > > > > >> > > > > > > >> > I got "dlr-storage = mysql" with the same settings and > > > > > > >> > it > > > connects > > > > > > >> > fine, but sqlbox does not... > > > > > > >> > if I run a local MySQ, using localhost it works fine, > > > > > > >> > but not > > > with a > > > > > > >> > remote one... > > > > > > >> > > > > > > >> > Here's the error I get: > > > > > > >> > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] INFO: Added logfile > > > > > > >> > `/var/log/kannel/sqlbox.log' with level `0'. > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] ERROR: MYSQL: can not > > > > > > >> > connect > to > > > > > database! > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] ERROR: MYSQL: Can't > > > > > > >> > connect > to > > > MySQL > > > > > > >> > server on '10.10.10.2' (111) > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: SQLBOX: MySQL: > database > > > pool > > > > > > >> > has no connections! > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > > > > >> > > /usr/local/kannel/sbin/sqlbox(gw_panic+0x15b) [0x4248ab] > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > > > > >> > > /usr/local/kannel/sbin/sqlbox(sqlbox_init_mysql+0x34f) > [0x40afdf] > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > > > > >> > > /usr/local/kannel/sbin/sqlbox(sqlbox_init_sql+0xb) > [0x40bfbb] > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > > > > >> > /usr/local/kannel/sbin/sqlbox(main+0x31f) > [0x409dcf] > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > > > > >> > /lib64/libc.so.6(__libc_start_main+0xf4) > [0x3460c1d8a4] > > > > > > >> > 2007-11-14 08:58:06 [18604] [0] PANIC: > > > /usr/local/kannel/sbin/sqlbox > > > > > [0x4099a9] > > > > > > >> > > > > > > >> > Here's the conf: > > > > > > >> > > > > > > >> > group = sqlbox > > > > > > >> > id = sqlbox-db > > > > > > >> > smsbox-id = smsbox > > > > > > >> > bearerbox-host = localhost > > > > > > >> > bearerbox-port = 13001 > > > > > > >> > smsbox-port = 13005 > > > > > > >> > smsbox-port-ssl = false > > > > > > >> > sql-log-table = sent_sms > > > > > > >> > sql-insert-table = send_sms > > > > > > >> > log-file = "/var/log/kannel/sqlbox.log" > > > > > > >> > log-level = 0 > > > > > > >> > > > > > > >> > group = mysql-connection id = sqlbox-db host = > > > > > > >> > 10.10.10.2 username = myUser password = myPass database > > > > > > >> > = kannel max-connections = 1 > > > > > > >> > > > > > > >> > And this is the conf for DLR which works fine: > > > > > > >> > > > > > > >> > group = mysql-connection id = mydlr host = 10.10.10.2 > > > > > > >> > username = myUser password = myPass database = kannel > > > > > > >> > max-connections = 1 > > > > > > >> > > > > > > >> > I even ran a tcpdump on the DB server, and I don't see > packets > > > > > > >> > arriving for the sqlbox connection... > > > > > > >> > any ideas??? > > > > > > >> > > > > > > >> > Thanks in advance, > > > > > > >> > > > > > > >> > Juan > > > > > > >> > > > > > > >> > PS: obviously connecting from the kannel host to the > > > > > > >> > remote > one > > > via > > > > > > >> > console works (same info as for DLRs which connects ok) > > > > > > >> > > > > > > >> > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Alejandro Guerrieri > > > > > Magicom > > > > > http://www.magicom-bcn.net/ > > > > > LinkedIn: http://www.linkedin.com/in/aguerrieri > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Alejandro Guerrieri > > > Magicom > > > http://www.magicom-bcn.net/ > > > LinkedIn: http://www.linkedin.com/in/aguerrieri > > > > > > > > -- > > Alejandro Guerrieri > Magicom > http://www.magicom-bcn.net/ > LinkedIn: http://www.linkedin.com/in/aguerrieri
