Sorry for commenting on my own post, resolution was found by compiling sqlbox again with new include files: smsc:~/sqlbox-0.7.2# ./configure --with-kannel-dir=/usr/local/include
All working now. thanks Barry On Fri, 05 Nov 2010 10:45:55 +1300, Barry Murphy <[email protected]> wrote: > Sorry to the list this time... > > -------- Original Message -------- > Subject: Re: kannel via svn PANIC after 1.4.3 upgrade > Date: Fri, 05 Nov 2010 10:45:26 +1300 > From: Barry Murphy <[email protected]> > To: Juan Nin <[email protected]> > > Ok, > > I've now compiled with mysql support and when trying to send a message > (via sqlbox) the following error appears in the bearerbox.log file: > 2010-11-05 10:40:47 [12342] [15] ERROR: Packet too short while unpacking > Msg. > 2010-11-05 10:40:47 [12342] [15] ERROR: Msg packet was invalid. > 2010-11-05 10:40:47 [12342] [15] ERROR: Failed to unpack data! > 2010-11-05 10:40:47 [12342] [15] ERROR: Packet too short while unpacking > Msg. > 2010-11-05 10:40:47 [12342] [15] ERROR: Msg packet was invalid. > 2010-11-05 10:40:47 [12342] [15] ERROR: Failed to unpack data! > > Here is the output when loading the new version of kannel > /root/startnewkannel.sh > 2010-11-05 10:38:48 [12342] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:38:48 [12342] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:48 [12342] [0] INFO: DLR using storage type: mysql > 2010-11-05 10:38:48 [12342] [0] INFO: Added logfile > `/var/log/kannel/bearerbox.log' with level `0'. > 2010-11-05 10:38:48 [12342] [0] INFO: SSL not supported, no SSL > initialization done. > 2010-11-05 10:38:48 [12342] [0] INFO: HTTP: Opening server at port 13000. > 2010-11-05 10:38:48 [12342] [0] INFO: BOXC: 'smsbox-max-pending' not set, > using default (100). > 2010-11-05 10:38:48 [12342] [0] INFO: Set SMS resend frequency to 60 > seconds. > 2010-11-05 10:38:48 [12342] [0] INFO: SMS resend retry set to unlimited. > 2010-11-05 10:38:48 [12342] [0] INFO: Set throughput to 8.000 for smsc id > <smsexperts> > 2010-11-05 10:38:48 [12342] [0] INFO: DLR rerouting for smsc id > <smsexperts> disabled. > 2010-11-05 10:38:48 [12342] [0] INFO: Set throughput to 8.000 for smsc id > <amdtelecom> > 2010-11-05 10:38:48 [12342] [0] INFO: DLR rerouting for smsc id > <amdtelecom> disabled. > 2010-11-05 10:38:48 [12342] [0] INFO: DLR rerouting for smsc id > <smswarehouse> disabled. > 2010-11-05 10:38:48 [12342] [0] WARNING: SMPP: obsolete system-id variable > is set, use smsc-username instead. > 2010-11-05 10:38:48 [12342] [0] WARNING: SMPP: smsc-username not set, > using system-id instead > 2010-11-05 10:38:48 [12342] [0] INFO: DLR rerouting for smsc id <coolsms> > disabled. > 2010-11-05 10:38:48 [12342] [0] WARNING: SMPP: obsolete system-id variable > is set, use smsc-username instead. > 2010-11-05 10:38:48 [12342] [0] WARNING: SMPP: smsc-username not set, > using system-id instead > 2010-11-05 10:38:48 [12342] [0] INFO: > ---------------------------------------- > 2010-11-05 10:38:48 [12342] [0] INFO: Kannel bearerbox II version > svn-r4868 starting > 2010-11-05 10:38:48 [12342] [0] INFO: Loaded 0 messages from store. > 2010-11-05 10:38:48 [12342] [0] INFO: MAIN: Start-up done, entering > mainloop > 2010-11-05 10:38:49 [12356] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:38:49 [12356] [0] INFO: Starting to log to file > /var/log/kannel/smsbox.log level 0 > 2010-11-05 10:38:49 [12356] [0] INFO: Added logfile > `/var/log/kannel/smsbox.log' with level `0'. > 2010-11-05 10:38:49 [12356] [0] INFO: Service global sender set as > '6121234567' > 2010-11-05 10:38:49 [12356] [0] INFO: HTTP: Opening server at port 13013. > 2010-11-05 10:38:49 [12356] [0] INFO: Set up send sms service at port > 13013 > 2010-11-05 10:38:49 [12356] [0] WARNING: bool variable set to strange > value, assuming 'true' > 2010-11-05 10:38:49 [12342] [5] INFO: Client connected from <127.0.0.1> > 2010-11-05 10:38:49 [12356] [0] INFO: Connected to bearerbox at 127.0.0.1 > port 13001. > 2010-11-05 10:38:50 [12367] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:38:50 [12367] [0] INFO: Starting to log to file > /var/log/kannel/kannel-sqlbox.log level 0 > 2010-11-05 10:38:50 [12367] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > smsc:/usr/src/kannel-svn/trunk# 2010-11-05 10:38:50 [12367] [0] INFO: > MYSQL: Connected to server at 120.x.x.x. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:38:50 [12367] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:38:50 [12342] [5] INFO: Client connected from <127.0.0.1> > 2010-11-05 10:38:50 [12367] [1] INFO: Connected to bearerbox at localhost > port 13001. > > And the old version for reference sake: > smsc:/usr/src/kannel-svn/trunk# /root/startoldkannel.sh > sqlbox: no process killed > 2010-11-05 10:37:43 [12277] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: Connected to server at > 120.136.7.82. > 2010-11-05 10:37:43 [12277] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:43 [12277] [0] INFO: DLR using storage type: mysql > 2010-11-05 10:37:43 [12277] [0] INFO: Added logfile > `/var/log/kannel/bearerbox.log' with level `0'. > 2010-11-05 10:37:43 [12277] [0] WARNING: 'store-file' option deprecated, > please use 'store-location' and 'store-type' instead. > 2010-11-05 10:37:43 [12277] [0] INFO: SSL not supported, no SSL > initialization done. > 2010-11-05 10:37:43 [12277] [0] INFO: HTTP: Opening server at port 13000. > 2010-11-05 10:37:43 [12277] [0] INFO: BOXC: 'smsbox-max-pending' not set, > using default (100). > 2010-11-05 10:37:43 [12277] [0] INFO: Set SMS resend frequency to 60 > seconds. > 2010-11-05 10:37:43 [12277] [0] INFO: SMS resend retry set to unlimited. > 2010-11-05 10:37:43 [12277] [0] INFO: Set throughput to 8.000 for smsc id > <smsexperts> > 2010-11-05 10:37:43 [12277] [0] INFO: DLR rerouting for smsc id > <smsexperts> disabled. > 2010-11-05 10:37:43 [12277] [0] INFO: Set throughput to 8.000 for smsc id > <amdtelecom> > 2010-11-05 10:37:43 [12277] [0] INFO: DLR rerouting for smsc id > <amdtelecom> disabled. > 2010-11-05 10:37:43 [12277] [0] INFO: DLR rerouting for smsc id > <smswarehouse> disabled. > 2010-11-05 10:37:43 [12277] [0] WARNING: SMPP: obsolete system-id variable > is set, use smsc-username instead. > 2010-11-05 10:37:43 [12277] [0] WARNING: SMPP: smsc-username not set, > using system-id instead > 2010-11-05 10:37:43 [12277] [0] INFO: DLR rerouting for smsc id <coolsms> > disabled. > 2010-11-05 10:37:43 [12277] [0] WARNING: SMPP: obsolete system-id variable > is set, use smsc-username instead. > 2010-11-05 10:37:43 [12277] [0] WARNING: SMPP: smsc-username not set, > using system-id instead > 2010-11-05 10:37:43 [12277] [0] INFO: > ---------------------------------------- > 2010-11-05 10:37:43 [12277] [0] INFO: Kannel bearerbox II version 1.4.3 > starting > 2010-11-05 10:37:43 [12277] [0] INFO: Loading store file > `/root/kannel.store.file' > 2010-11-05 10:37:43 [12277] [0] INFO: Store-file size 596, starting to > unpack > 2010-11-05 10:37:43 [12277] [0] INFO: Retrieved 2 messages, > non-acknowledged messages: 2 > 2010-11-05 10:37:43 [12277] [0] INFO: MAIN: Start-up done, entering > mainloop > 2010-11-05 10:37:44 [12292] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:37:44 [12292] [0] INFO: Starting to log to file > /var/log/kannel/smsbox.log level 0 > 2010-11-05 10:37:44 [12292] [0] INFO: Added logfile > `/var/log/kannel/smsbox.log' with level `0'. > 2010-11-05 10:37:44 [12292] [0] INFO: Service global sender set as > '6121234567' > 2010-11-05 10:37:44 [12292] [0] INFO: HTTP: Opening server at port 13013. > 2010-11-05 10:37:44 [12292] [0] INFO: Set up send sms service at port > 13013 > 2010-11-05 10:37:44 [12292] [0] WARNING: bool variable set to strange > value, assuming 'true' > 2010-11-05 10:37:44 [12277] [5] INFO: Client connected from <127.0.0.1> > 2010-11-05 10:37:44 [12292] [0] INFO: Connected to bearerbox at 127.0.0.1 > port 13001. > 2010-11-05 10:37:44 [12292] [4] INFO: Starting delivery report <> from > <64274909712> > 2010-11-05 10:37:44 [12292] [4] INFO: Starting delivery report <(null)> > from <64274909712> > 2010-11-05 10:37:44 [12292] [9] ERROR: URL <> doesn't start with `http://' > nor `https://' > 2010-11-05 10:37:44 [12292] [9] ERROR: Couldn't send request to <> > 2010-11-05 10:37:44 [12292] [9] ERROR: URL <> doesn't start with `http://' > nor `https://' > 2010-11-05 10:37:44 [12292] [9] ERROR: Couldn't send request to <> > 2010-11-05 10:37:45 [12305] [0] INFO: Debug_lvl = 1, log_file = <none>, > log_lvl = 0 > 2010-11-05 10:37:45 [12305] [0] INFO: Starting to log to file > /var/log/kannel/kannel-sqlbox.log level 0 > 2010-11-05 10:37:45 [12305] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > smsc:/usr/src/kannel-svn/trunk# 2010-11-05 10:37:45 [12305] [0] INFO: > MYSQL: Connected to server at 120.x.x.x. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: Connected to server at > 120.x.x.x. > 2010-11-05 10:37:45 [12305] [0] INFO: MYSQL: server version 5.0.67, client > version 5.0.51a. > 2010-11-05 10:37:45 [12277] [5] INFO: Client connected from <127.0.0.1> > 2010-11-05 10:37:45 [12305] [1] INFO: Connected to bearerbox at localhost > port 13001. > > > > On Tue, 2 Nov 2010 22:21:38 -0200, Juan Nin <[email protected]> wrote: >> From: >> >> 2010-11-03 11:16:05 [2934] [0] PANIC: DLR: storage type 'mysql' is not >> supported! >> >> looks like your new Kannel was compiled without MySQL support >> >> Regards, >> >> Juan >> >> >> On Tue, Nov 2, 2010 at 8:20 PM, Barry Murphy <[email protected]> wrote: >>> Hi, >>> >>> I just downloaded kannel via SVN to upgrade my kannel 1.4.3 instance. >>> >>> When I start kannel, I see the following: >>> 2010-11-03 11:16:05 [2934] [0] INFO: Debug_lvl = 1, log_file = <none>, >>> log_lvl = 0 >>> 2010-11-03 11:16:05 [2934] [0] PANIC: DLR: storage type 'mysql' is not >>> supported! >>> 2010-11-03 11:16:05 [2934] [0] PANIC: >>> /usr/local/sbin/bearerbox(gw_panic+0xbc) [0x80d8dac] >>> 2010-11-03 11:16:05 [2934] [0] PANIC: >>> /usr/local/sbin/bearerbox(dlr_init+0x230) [0x8061400] >>> 2010-11-03 11:16:05 [2934] [0] PANIC: >>> /usr/local/sbin/bearerbox(main+0x10a) [0x8053c0a] >>> 2010-11-03 11:16:05 [2934] [0] PANIC: >>> /lib/libc.so.6(__libc_start_main+0xe5) [0xb7d18455] >>> 2010-11-03 11:16:05 [2934] [0] PANIC: /usr/local/sbin/bearerbox >>> [0x8052c01] >>> 2010-11-03 11:16:06 [2936] [0] INFO: Debug_lvl = 1, log_file = <none>, >>> log_lvl = 0 >>> 2010-11-03 11:16:06 [2936] [0] INFO: Starting to log to file >>> /var/log/kannel/smsbox.log level 0 >>> 2010-11-03 11:16:06 [2936] [0] INFO: Added logfile >>> `/var/log/kannel/smsbox.log' with level `0'. >>> 2010-11-03 11:16:06 [2936] [0] INFO: Service global sender set as >>> '6121234567' >>> 2010-11-03 11:16:06 [2936] [0] INFO: HTTP: Opening server at port > 13013. >>> 2010-11-03 11:16:06 [2936] [0] INFO: Set up send sms service at port >>> 13013 >>> 2010-11-03 11:16:06 [2936] [0] WARNING: bool variable set to strange >>> value, assuming 'true' >>> 2010-11-03 11:16:06 [2936] [0] ERROR: connect to <127.0.0.1> failed >>> 2010-11-03 11:16:06 [2936] [0] ERROR: System error 111: Connection >>> refused >>> 2010-11-03 11:16:06 [2936] [0] ERROR: error connecting to server >>> `127.0.0.1' at port `13001' >>> 2010-11-03 11:16:06 [2936] [0] PANIC: Couldn't connect to the > bearerbox. >>> 2010-11-03 11:16:06 [2936] [0] PANIC: >>> /usr/local/sbin/smsbox(gw_panic+0xbc) [0x8088b0c] >>> 2010-11-03 11:16:06 [2936] [0] PANIC: > /usr/local/sbin/smsbox(main+0xea9) >>> [0x8054789] >>> 2010-11-03 11:16:06 [2936] [0] PANIC: >>> /lib/libc.so.6(__libc_start_main+0xe5) [0xb7c8e455] >>> 2010-11-03 11:16:06 [2936] [0] PANIC: /usr/local/sbin/smsbox > [0x8053191] >>> 2010-11-03 11:16:07 [2944] [0] INFO: Debug_lvl = 1, log_file = <none>, >>> log_lvl = 0 >>> 2010-11-03 11:16:07 [2944] [0] INFO: Starting to log to file >>> /var/log/kannel/kannel-sqlbox.log level 0 >>> 2010-11-03 11:16:07 [2944] [0] INFO: Added logfile >>> `/var/log/kannel/kannel-sqlbox.log' with level `0'. >>> smsc:/usr/src/kannel-svn/trunk# 2010-11-03 11:16:07 [2944] [0] INFO: >>> MYSQL: Connected to server at 120.136.7.82. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: server version 5.0.67, > client >>> version 5.0.51a. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: Connected to server at >>> 120.136.7.82. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: server version 5.0.67, > client >>> version 5.0.51a. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: Connected to server at >>> 120.136.7.82. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: server version 5.0.67, > client >>> version 5.0.51a. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: Connected to server at >>> 120.136.7.82. >>> 2010-11-03 11:16:07 [2944] [0] INFO: MYSQL: server version 5.0.67, > client >>> version 5.0.51a. >>> 2010-11-03 11:16:07 [2944] [1] ERROR: connect failed >>> 2010-11-03 11:16:07 [2944] [1] ERROR: System error 111: Connection >>> refused >>> 2010-11-03 11:16:07 [2944] [1] ERROR: error connecting to server >>> `localhost' at port `13001' >>> >>> >>> With kannel version 1.4.3 I start it with: >>> cd /etc/kannel/ >>> /usr/local/kannel/sbin/bearerbox -v 1 /etc/kannel/kannel.conf & >>> /bin/sleep 1 >>> cd /etc/kannel/ >>> /usr/local/kannel/sbin/smsbox -v 1 /etc/kannel/kannel.conf & >>> /bin/sleep 1 >>> cd /etc/kannel/ >>> /usr/local/kannel/sbin/sqlbox -v 1 /etc/kannel/sqlbox.conf & >>> >>> With the new kannel, I killall the processes above and start with >>> cd /etc/kannel/ >>> /usr/local/sbin/bearerbox -v 1 /etc/kannel/kannel.conf & >>> /bin/sleep 1 >>> cd /etc/kannel/ >>> /usr/local/sbin/smsbox -v 1 /etc/kannel/kannel.conf & >>> /bin/sleep 1 >>> cd /etc/kannel/ >>> /usr/local/kannel/sbin/sqlbox -v 1 /etc/kannel/sqlbox.conf & >>> >>> I have reverted back to /usr/local/kannel/sbin binarys for now. >>> >>> thanks >>> barry >>> >>> >>> >>> >>> >>>
