Nekonomicon - SQL Lite 3 in nekoware breaks firefox

PymbleSoftware
From P.O. Box 529, Gordon, Sydney, NSW 2072, Australia.
Who joined July 15, 2008, 5:48 p.m.

Wrote the following at Jan. 6, 2012, 8:09 a.m...


   firefox
   

   1670:/usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error: attempted access to unresolvable symbol in /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: sqlite3_enable_shared_cache
   

   root@[tezro]:~/# ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   libm.so  =>      /usr/lib32/libm.so
   

   1671: 01:27:47 /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error exit/longjmp: Cannot Successfully map soname 'libsmime3.so' under any of the filenames ../../dist/bin/libsmime3.so:/usr/nekoware/lib/libsmime3.so:/usr/apple/shake3.5//lib//libsmime3.so:/usr/lib32/libsmime3.so:/usr/lib32/internal/libsmime3.so:/lib32/libsmime3.so:/opt/lib32/libsmime3.so:
   

   1671:/usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error: Cannot Successfully map soname 'libsmime3.so' under any of the filenames ../../dist/bin/libsmime3.so:/usr/nekoware/lib/libsmime3.so:/usr/apple/shake3.5//lib//libsmime3.so:/usr/lib32/libsmime3.so:/usr/lib32/internal/libsmime3.so:/lib32/libsmime3.so:/opt/lib32/libsmime3.so:

Uninstall SQ Lite 3 and Python module sql lite 3 and problem goes away.

I was in as root to do admin and install/remove software.

Please check that you do no break other packages when you create nekoware.

I have not found any reference to this in the forums but I guess it is self evident for most developers.

I haven't seen any nekoware updates lately and I think the problem has existed for a while now.

R.

死の神はりんごだけ食べる

開いた括弧は必ず閉じる -- あるプログラマー

:Tezro:

J5600, 2 x Mac, 3 x SUN, Alpha DS20E, Alpha 800 5/550, 3 x RS/6000, Amiga 4000 VideoToaster, Amiga4000 -030, 733MHz Sam440 AmigaOS 4.1 update 1.

Sold: :Indy:

Tandem Himalaya S-Series Nonstop S72000 ServerNet.

Twitter @PymbleSoftware
Current Apps (iOS) -> https://itunes.apple.com/au/artist/pymb ... d553990081
(Android) https://play.google.com/store/apps/deve ... +Ltd&hl=en
(Onyx2) Cortex ---> http://www.facebook.com/pages/Cortex-th ... 11?sk=info
(0300s) Minnie ---> http://www.facebook.com/pages/Minnie-th ... 02?sk=info
Github ---> https://github.com/pymblesoftware

nekonoko
Site Admin
From Pleasanton, California
Who joined Jan. 23, 2003, 1:31 a.m.

Wrote the following at Jan. 6, 2012, 12:55 p.m...

Yep, been a known issue for quite a while: viewtopic.php?f=7&t=16724316

Twitter: @neko_no_ko
IRIX Release 4.0.5 IP12 Version 06151813 System V
Copyright 1987-1992 Silicon Graphics, Inc.
All Rights Reserved.

PymbleSoftware
From P.O. Box 529, Gordon, Sydney, NSW 2072, Australia.
Who joined July 15, 2008, 5:48 p.m.

Wrote the following at Jan. 6, 2012, 1:37 p.m...

nekonoko wrote: Yep, been a known issue for quite a while: viewtopic.php?f=7&t=16724316

Thanks nekonoko. I failed to find that in my search before posting. At least there is another link back to the original topic now.

R.

死の神はりんごだけ食べる

開いた括弧は必ず閉じる -- あるプログラマー

:Tezro:

J5600, 2 x Mac, 3 x SUN, Alpha DS20E, Alpha 800 5/550, 3 x RS/6000, Amiga 4000 VideoToaster, Amiga4000 -030, 733MHz Sam440 AmigaOS 4.1 update 1.

Sold: :Indy:

Tandem Himalaya S-Series Nonstop S72000 ServerNet.

Twitter @PymbleSoftware
Current Apps (iOS) -> https://itunes.apple.com/au/artist/pymb ... d553990081
(Android) https://play.google.com/store/apps/deve ... +Ltd&hl=en
(Onyx2) Cortex ---> http://www.facebook.com/pages/Cortex-th ... 11?sk=info
(0300s) Minnie ---> http://www.facebook.com/pages/Minnie-th ... 02?sk=info
Github ---> https://github.com/pymblesoftware

hamei
From over the rainbow
Who joined Feb. 24, 2004, 4:10 p.m.

Wrote the following at Jan. 8, 2012, 6:21 a.m...

PymbleSoftware wrote:

nekonoko wrote: Yep, been a known issue for quite a while: viewtopic.php?f=7&t=16724316

Thanks nekonoko. I failed to find that in my search before posting. At least there is another link back to the original topic now.

I was thinking ... (danger, Will Robinson. Danger ! Danger !) When a package is known to be bad, would it be better to ditch it entirely or to create a "known bad" directory it could be moved to so that maybe other people wouldn't have to start from scratch when packaging problem-child applications ?

PymbleSoftware
From P.O. Box 529, Gordon, Sydney, NSW 2072, Australia.
Who joined July 15, 2008, 5:48 p.m.

Wrote the following at Jan. 8, 2012, 1:10 p.m...

hamei wrote:

PymbleSoftware wrote:

nekonoko wrote: Yep, been a known issue for quite a while: viewtopic.php?f=7&t=16724316

Thanks nekonoko. I failed to find that in my search before posting. At least there is another link back to the original topic now.

I was thinking ... (danger, Will Robinson. Danger ! Danger !) When a package is known to be bad, would it be better to ditch it entirely or to create a "known bad" directory it could be moved to so that maybe other people wouldn't have to start from scratch when packaging problem-child applications ?

I think it might be okay if you are doing SQL lite stuff in isolation. Might be better if people can find the answers easily.. It breaks firefox which includes everything including the kitchen sink. Modern software .. if it aint got a dozen depndancies... I don't know why my previous search was unsuccessful.

Keywords : SQL Lite 3, firefox firefox-bin rld: Fatal Error sqlite3_enable_shared_cache unresolvable symbol

R.

死の神はりんごだけ食べる

開いた括弧は必ず閉じる -- あるプログラマー

:Tezro:

J5600, 2 x Mac, 3 x SUN, Alpha DS20E, Alpha 800 5/550, 3 x RS/6000, Amiga 4000 VideoToaster, Amiga4000 -030, 733MHz Sam440 AmigaOS 4.1 update 1.

Sold: :Indy:

Tandem Himalaya S-Series Nonstop S72000 ServerNet.

Twitter @PymbleSoftware
Current Apps (iOS) -> https://itunes.apple.com/au/artist/pymb ... d553990081
(Android) https://play.google.com/store/apps/deve ... +Ltd&hl=en
(Onyx2) Cortex ---> http://www.facebook.com/pages/Cortex-th ... 11?sk=info
(0300s) Minnie ---> http://www.facebook.com/pages/Minnie-th ... 02?sk=info
Github ---> https://github.com/pymblesoftware

hamei
From over the rainbow
Who joined Feb. 24, 2004, 4:10 p.m.

Wrote the following at Jan. 27, 2012, 6:23 a.m...

PymbleSoftware wrote: Keywords : SQL Lite 3, firefox firefox-bin rld: Fatal Error sqlite3_enable_shared_cache unresolvable symbol

Just built SQlite 3.07.10 and installed it. Held my nose, put my right foot in the garbage can, hopped around in a circle widdershins three times and restarted Fireflop : FF didn't crash. Posting from there now.

So maybe whatever was wrong with SQLite 3 has been fixed ?

canavan
Who joined July 21, 2003, 6:19 a.m.

Wrote the following at Jan. 28, 2012, 12:44 p.m...

neko_sqlite3-3.7.10.tardist is in /incoming - it works for me with nekoware firefox.

nekonoko
Site Admin
From Pleasanton, California
Who joined Jan. 23, 2003, 1:31 a.m.

Wrote the following at Jan. 30, 2012, 1:22 p.m...

canavan wrote: neko_sqlite3-3.7.10.tardist is in /incoming - it works for me with nekoware firefox.

I've moved it to /beta; thanks!

Twitter: @neko_no_ko
IRIX Release 4.0.5 IP12 Version 06151813 System V
Copyright 1987-1992 Silicon Graphics, Inc.
All Rights Reserved.

pentium
From Kamloops, BC
Who joined Aug. 28, 2006, 6:29 p.m.

Wrote the following at Feb. 27, 2012, 6:40 p.m...

This didn't seem to fix it for me. Now it's attempted access to a new unresolvable symbol (sqlite3_os_switch).

<-------- A very happy forum member.

canavan
Who joined July 21, 2003, 6:19 a.m.

Wrote the following at Feb. 28, 2012, 2:16 p.m...

Which version of firefox are you using, and do you have any LD_LIBRARY_PATH (possibly with N32 somewhere) set (you shouldn't, any nekoware package that requires it is broken and should be fixed)?

pentium
From Kamloops, BC
Who joined Aug. 28, 2006, 6:29 p.m.

Wrote the following at Feb. 29, 2012, 12:42 p.m...

Attempting to run 2.0.0.22 which I believe is the latest on the nekoware mirror and everything should be running at defaults. It seems that the same problem is affecting Thunderbird as well.

<-------- A very happy forum member.

canavan
Who joined July 21, 2003, 6:19 a.m.

Wrote the following at Feb. 29, 2012, 2:28 p.m...

Please post the output of

Code: Select all


   ls -l /usr/nekoware/lib/libsqli*
   

   ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   LD_LIBRARYN32_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   LD_LIBRARY_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin

Then try

Code: Select all


   LD_LIBRARY_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin

pentium
From Kamloops, BC
Who joined Aug. 28, 2006, 6:29 p.m.

Wrote the following at Feb. 29, 2012, 6:56 p.m...

I have to do this through IRC because I can't post here through Netscape so expect some weird formatting.

Code: Select all


   $ ls -l /usr/nekoware/lib/libsqli*
   

   <Peanut> -rw-r--r--    1 root     sys       1908772 Feb 27 18:21 /usr/nekoware/lib/libsqlite3.a
   

   <Peanut> -rwxr-xr-x    1 root     sys           861 Feb 27 18:21 /usr/nekoware/lib/libsqlite3.la
   

   <Peanut> lrwxr-xr-x    1 root     sys            17 Mar  2  2011 /usr/nekoware/lib/libsqlite3.so -> libsqlite3.so.1.6
   

   <Peanut> lrwxr-xr-x    1 root     sys            17 Mar  2  2011 /usr/nekoware/lib/libsqlite3.so.1 -> libsqlite3.so.1.6
   

   <Peanut> -rwxr-xr-x    1 root     sys       1391944 Feb 27 18:21 /usr/nekoware/lib/libsqlite3.so.1.6

Code: Select all


   $ ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   <Peanut>         libm.so  =>      /usr/lib32/libm.so
   

   <Peanut>  1708: 18:42:43 /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error exit/longjmp: Cannot Successfully map soname 'libsmime3.so' under any of the filenames ../../dist/bin/libsmime3.so:/usr/nekoware/lib/libsmime3.so:/usr/lib32/libsmime3.so:/usr/lib32/internal/libsmime3.so:/lib32/libsmime3.so:/opt/lib32/libsmime3.so:
   

   <Peanut>  1708:/usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error: Cannot Successfully map soname 'libsmime3.so' under any of the filenames ../../dist/bin/libsmime3.so:/usr/nekoware/lib/libsmime3.so:/usr/lib32/libsmime3.so:/usr/lib32/internal/libsmime3.so:/lib32/libsmime3.so:/opt/lib32/libsmime3.so:

Code: Select all


   $  LD_LIBRARYN32_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   <Peanut>         libm.so  =>      /usr/lib32/libm.so
   

   <Peanut>         libsmime3.so  =>         /usr/nekoware/lib/firefox-2.0.0.22pre/libsmime3.so
   

   <Peanut>         libssl3.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libssl3.so
   

   <Peanut>         libnss3.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libnss3.so
   

   <Peanut>         libnssutil3.so  =>       /usr/nekoware/lib/firefox-2.0.0.22pre/libnssutil3.so
   

   <Peanut>         libsoftokn3.so  =>       /usr/nekoware/lib/firefox-2.0.0.22pre/libsoftokn3.so
   

   <Peanut>         libXt.so  =>     /usr/lib32/libXt.so
   

   <Peanut>         libsqlite3.so  =>        /usr/nekoware/lib/libsqlite3.so
   

   <Peanut>         libxpcom_compat.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom_compat.so
   

   <Peanut>         libmozjs.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libmozjs.so
   

   <Peanut>         libxpcom.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom.so
   

   <Peanut>         libxpcom_core.so  =>     /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom_core.so
   

   <Peanut>         libplds4.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libplds4.so
   

   <Peanut>         libplc4.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libplc4.so
   

   <Peanut>         libnspr4.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libnspr4.so
   

   <Peanut>         libpthread.so  =>        /usr/lib32/libpthread.so
   

   <Peanut>         libdl.so  =>     /usr/lib32/libdl.so
   

   <Peanut>         libgtk-1.2.so.1  =>      /usr/nekoware/lib/libgtk-1.2.so.1
   

   <Peanut>         libgdk-1.2.so.1  =>      /usr/nekoware/lib/libgdk-1.2.so.1
   

   <Peanut>         libgmodule-1.2.so.1  =>  /usr/nekoware/lib/libgmodule-1.2.so.1
   

   <Peanut>         libglib-1.2.so.1  =>     /usr/nekoware/lib/libglib-1.2.so.1
   

   <Peanut>         libintl.so.9  =>         /usr/nekoware/lib/libintl.so.9
   

   <Peanut>         libXext.so  =>   /usr/lib32/libXext.so
   

   <Peanut>         libX11.so.1  =>  /usr/lib32/libX11.so.1
   

   <Peanut>         libsocket.so  =>         /usr/lib32/libsocket.so
   

   <Peanut>         libfastm.so  =>  /usr/lib32/libfastm.so
   

   <Peanut>         libCsup.so  =>   /usr/lib32/libCsup.so
   

   <Peanut>         lib
   

   <Peanut> libC.so.2  =>    /usr/lib32/libC.so.2
   

   <Peanut>         libCio.so.1  =>  /usr/lib32/libCio.so.1
   

   <Peanut>         libc.so.1  =>    /usr/lib32/libc.so.1
   

   <Peanut>         libgen.so  =>    /usr/lib32/libgen.so   delay-load
   

   <Peanut>         libintl.so.4  =>         /usr/nekoware/lib/libintl.so.4
   

   <Peanut>         libiconv.so.3  =>        /usr/nekoware/lib/libiconv.so.3

Code: Select all


   $ LD_LIBRARY_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre ldd /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   <Peanut>         libm.so  =>      /usr/lib32/libm.so
   

   <Peanut>         libsmime3.so  =>         /usr/nekoware/lib/firefox-2.0.0.22pre/libsmime3.so
   

   <Peanut>         libssl3.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libssl3.so
   

   <Peanut>         libnss3.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libnss3.so
   

   <Peanut>         libnssutil3.so  =>       /usr/nekoware/lib/firefox-2.0.0.22pre/libnssutil3.so
   

   <Peanut>         libsoftokn3.so  =>       /usr/nekoware/lib/firefox-2.0.0.22pre/libsoftokn3.so
   

   <Peanut>         libXt.so  =>     /usr/lib32/libXt.so
   

   <Peanut>         libsqlite3.so  =>        /usr/nekoware/lib/libsqlite3.so
   

   <Peanut>         libxpcom_compat.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom_compat.so
   

   <Peanut>         libmozjs.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libmozjs.so
   

   <Peanut>         libxpcom.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom.so
   

   <Peanut>         libxpcom_core.so  =>     /usr/nekoware/lib/firefox-2.0.0.22pre/libxpcom_core.so
   

   <Peanut>         libplds4.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libplds4.so
   

   <Peanut>         libplc4.so  =>   /usr/nekoware/lib/firefox-2.0.0.22pre/libplc4.so
   

   <Peanut>         libnspr4.so  =>  /usr/nekoware/lib/firefox-2.0.0.22pre/libnspr4.so   libpthread.so  =>        /usr/lib32/libpthread.so
   

   <Peanut>         libdl.so  =>     /usr/lib32/libdl.so
   

   <Peanut>         libgtk-1.2.so.1  =>      /usr/nekoware/lib/libgtk-1.2.so.1
   

   <Peanut>         libgdk-1.2.so.1  =>      /usr/nekoware/lib/libgdk-1.2.so.1
   

   <Peanut>         libgmodule-1.2.so.1  =>  /usr/nekoware/lib/libgmodule-1.2.so.1
   

   <Peanut>         libglib-1.2.so.1  =>     /usr/nekoware/lib/libglib-1.2.so.1
   

   <Peanut>         libintl.so.9  =>         /usr/nekoware/lib/libintl.so.9
   

   <Peanut>         libXext.so  =>   /usr/lib32/libXext.so
   

   <Peanut>         libX11.so.1  =>  /usr/lib32/libX11.so.1
   

   <Peanut>         libsocket.so  =>         /usr/lib32/libsocket.so
   

   <Peanut>         libfastm.so  =>  /usr/lib32/libfastm.so
   

   <Peanut>         libCsup.so  =>   /usr/lib32/libCsup.so
   

   <Peanut>         libC.so
   

   <Peanut> ibC.so.2  =>    /usr/lib32/libC.so.2
   

   <Peanut>         libCio.so.1  =>  /usr/lib32/libCio.so.1
   

   <Peanut>         libc.so.1  =>    /usr/lib32/libc.so.1
   

   <Peanut>         libgen.so  =>    /usr/lib32/libgen.so   delay-load
   

   <Peanut>         libintl.so.4  =>         /usr/nekoware/lib/libintl.so.4
   

   <Peanut>         libiconv.so.3  =>        /usr/nekoware/lib/libiconv.so.3

Code: Select all


   $ LD_LIBRARY_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin
   

   <Peanut>  1716:/usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error: attempted access to unresolvable symbol in /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: sqlite3_os_switch

From what the folks on the IRC are telling me, either my hair is on fire or there is something missing from sqlite3 that everyone else somehow, possibly from files left over from upgrading an older version of sqlite still have, hence how they are not getting the same problem. sqlite3_os_switch was removed back in 3.5.0.

<-------- A very happy forum member.

Kira
From Central CONUS
Who joined Feb. 5, 2011, 4:04 p.m.

Wrote the following at Feb. 29, 2012, 9:32 p.m...

I talked with Pentium about this on IRC, and came to the conclusion that it's not a library path issue, but an issue with sqlite3_os_switch itself. That was an internal, undocumented function that was removed in the transition between 3.4.2 and 3.5.0 of SQlite. The call to sqlite3_os_switch was removed from Firefox sometime before 3.0 , but it strongly appears that the .22pre version in nekoware still has the call.

Basically, I don't see how Firefox2 could possibly be working with sqlite above 3.4.2, since it relies on functions that are, quite simply, gone; Pentium's problem should affect anyone using Nekoware Firefox and the beta sqlite.

hamei
From over the rainbow
Who joined Feb. 24, 2004, 4:10 p.m.

Wrote the following at Feb. 29, 2012, 10:03 p.m...

pentium wrote:

Code: Select all
$ LD_LIBRARY_PATH=/usr/nekoware/lib/firefox-2.0.0.22pre /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin <Peanut> 1716:/usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: rld: Fatal Error: attempted access to unresolvable symbol in /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin: sqlite3_os_switch

Try (c shell or tcshell) :

Code: Select all


   urchin 10% setenv LD_LIBRARY_PATH /usr/nekoware/lib/firefox-2.0.0.22pre
   

   urchin 11% /usr/nekoware/lib/firefox-2.0.0.22pre/firefox-bin

If I try to run it your way I get a bunch of error messages about missing "libsmime"

Kira wrote: Basically, I don't see how Firefox2 could possibly be working with sqlite above 3.4.2, since it relies on functions that are, quite simply, gone; Pentium's problem should affect anyone using Nekoware Firefox and the beta sqlite.

Quite possibly. But this sqlite version does permit fireflop to start and run and not crash. I have no idea if it actually does anything, but at least it doesn't blow up the 'flop ....

Edit : those useless assbreath Down's Syndrome poster children at Fireflop ... :evil:

http://aplawrence.com/Web/firefox-sqlite.html

tastes great, less filling !

http://downloadsquad.switched.com/2009/ ... databases/

Morons. Absolute useless godforsaken morons. Let's fix fireflop 2 for Irix and let the mouth-breathers run FF3+ ....

IRIX and Software

SQL Lite 3 in nekoware breaks firefox