undefined symbol: sqlite3_open

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

undefined symbol: sqlite3_open

robberer
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
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users
Reply | Threaded
Open this post in threaded view
|

Re: undefined symbol: sqlite3_open

robberer
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 [hidden email]:

> 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
> [hidden email]
> https://lists.nongnu.org/mailman/listinfo/gnokii-users

_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users
Reply | Threaded
Open this post in threaded view
|

Re: undefined symbol: sqlite3_open

robberer
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 [hidden email]:

> 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 [hidden email]:
>> 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
>> [hidden email]
>> https://lists.nongnu.org/mailman/listinfo/gnokii-users
>
> _______________________________________________
> gnokii-users mailing list
> [hidden email]
> https://lists.nongnu.org/mailman/listinfo/gnokii-users

_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users
Reply | Threaded
Open this post in threaded view
|

Re: undefined symbol: sqlite3_open

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


_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users
Reply | Threaded
Open this post in threaded view
|

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

_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users
Reply | Threaded
Open this post in threaded view
|

Re: undefined symbol: sqlite3_open

Pedro Aguilar
Hi Rob,

SQLite3 is definitely a cheap alternative from the resources point of
view, specially if you only have one or very few processes that access
the database. In gnokii it seems that other backends are more tested.

In the system in which I'm working we started with just a couple of
processes, but now we have many processes that write and read to the
same database and SQLite3 seems not to be the best option any more...

I tried PostgreSQL but it refused to run with less than 256MB. I managed
to run MySQL with only 13MB so it could be a good alternative for
handling multiple write/read processes even if I only have 64MB in my
system.

I'm not a fan of Allwinner neither, but I've found several low-price ARM
alternatives, but it depends on what you're doing.

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


On 04/08/2016 19:27, [hidden email] wrote:

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


_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users