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)
>>
>>
>>
