Re: undefined symbol: sqlite3_open

[robberer]

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, address@hidden 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 address@hidden:
> > > 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 address@hidden:
> > > > 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
> > > > address@hidden
> > > > https://lists.nongnu.org/mailman/listinfo/gnokii-users
> > >
> > > _______________________________________________
> > > gnokii-users mailing list
> > > address@hidden
> > > https://lists.nongnu.org/mailman/listinfo/gnokii-users
> >
> > _______________________________________________
> > gnokii-users mailing list
> > address@hidden
> > https://lists.nongnu.org/mailman/listinfo/gnokii-users
>
>
> _______________________________________________
> gnokii-users mailing list
> address@hidden
> https://lists.nongnu.org/mailman/listinfo/gnokii-users