Re: undefined symbol: sqlite3_open

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