Re: Sqlbox log not logging information
Can you try logging to /tmp? That would rule out any permissions problems. On Mon, Jun 16, 2014 at 9:31 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Dude Yes, sqlbox shows similar to sqlbox: rt@perusms8:~# lsof |grep box |grep /var/log bearerbox 1383 root 15w REG8,1 385623 22937901 /var/log/kannel/bearerbox.log bearerbox 1383 root 16w REG8,110936 22937815 /var/log/kannel/beareraccess.log bearerbox 1383 root 29w REG8,1 980219 22937912 /var/log/kannel/peru-c1.log bearerbox 1383 root 33w REG8,1 1917175 22939646 /var/log/kannel/peru-c2.log bearerbox 1383 root 37w REG8,1 676042 22939653 /var/log/kannel/peru-c3.log bearerbox 1383 root 40w REG8,1 676042 22939654 /var/log/kannel/peru-c4.log bearerbox 1383 root 44w REG8,1 3025 22937911 /var/log/kannel/nextel1.log bearerbox 1383 root 53w REG8,1 3035 22939657 /var/log/kannel/smsc2email.log wapbox1434 root6w REG8,119028 22939660 /var/log/kannel/wapbox.log wapbox1434 root7w REG8,1 246 22939659 /var/log/kannel/wapaccess.log sqlbox1727 root6w REG8,1 212609 22939658 /var/log/kannel/sqlbox.log smsbox1918 root6w REG8,1 274619 22939656 /var/log/kannel/smsbox.log smsbox1918 root7w REG8,1 7221 22939655 /var/log/kannel/smsaccess.log Permissions are even greater than for bearerbox and smsbox; Starnge thing is that on start sqlbox logs its start. After initializing mysql connections nothing. Like if it changes to a user that have no write rights after that initial log. -rw-r- 1 root root 387141 jun 16 20:23 bearerbox.log -rw-r- 1 root root 274619 jun 16 20:19 smsbox.log -rw-r- 1 root root 10936 jun 16 20:19 beareraccess.log -rw-r--r-- 1 root root 212609 jun 16 18:13 sqlbox.log -rw-r- 1 root root 19028 jun 16 18:13 wapbox.log Sql is launched in the same way other boxes. root@perusms8:~# ps aux | grep kannel root 1381 0.0 0.0 26160 856 ?Ss 18:13 0:00 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1383 0.1 0.0 1397568 3116 ?Sl 18:13 0:09 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1432 0.0 0.0 25988 856 ?Ss 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1434 0.0 0.0 411864 2340 ?Sl 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1725 0.0 0.0 25588 868 ?Ss 18:13 0:00 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1727 0.0 0.0 109788 1824 ?Sl 18:13 0:02 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1916 0.0 0.0 25760 860 ?Ss 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 1918 0.0 0.0 634756 2072 ?Sl 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 7329 0.0 0.0 11928 936 pts/24 S+ 20:27 0:00 grep --color=auto kannel Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Sun, Jun 15, 2014 at 6:05 AM, [Digital^Dude] ® millennium@gmail.com wrote: Do you see sqlbox.log in lsof like the other kannel log files? If yes, is the file writable? Also, please show the result of ps aux | grep kannel result.
Re: Sqlbox log not logging information
Or run without --daemonize, it'll run in foreground and log to STDOUT. On Tue, Jun 17, 2014 at 9:41 AM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: Can you try logging to /tmp? That would rule out any permissions problems. On Mon, Jun 16, 2014 at 9:31 PM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi Dude Yes, sqlbox shows similar to sqlbox: rt@perusms8:~# lsof |grep box |grep /var/log bearerbox 1383 root 15w REG8,1 385623 22937901 /var/log/kannel/bearerbox.log bearerbox 1383 root 16w REG8,110936 22937815 /var/log/kannel/beareraccess.log bearerbox 1383 root 29w REG8,1 980219 22937912 /var/log/kannel/peru-c1.log bearerbox 1383 root 33w REG8,1 1917175 22939646 /var/log/kannel/peru-c2.log bearerbox 1383 root 37w REG8,1 676042 22939653 /var/log/kannel/peru-c3.log bearerbox 1383 root 40w REG8,1 676042 22939654 /var/log/kannel/peru-c4.log bearerbox 1383 root 44w REG8,1 3025 22937911 /var/log/kannel/nextel1.log bearerbox 1383 root 53w REG8,1 3035 22939657 /var/log/kannel/smsc2email.log wapbox1434 root6w REG8,119028 22939660 /var/log/kannel/wapbox.log wapbox1434 root7w REG8,1 246 22939659 /var/log/kannel/wapaccess.log sqlbox1727 root6w REG8,1 212609 22939658 /var/log/kannel/sqlbox.log smsbox1918 root6w REG8,1 274619 22939656 /var/log/kannel/smsbox.log smsbox1918 root7w REG8,1 7221 22939655 /var/log/kannel/smsaccess.log Permissions are even greater than for bearerbox and smsbox; Starnge thing is that on start sqlbox logs its start. After initializing mysql connections nothing. Like if it changes to a user that have no write rights after that initial log. -rw-r- 1 root root 387141 jun 16 20:23 bearerbox.log -rw-r- 1 root root 274619 jun 16 20:19 smsbox.log -rw-r- 1 root root 10936 jun 16 20:19 beareraccess.log -rw-r--r-- 1 root root 212609 jun 16 18:13 sqlbox.log -rw-r- 1 root root 19028 jun 16 18:13 wapbox.log Sql is launched in the same way other boxes. root@perusms8:~# ps aux | grep kannel root 1381 0.0 0.0 26160 856 ?Ss 18:13 0:00 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1383 0.1 0.0 1397568 3116 ?Sl 18:13 0:09 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1432 0.0 0.0 25988 856 ?Ss 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1434 0.0 0.0 411864 2340 ?Sl 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1725 0.0 0.0 25588 868 ?Ss 18:13 0:00 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1727 0.0 0.0 109788 1824 ?Sl 18:13 0:02 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1916 0.0 0.0 25760 860 ?Ss 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 1918 0.0 0.0 634756 2072 ?Sl 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 7329 0.0 0.0 11928 936 pts/24 S+ 20:27 0:00 grep --color=auto kannel Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Sun, Jun 15, 2014 at 6:05 AM, [Digital^Dude] ® millennium@gmail.com wrote: Do you see sqlbox.log in lsof like the other kannel log files? If yes, is the file writable? Also, please show the result of ps aux | grep kannel result.
Re: Sqlbox log not logging information
Hi Dude Yes, sqlbox shows similar to sqlbox: rt@perusms8:~# lsof |grep box |grep /var/log bearerbox 1383 root 15w REG8,1 385623 22937901 /var/log/kannel/bearerbox.log bearerbox 1383 root 16w REG8,110936 22937815 /var/log/kannel/beareraccess.log bearerbox 1383 root 29w REG8,1 980219 22937912 /var/log/kannel/peru-c1.log bearerbox 1383 root 33w REG8,1 1917175 22939646 /var/log/kannel/peru-c2.log bearerbox 1383 root 37w REG8,1 676042 22939653 /var/log/kannel/peru-c3.log bearerbox 1383 root 40w REG8,1 676042 22939654 /var/log/kannel/peru-c4.log bearerbox 1383 root 44w REG8,1 3025 22937911 /var/log/kannel/nextel1.log bearerbox 1383 root 53w REG8,1 3035 22939657 /var/log/kannel/smsc2email.log wapbox1434 root6w REG8,119028 22939660 /var/log/kannel/wapbox.log wapbox1434 root7w REG8,1 246 22939659 /var/log/kannel/wapaccess.log sqlbox1727 root6w REG8,1 212609 22939658 /var/log/kannel/sqlbox.log smsbox1918 root6w REG8,1 274619 22939656 /var/log/kannel/smsbox.log smsbox1918 root7w REG8,1 7221 22939655 /var/log/kannel/smsaccess.log Permissions are even greater than for bearerbox and smsbox; Starnge thing is that on start sqlbox logs its start. After initializing mysql connections nothing. Like if it changes to a user that have no write rights after that initial log. -rw-r- 1 root root 387141 jun 16 20:23 bearerbox.log -rw-r- 1 root root 274619 jun 16 20:19 smsbox.log -rw-r- 1 root root 10936 jun 16 20:19 beareraccess.log -rw-r--r-- 1 root root 212609 jun 16 18:13 sqlbox.log -rw-r- 1 root root 19028 jun 16 18:13 wapbox.log Sql is launched in the same way other boxes. root@perusms8:~# ps aux | grep kannel root 1381 0.0 0.0 26160 856 ?Ss 18:13 0:00 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1383 0.1 0.0 1397568 3116 ?Sl 18:13 0:09 /usr/local/sbin/bearerbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_bbox.pid /etc/kannel/kannel.conf root 1432 0.0 0.0 25988 856 ?Ss 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1434 0.0 0.0 411864 2340 ?Sl 18:13 0:00 /usr/local/sbin/wapbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_wbox.pid /etc/kannel/kannel.conf root 1725 0.0 0.0 25588 868 ?Ss 18:13 0:00 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1727 0.0 0.0 109788 1824 ?Sl 18:13 0:02 /usr/local/sbin/sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid /etc/kannel/sqlbox.conf root 1916 0.0 0.0 25760 860 ?Ss 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 1918 0.0 0.0 634756 2072 ?Sl 18:13 0:00 /usr/local/sbin/smsbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sbox.pid /etc/kannel/kannel.conf root 7329 0.0 0.0 11928 936 pts/24 S+ 20:27 0:00 grep --color=auto kannel Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com On Sun, Jun 15, 2014 at 6:05 AM, [Digital^Dude] ® millennium@gmail.com wrote: Do you see sqlbox.log in lsof like the other kannel log files? If yes, is the file writable? Also, please show the result of ps aux | grep kannel result.
Re: Sqlbox log not logging information
Do you see sqlbox.log in lsof like the other kannel log files? If yes, is the file writable? Also, please show the result of ps aux | grep kannel result.
Re: Sqlbox log not logging information
Don't you need v=1 for logs? I use this: sqlbox -v 1 /etc/sqlbox.conf and then tail -f sqlbox.log On Sat, Jun 14, 2014 at 5:12 AM, Alvaro Cornejo cornejo.alv...@gmail.com wrote: Hi I still can´t see anything on my sqlbox.log eventhough it is in debug mode ( v=0) I get only the start lines log and that is it. After it is started nothing. Not even at sqlbox shutdown. I tried to run it as kannel user and root but still nothing. What could be wrong? I do have some other issues but without logs is quite difficult to pin point the issue. user@peru8:/etc/init.d# tail -f -n 500 /var/log/kannel/sqlbox.log 2014-06-12 23:04:31 [29053] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2014-06-12 23:04:31 [29053] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 29053. 2014-06-12 23:04:31 [29053] [1] DEBUG: Connecting to 127.0.0.1 2014-06-12 23:04:31 [29053] [1] INFO: Connected to bearerbox at localhost port 13001. 2014-06-12 23:04:31 [29053] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2014-06-12 23:04:31 [29053] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 29053. group = sqlbox id = sqlbox-db smsbox-id = sqlbox 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 I have run ssqlbox like sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid sqlbox.conf and sqlbox -v 0 sqlbox.conf with the same results. Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com
Sqlbox log not logging information
Hi I still can´t see anything on my sqlbox.log eventhough it is in debug mode ( v=0) I get only the start lines log and that is it. After it is started nothing. Not even at sqlbox shutdown. I tried to run it as kannel user and root but still nothing. What could be wrong? I do have some other issues but without logs is quite difficult to pin point the issue. user@peru8:/etc/init.d# tail -f -n 500 /var/log/kannel/sqlbox.log 2014-06-12 23:04:31 [29053] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: Connected to server at localhost. 2014-06-12 23:04:31 [29053] [0] INFO: MYSQL: server version 5.5.37-0ubuntu0.12.04.1, client version 5.5.37. 2014-06-12 23:04:31 [29053] [0] DEBUG: Started thread 1 (sqlbox.c:sql_to_bearerbox) 2014-06-12 23:04:31 [29053] [1] DEBUG: Thread 1 (sqlbox.c:sql_to_bearerbox) maps to pid 29053. 2014-06-12 23:04:31 [29053] [1] DEBUG: Connecting to 127.0.0.1 2014-06-12 23:04:31 [29053] [1] INFO: Connected to bearerbox at localhost port 13001. 2014-06-12 23:04:31 [29053] [1] DEBUG: Started thread 2 (sqlbox.c:bearerbox_to_sql) 2014-06-12 23:04:31 [29053] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) maps to pid 29053. group = sqlbox id = sqlbox-db smsbox-id = sqlbox 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 I have run ssqlbox like sqlbox -v 0 --parachute --daemonize --pid-file /var/run/kannel_sqlbox.pid sqlbox.conf and sqlbox -v 0 sqlbox.conf with the same results. Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com