Re: undefined symbol: sqlite3_open

Hi Pedro,

thanks for sharing the guide. I've converted it into a tiddle right now.

OT:

And you got the point, actually i'm using embedded system for most of my 
projects.
Sqlite is a cheap alternative to full blown DB software like PGSql and 
MySql which have a large memory footprint that i don't want and don't 
need.

Anyway, i've given up on ARM embedded systems. Most likely because of 
the fact that most "cheap to get" embedded systems have a Allwinner 
Chipset. This company is known for repeatedly violating the GPL license. 
I cannot accept this and as a result i try to avoid this company and ARM 
in general (i386 fan here :-) ). I'm looking forward to UDOO, a cheap 
i386 embedded board with a lot of features.

Regards,
Rob

Am 04.08.2016 17:48 schrieb Pedro Aguilar:
> 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
> 
> 
> _______________________________________________
> gnokii-users mailing list
> [email protected]
> https://lists.nongnu.org/mailman/listinfo/gnokii-users