search

wdoekes / asterisk-chan-dongle

chan_dongle channel driver for Huawei UMTS cards, works with Asterisk 14+
Other
298 stars 104 forks source link

smsdb.c error-message #78

Open hhornung opened 4 years ago

hhornung commented 4 years ago

with the newest release (2/24/20) I receive the following error-message at startup: [2020-02-25 18:55:11] WARNING[10078] smsdb.c: Couldn't prepare statement 'INSERT INTO outgoing (key, refid) VALUES (?, 0) ON CONFLICT(key) DO UPDATE SET refid = CASE WHEN refid < 65535 THEN refid + 1 ELSE 0 END': near "ON": syntax error

How can I solve this?

best regards

ruijorgesilva1 commented 4 years ago

I have similar problem When doing Make gcc -g -O2 -O6 -Wno-old-style-declaration -I. -std=gnu99 -DAST_MODULE_SELF_SYM=__internal_chan_dongle_self -D_GNU_SOURCE -I/usr/include -I/usr/include -DHAVE_CONFIG_H -fvisibility=hidden -fPIC -Wall -Wextra -MD -MT smsdb.o -MF .smsdb.o.d -MP -o smsdb.o -c smsdb.c smsdb.c:26:21: fatal error: sqlite3.h: No such file or directory

include 

                 ^

compilation terminated. make: *** [smsdb.o] Error 1

hhornung commented 4 years ago

@ruijorgesilva1: you have to install sqlite3 first: sudo apt-get install libsqlite3-dev

ruijorgesilva1 commented 4 years ago

@hhornung Thank you! Everything went well!

Best Regards

magcks commented 4 years ago

@hhornung Please check the current version form #77

hhornung commented 4 years ago

still the same: [2020-02-27 09:45:22] WARNING[6721]: smsdb.c:77 init_stmt: Couldn't prepare statement 'INSERT OR REPLACE INTO incoming (key, seqorder, expiration, message) VALUES (?, ?, datetime(julianday(CURRENT_TIMESTAMP) + ? / 86400.0), ?)': table incoming has no column named expiration [||] Got Response for user's command:'OK'

magcks commented 4 years ago

Actually not the same. Do rm /var/lib/asterisk/smsdb.sqlite and restart asterisk.

hhornung commented 4 years ago

yes - that's right. The message is gone - tx :) raspbx*CLI> module load chan_dongle Loaded chan_dongle [2020-02-27 17:41:58] NOTICE[25152]: chan_dongle.c:1604 reload_config: [|] Loaded device [2020-02-27 17:41:58] NOTICE[25152]: chan_dongle.c:1604 reload_config: [||] Loaded device [2020-02-27 17:41:58] NOTICE[25152]: chan_dongle.c:1604 reload_config: [|||] Loaded device [2020-02-27 17:41:58] NOTICE[25152]: chan_dongle.c:1604 reload_config: [||||] Loaded device [2020-02-27 17:41:58] NOTICE[25152]: chan_dongle.c:1604 reload_config: [|||||] Loaded device == Registered channel type 'Dongle' (Huawei 3G Dongle Channel Driver) -- [|] Trying to connect on /dev/ttyUSB11... -- [|] Dongle has connected, initializing... -- [||] Trying to connect on /dev/ttyUSB14... -- [||] Dongle has connected, initializing... -- [|||] Trying to connect on /dev/ttyUSB8... -- [|||] Dongle has connected, initializing... -- [||||] Trying to connect on /dev/ttyUSB2... -- [||||] Dongle has connected, initializing... -- [|||||] Trying to connect on /dev/ttyUSB5... -- [|||||] Dongle has connected, initializing... [||] Got Response for user's command:'OK' [2020-02-27 17:41:58] NOTICE[25155]: at_response.c:1794 at_response: [||] Got Response for user's command:'OK' [|] Got Response for user's command:'OK' [2020-02-27 17:41:58] NOTICE[25154]: at_response.c:1794 at_response: [|] Got Response for user's command:'OK' [|||] Got Response for user's command:'OK' [2020-02-27 17:41:58] NOTICE[25156]: at_response.c:1794 at_response: [|||] Got Response for user's command:'OK' [|||||] Got Response for user's command:'OK' [2020-02-27 17:41:58] NOTICE[25158]: at_response.c:1794 at_response: [|||||] Got Response for user's command:'OK' [||||] Got Response for user's command:'OK' [2020-02-27 17:41:58] NOTICE[25157]: at_response.c:1794 at_response: [||||] Got Response for user's command:'OK' == Registered application 'DongleStatus' == Registered application 'DongleSendSMS' == Registered application 'DongleSendUSSD' == Manager registered action DongleShowDevices == Manager registered action DongleSendUSSD == Manager registered action DongleSendSMS == Manager registered action DongleSetCCWA == Manager registered action DongleReset == Manager registered action DongleRestart == Manager registered action DongleStop == Manager registered action DongleStart == Manager registered action DongleRemove == Manager registered action DongleReload Loaded chan_dongle.so => (Huawei 3G Dongle Channel Driver) -- [||||] Dongle initialized and ready -- [|||||] Dongle initialized and ready -- [|] Dongle initialized and ready -- [|||] Dongle initialized and ready -- [||] Dongle initialized and ready

hhornung commented 4 years ago

@magcks But your latest build is crashing on unload (module unload chan_dongle) asterisk-Version is 13.31.0 on a raspberry pi 4 B

magcks commented 4 years ago

I will check that, thank you. The other stuff is working? USSD, sending and receiving long SMS and Calls? Which Modem do you use BTW?

hhornung commented 4 years ago

The modem is a K3520 and sorry I have not checked all this stuff yet (calls are working).

magcks commented 4 years ago

Can you please check the current version? If possible, can you also check the other stuff, please? It would be great so know if it works on other modems.

magcks commented 4 years ago

This should be fixed now. The smsdb doesn't use any threads anymore now.