Re: undefined symbol: sqlite3_open

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