{"action":"created","issue":{"url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/2","repository_url":"https://api.github.com/repos/pruiz/kannel-sqlbox","labels_url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/2/comments","events_url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/2/events","html_url":"https://github.com/pruiz/kannel-sqlbox/issues/2","id":345952111,"node_id":"MDU6SXNzdWUzNDU5NTIxMTE=","number":2,"title":"sqlbox failed with PANIC: Trying to fetch variable `ssl-client-cipher-list' in group `sqlbox'.","user":{"login":"k0k","id":1683959,"node_id":"MDQ6VXNlcjE2ODM5NTk=","avatar_url":"https://avatars2.githubusercontent.com/u/1683959?v=4","gravatar_id":"","url":"https://api.github.com/users/k0k","html_url":"https://github.com/k0k","followers_url":"https://api.github.com/users/k0k/followers","following_url":"https://api.github.com/users/k0k/following{/other_user}","gists_url":"https://api.github.com/users/k0k/gists{/gist_id}","starred_url":"https://api.github.com/users/k0k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k0k/subscriptions","organizations_url":"https://api.github.com/users/k0k/orgs","repos_url":"https://api.github.com/users/k0k/repos","events_url":"https://api.github.com/users/k0k/events{/privacy}","received_events_url":"https://api.github.com/users/k0k/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-30T21:59:53Z","updated_at":"2018-07-30T22:15:47Z","closed_at":null,"author_association":"NONE","body":"(root) # sqlbox /etc/kannel/sqlbox.conf \r\n2018-07-30 21:23:35 [69224] [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0\r\n2018-07-30 21:23:35 [69224] [0] DEBUG: Kannel sqlbox version `1.4.5'.\r\nBuild `Jul 10 2018 15:15:19', compiler `4.4.7 20120313 (Red Hat 4.4.7-23)'.\r\nSystem Linux, release 2.6.32-754.2.1.el6.x86_64, version #1 SMP Tue Jul 3 16:37:52 EDT 2018, machine x86_64.\r\nHostname ecsms01.cns.ti.local, IP 172.16.66.131.\r\nLibxml version 2.7.6.\r\nUsing OpenSSL 1.0.1e-fips 11 Feb 2013.\r\nCompiled with MySQL 5.1.73, using MySQL 5.1.73.\r\nUsing native malloc.\r\n\r\n**2018-07-30 21:23:35 [69224] [0] PANIC: Trying to fetch variable `ssl-client-cipher-list' in group `sqlbox', not allowed.**\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox(gw_backtrace+0xae) [0x4283fe]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox(gw_panic+0x159) [0x428569]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox(cfg_get_real+0xcd) [0x415fad]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox(conn_config_ssl+0x108) [0x417b98]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox(main+0x186) [0x40b866]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: /lib64/libc.so.6(__libc_start_main+0xfd) [0x327b81ed1d]\r\n2018-07-30 21:23:35 [69224] [0] PANIC: sqlbox() [0x40a909]\r\n#\r\n\r\nThis bugs is known?, I try added ssl-client-cipher-list on config file  /etc/kannel/sqlbox.conf but it say:\r\nERROR: Group 'sqlbox' may not contain field 'ssl-client-cipher-list', also I check sources about definition of configuration groups and variables(sqlbox-cfg.def) on my installation,  it's very different to trunk/sqlbox/gw/sqlbox-cfg.def\r\n\r\n[root@ecsms01 gw]# diff -Nru sqlbox-cfg.def trunk-sqlbox-cfg.def\r\n--- sqlbox-cfg.def\t2008-11-03 11:33:15.000000000 -0800\r\n+++ trunk-sqlbox-cfg.def\t2018-07-30 14:55:38.356338781 -0700\r\n@@ -17,8 +17,14 @@\r\n     OCTSTR(log-file)\r\n     OCTSTR(log-level)\r\n     OCTSTR(bearerbox-port)\r\n\\+    OCTSTR(limit-per-cycle)\r\n\\+    OCTSTR(save-mo)\r\n\\+    OCTSTR(save-mt)\r\n\\+    OCTSTR(save-dlr)\r\n     OCTSTR(ssl-client-certkey-file)\r\n     OCTSTR(ssl-server-cert-file)\r\n     OCTSTR(ssl-server-key-file)\r\n     OCTSTR(ssl-trusted-ca-file)\r\n\\+    OCTSTR(ssl-client-cipher-list)\r\n\\+    OCTSTR(ssl-server-cipher-list)\r\n )\r\nssl-client-cipher-list only is available on trunk github, I download sqlbox from https://www.kannel.org/~aguerrieri/SqlBox/Releases/sqlbox-latest.tar.gz\r\n\r\nCheers."},"comment":{"url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/comments/409029738","html_url":"https://github.com/pruiz/kannel-sqlbox/issues/2#issuecomment-409029738","issue_url":"https://api.github.com/repos/pruiz/kannel-sqlbox/issues/2","id":409029738,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTAyOTczOA==","user":{"login":"k0k","id":1683959,"node_id":"MDQ6VXNlcjE2ODM5NTk=","avatar_url":"https://avatars2.githubusercontent.com/u/1683959?v=4","gravatar_id":"","url":"https://api.github.com/users/k0k","html_url":"https://github.com/k0k","followers_url":"https://api.github.com/users/k0k/followers","following_url":"https://api.github.com/users/k0k/following{/other_user}","gists_url":"https://api.github.com/users/k0k/gists{/gist_id}","starred_url":"https://api.github.com/users/k0k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k0k/subscriptions","organizations_url":"https://api.github.com/users/k0k/orgs","repos_url":"https://api.github.com/users/k0k/repos","events_url":"https://api.github.com/users/k0k/events{/privacy}","received_events_url":"https://api.github.com/users/k0k/received_events","type":"User","site_admin":false},"created_at":"2018-07-30T22:15:47Z","updated_at":"2018-07-30T22:15:47Z","author_association":"NONE","body":"I downloaded kannel-sqlbox-master.zip later compile i received a diferent error: \r\n2018-07-30 22:07:46 [13682] [0] PANIC: Trying to fetch variable `sql-engine' in group `sqlbox', not allowed.\r\n\r\nI modified sqlbox-cfg.def one more time:\r\n\r\nSINGLE_GROUP(sqlbox,\r\n    OCTSTR(id)\r\n    OCTSTR(smsbox-id)\r\n    OCTSTR(global-sender)\r\n    OCTSTR(bearerbox-host)\r\n    OCTSTR(smsbox-port)\r\n    OCTSTR(smsbox-port-ssl)\r\n    OCTSTR(sql-log-table)\r\n    OCTSTR(sql-insert-table)\r\n    OCTSTR(log-file)\r\n    OCTSTR(log-level)\r\n    OCTSTR(bearerbox-port)\r\n    OCTSTR(limit-per-cycle)\r\n    OCTSTR(save-mo)\r\n    OCTSTR(save-mt)\r\n    OCTSTR(save-dlr)\r\n    OCTSTR(ssl-client-certkey-file)\r\n    OCTSTR(ssl-server-cert-file)\r\n    OCTSTR(ssl-server-key-file)\r\n    OCTSTR(ssl-trusted-ca-file)\r\n    OCTSTR(ssl-client-cipher-list)\r\n    OCTSTR(ssl-server-cipher-list)\r\n\\+    OCTSTR(sql-engine)\r\n)\r\n\r\nand on sqlbox config file set variable sql-engine = mysql, now it worked like a charm.\r\n\r\nCheers.\r\n\r\n\r\n\r\n "}}
{"actor":{"display_login":"k0k"}}