Re: [sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread jpadie

you are absolutely right on the debian version numbering, of course.

the GNU lib is 2.2.5

and brilliant idea aabout the live cd.  i'll get a copy of knoppix (debian
based i recall) and get the lib from there. 

thanks so much!
Justin

--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3659555
Sent from the SQLite forum at Nabble.com.



Re: [sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread Markus Kolb
jpadie wrote:

> 2.  the linux servers are debian 2.4.28 (so they say).  i read that 2.4 was
> not a stable release so i am assuming they mean 2.2.x  in any event 

With Debian 2.4.28 I think of a Debian release with kernel version
2.4.28. This means it is a Debian distribution with a self-compiled
kernel. No information about Debian release.

You might get some information about Debian release with
cat /etc/debian_version
or
cat /etc/issue
but the content need not to be the truth.

> from this i would guess it would also use glibc2.2 and not 2.3 as you
> point out the debian woody (3) uses the earlier library.

The command
ldd --version
tells you the GNU libc version.

If I remember correct, phpinfo() has a line with libc version, too.

>so next thing to try is to find sqlite.so compiled with glibc.so.  i have
> no way of compiling things on my systems and googling does not reveal
> anything.   Do any of you know a source of precompiled .so files?  

Why you don't use one of those Linux Live CDs? You get libraries, you
can decompress binary packages, pick the right files and you can compile.



Re: [sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread jpadie

Thanks for the reply.  

I should have included this in my original post:

1.  1&1 won't turn on sqlite.  they say it's a security issue (which is, of
course, nonsense). I suspect it is a pricing issue as it might cause people
who would otherwise upgrade to a multiple mysql package to remain at the
cheaper level and use sqlite dbs.  

2.  the linux servers are debian 2.4.28 (so they say).  i read that 2.4 was
not a stable release so i am assuming they mean 2.2.x  in any event 

from this i would guess it would also use glibc2.2 and not 2.3 as you
point out the debian woody (3) uses the earlier library.

   so next thing to try is to find sqlite.so compiled with glibc.so.  i have
no way of compiling things on my systems and googling does not reveal
anything.   Do any of you know a source of precompiled .so files?  

Many thanks for your assistance
Justin

--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3654138
Sent from the SQLite forum at Nabble.com.



Re: [sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread Christian Smith
On Wed, 29 Mar 2006, jpadie wrote:

>
>Hi there
>
>my host (1 and 1) have compiled php5 without sqlite.  but I have a couple of
>php applications that would benefit from SQLite (for portability).


You could raise a ticket with 1 and 1 to install sqlite.


>
>The server is a linux box and I do not have root, SSH or telnet access
>(although i have found using php i can eval and exec commands (eg. apt-get)
>outside of the document root: opens up possibilities...)


What version and distro of Linux? Do you know?


>
>I do not operate any linux boxes elsewhere so have no way of compiling and
>uploading source code.
>
>Now the issue:
>
>I am trying to find a way to "install" and use SQLite even though it is not
>compiled in to php5.  PDO and PDO_SQLite are installed.
>
>i can dl() extensions (.so) but when I try to do this with the SQLite
>extension 2.8.17 or later i get the message:
>--
>Warning: dl() [function.dl]: Unable to load dynamic library
>'/homepages/6/OCCLUDED/htdocs/pear/extensions/sqlite-2.8.17.so' -
>/lib/libc.so.6: version `GLIBC_2.3' not found


This means that sqlite-2.8.17.so is compiled against glibc 2.3, which is
included with most modern distros. Debian Woody uses glibc 2.2, as does RH
7.x and derived products (RH AS 1.x) RH 8.x was the first glibc 2.3 based
RH distribution, I believe. Not sure about the Suse distros.

It could be that:
- The Linux box it is installed on is using glibc < 2.3, in which case
  you'll have to get hold of library binaries compiled on an old distro
  with suitable glibc.
- PHP is running in a chroot environment, such that the system glibc is
  not available. The fact you can run external binaries makes this
  unlikely.


Christian


-- 
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
 X   - AGAINST MS ATTACHMENTS
/ \


[sqlite] Installing SQLite on a Shared Platform

2006-03-29 Thread jpadie

Hi there

my host (1 and 1) have compiled php5 without sqlite.  but I have a couple of
php applications that would benefit from SQLite (for portability).  

The server is a linux box and I do not have root, SSH or telnet access
(although i have found using php i can eval and exec commands (eg. apt-get)
outside of the document root: opens up possibilities...)

I do not operate any linux boxes elsewhere so have no way of compiling and
uploading source code.

Now the issue: 

I am trying to find a way to "install" and use SQLite even though it is not
compiled in to php5.  PDO and PDO_SQLite are installed.

i can dl() extensions (.so) but when I try to do this with the SQLite
extension 2.8.17 or later i get the message:
--
Warning: dl() [function.dl]: Unable to load dynamic library
'/homepages/6/OCCLUDED/htdocs/pear/extensions/sqlite-2.8.17.so' -
/lib/libc.so.6: version `GLIBC_2.3' not found
--

I have googled for this error but not come up with anything helpful.  

If anyone has any workarounds or suggestions i'd be very grateful
thanks
Justin


--
View this message in context: 
http://www.nabble.com/Installing-SQLite-on-a-Shared-Platform-t1362538.html#a3651203
Sent from the SQLite forum at Nabble.com.