that did it! thanks Cezary! :)
the port option was not mentioned on the example docs, and I hadn't seen it on the code On Nov 14, 2007 3:58 PM, Cezary Siwek <[EMAIL PROTECTED]> wrote: > > > 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: [email protected] > 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 > > > >
