Please share to the kannel group how you fixed it. J
On Sun, Nov 14, 2010 at 10:47 AM, Harbhag Singh Sohal < [email protected]> wrote: > I have fixed my problem now. > > On Sat, Nov 13, 2010 at 9:39 AM, Harbhag Singh Sohal > <[email protected]> wrote: > > The sent sms is not properly stored in database. In the msdata field > > of sent_sms table there are strange characters instead of content of > > sent sms. > > Below are config files. > > > > KANNEL.CONF > > > > #Sample configuration file for Kannel bearerbox on Debian. > > # See the documentation for explanations of fields. > > # > > > > # HTTP administration is disabled by default. Make sure you set the > > # password if you enable it. > > > > group = core > > admin-port = 13015 > > admin-password = hard2guess > > admin-deny-ip = "*.*.*.*" > > admin-allow-ip = "127.0.0.1" > > dlr-storage = internal > > smsbox-port = 13016 > > #wdp-interface-name = "*" > > log-file = "/var/log/kannel/bearerbox.log" > > access-log = "/var/log/kannel/access.log" > > box-deny-ip = "*.*.*.*" > > box-allow-ip = "127.0.0.1" > > log-level = 1 > > > > #group = wapbox > > #bearerbox-host = localhost > > #log-file = "/var/log/kannel/wapbox.log" > > > > group = smsc > > smsc-id = MediaTek > > smsc = at > > modemtype = MediaTek > > device= /dev/ttyACM0 > > my-number = +919417212503 > > connect-allow-ip = 127.0.0.1 > > log-level = 0 > > > > > > group = modems > > id = MediaTek > > name = "MediaTek" > > detect-string = "MediaTek" > > #init-string = "ATZ" > > init-string = "AT Q0 V1 E1 S0=0 &C1 &D2 +FCLASS=0" > > init-string = "AT+CNMI=2,1,2,2,0" > > message-storage = sm > > #speed = 460800 > > #message-start = 0 > > > > group = smsbox > > smsbox-id = mysmsc > > bearerbox-host = localhost > > #bearerbox-port = 13018 > > sendsms-port = 13018 > > global-sender = *************** > > access-log = "/var/log/kannel/smsbox-access.log" > > log-file = "/var/log/kannel/smsbox.log" > > log-level = 0 > > mo-recode = true > > > > group = sendsms-user > > username = *************** > > password = hard2guess > > concatenation= true > > max-messages = 10000 > > > > group = sms-service > > keyword-regex = .* > > catch-all = yes > > accepted-smsc = MediaTek > > max-messages = 3 > > get-url = "http://localhost/sms.php?phone=%p&text=%a"; > > > > SQLBOX.CONF > > > > group = sqlbox > > id = sqlbox-db > > smsbox-id = mysmsc > > global-sender = "***************" > > bearerbox-host = localhost > > bearerbox-port = 13016 > > smsbox-port = 13017 > > smsbox-port-ssl = false > > sql-log-table = sent_sms > > sql-insert-table = send_sms > > log-file = "/var/log/kannel/kannel-sqlbox.log" > > log-level = 0 > > #ssl-client-certkey-file = "" > > #ssl-server-cert-file = "" > > #ssl-server-key-file = "" > > #ssl-trusted-ca-file = "" > > > > # Database connection examples. Please uncomment as needed > > > > # Example MYSQL Connection > > group = mysql-connection > > id = sqlbox-db > > host = localhost > > username = *************** > > password = *************** > > database = kannel > > > > # Example ORACLE Connection > > #group = oracle-connection > > #id = sqlbox-db > > #username = myuser > > #password = mypass > > #tnsname = //localhost:1521/XE > > > > # Example POSTGRESQL Connection > > #group = pgsql-connection > > #id = sqlbox-db > > #id = sqlbox-db > > #username = myuser > > #password = mypass > > #database = kannel > > #host = localhost > > > > # Example SDB Connection with some database URL examples > > # *** Note: Uncomment only _one_ "url" line *** > > #group = sdb-connection > > #id = sqlbox-db > > #url = mysql:host=localhost:db=kannel:uid=myuser:pwd=mypass > > #url = sqlite:db=/path/to/kannel.db > > #url = sqlite3:db=/path/to/kannel3.db > > > > # Example SQLITE 2 Connection > > #group = sqlite-connection > > #id = sqlbox-db > > #database = /path/to/kannel.db > > #max-connections = 1 > > > > # Example SQLITE 3 Connection > > #group = sqlite3-connection > > #id = sqlbox-db > > #database = /path/to/kannel.db > > #max-connections = 1 > > > > > > Kannel version : > > Kannel bearerbox version `svn-r4871M'. > > Build `Nov 12 2010 17:56:44', compiler `4.4.3'. > > System Linux, release 2.6.32-25-generic, version #45-Ubuntu SMP Sat > > Oct 16 19:52:42 UTC 2010, machine x86_64. > > Libxml version 2.7.6. > > Compiled with MySQL 5.1.41, using MySQL 5.1.41. > > Using native malloc. > > > > Sqlbox Version: > > Kannel sqlbox version `svn-r4871M'. > > Build `Nov 12 2010 17:56:44', compiler `4.4.3'. > > System Linux, release 2.6.32-25-generic, version #45-Ubuntu SMP Sat > > Oct 16 19:52:42 UTC 2010, machine x86_64. > > Libxml version 2.7.6. > > Compiled with MySQL 5.1.41, using MySQL 5.1.41. > > Using native malloc. > > > > > > -- > Harbhag Singh Sohal > Department of Information Technology > Guru Nanak Dev Engineering College, Ludhiana > > Webpage : http://harbhag.wordpress.com > Twitter : http://twitter.com/harbhag > >
