Hi Anand, whats the output of mysql> show create table your_mysql_dlr_table
i am using pgsql storage atm, but used to have mysql based as well can you paste several lines from that: fgrep -i insert path_to_logs/kannel.log regards seik -----Original Message----- From: Anand Gupta [EMAIL PROTECTED] Sent: 22 ??? 2007 ?. To: seik Subject:smsc name inside mysql dlr > Does no one have any idea / solution on this ? > Anand Gupta wrote: >> Hi! >> >> I am using mysql dlr with kannel. Now inside mysql, kannel stores the >> smsc-id inside smsc column. It seems that kannel is truncating first >> few chars of the smsc-id at random. When the deliver_sm_resp comes, >> kannel again truncates at random and then gets confused about the >> delivery report. >> >> Example >> >> smsc-id = "MY_PROVIDER" >> >> While submitting message, kannel inserts "_PROVIDER" inside smsc >> column. When getting deliver_sm, kannel searches for "Y_PROVIDER". >> >> Is there any setting i need to do for getting kannel to insert proper >> smsc name inside mysql ? >> >> Here is my kannel config >> >> ********************************************** >> ....snipped >> ********************************************** >> Thanks. >>
