Re: undefined symbol: sqlite3_open

Hi,

I recommend you to download the sources from the Git repo since the 
latest release 0.6.31 is quite old. Several issues have been fixed all 
around including smsd.

Yes, gnokii does not compile cleanly when building for SQLite3, 
specially for embedded systems. I wrote a simple guide on how to build 
it: http://paguilar.org/?p=201

Regards,
-- 
Pedro Aguilar
http://paguilar.org

On 04/08/2016 08:33, [email protected] wrote:
> Yeah, got it.
>
> # sqlite3 -init ./smsd/sms.tables.sqlite.sql /root/smsd.db
> # smsd -b IN -m sqlite -d /root/smsd.db -f /root/sms-messages
>
> Now I can finally start using gnokii and my old Nokia 5140 to control my
> home network over GSM Network :-)
>
> Thanks to the developers for this great piece of software.
>
> Am 04.08.2016 08:18 schrieb [email protected]:
>> Hi All,
>>
>> i found a workaround to get a functional module.
>>
>> I've changed smsd/Makefile manually:
>>
>> Line 279 becomes "SQLITE_LIBS = -lsqlite3" instead of "SQLITE_LIBS =
>> SQLITE3_LIBS".
>>
>> # cd smsd
>> # make clean
>> # make
>>
>> Now I get the expected output when using ldd on the module:
>>
>> # ldd .libs/libsmsd_sqlite.so
>> linux-gate.so.1 (0xb779e000)
>> libsqlite3.so.0 => /usr/lib/i386-linux-gnu/libsqlite3.so.0 (0xb76b7000)
>> libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb769c000)
>> libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7528000)
>> libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7523000)
>> /lib/ld-linux.so.2 (0xb77a1000)
>>
>> Hope this helps someone. Maybe this should be fixed at autoconf level
>> but i don't know how to do this.
>>
>> Now I have to find out how to use this module because I can't find any
>> documentation about it. How do I set the sqlite db file with the smsd
>> options ?
>>
>> "-c, --host db_hostname OR spool directory if -m file" Yeah, but what
>> to do if I have -m sqlite ?
>>
>> regards,
>> rob
>>
>> Am 03.08.2016 15:35 schrieb [email protected]:
>>> Hi,
>>>
>>> i have problems to use gnokii with sqlite backend. Since debian
>>> doesn't provide this backend as a package i had to build from source.
>>>
>>> But there seems to be a linker problem with libsmsd_sqlite.so. I get
>>> the following error when i'm trying to use this module.
>>>
>>> #./bin/smsd -b IN -m sqlite
>>> ./bin/smsd: symbol lookup error:
>>> /root/gnokii/lib/smsd/libsmsd_sqlite.so: undefined symbol:
>>> sqlite3_open
>>>
>>> # ldd libsmsd_sqlite.so
>>> linux-gate.so.1 (0xb777d000)
>>> libglib-2.0.so.0 => /lib/i386-linux-gnu/libglib-2.0.so.0 (0xb7647000)
>>> libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb762c000)
>>> libical.so.1 => /usr/lib/libical.so.1 (0xb75c6000)
>>> libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7452000)
>>> libpcre.so.3 => /lib/i386-linux-gnu/libpcre.so.3 (0xb73df000)
>>> /lib/ld-linux.so.2 (0xb7780000)
>>>
>>> I don't know but shouldn't be a libsqlite.so in the output ?
>>>
>>> Any suggestions ?
>>>
>>> _______________________________________________
>>> gnokii-users mailing list
>>> [email protected]
>>> https://lists.nongnu.org/mailman/listinfo/gnokii-users
>>
>> _______________________________________________
>> gnokii-users mailing list
>> [email protected]
>> https://lists.nongnu.org/mailman/listinfo/gnokii-users
>
> _______________________________________________
> gnokii-users mailing list
> [email protected]
> https://lists.nongnu.org/mailman/listinfo/gnokii-users