On 2025-11-25, Masayoshi Fujimoto <[email protected]> wrote: > ------=_Part_642578_2063540506.1764038680440 > Content-Type: text/plain; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > > Hi. I apologise for the inconvenience. In short, I thought I had copied all= > the necessary files into /var/www. However, it's not working. =C2=A0 =C2=
see below: >=A0 ----- Reply to message ----- Subject: Re: install_driver(SQLite) failed= >: Can't load SQLite.so Date: Tue, Nov 25, 2025, 05:05 From: Stuart Henderso= > n < [email protected]> To: < [email protected]> =C2=A0 =C2=A0 =C2=A0= > your email formatting is very difficult to decipher (either here or at htt= > ps://marc.info/?l=3Dopenbsd-misc&m=3D176400768821493&w=3D2) but guessing yo= > u probably forgot to run ldconfig for the libraries inside the chroot. howe= > ver, it's debatable whether there's any point bothering with a chroot jail = > if you're going to copy in a shell, libc, perl and a bunch of CPAN, etc. = >=C2=A0 =C2=A0 =C2=A0 # chroot /var/www/ /bin/sh=C2=A0 =C2=A0 =C2=A0 =C2=A0 = >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= >=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /bin/sh: No controllin= > g tty (open /dev/tty: No such file or directory) /bin/sh: warning: won't ha= > ve full job control # ls -l total 56 drwxr-xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2= >=A0 512 Nov 15 23:38 acme drwxr-xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov = > 23 16:13 bin drwx-----T=C2=A0 2 67=C2=A0 1=C2=A0 512 Oct 12 18:32 cache drw= > xr-xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov 23 12:01 cgi-bin drwxr-xr-x= >=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov 15 10:53 conf drwxr-xr-x=C2=A0 2 0= >=C2=A0 =C2=A01=C2=A0 512 Nov 23 15:59 dev drwxr-xr-x=C2=A0 2 0=C2=A0 =C2=A0= > 1=C2=A0 512 Nov 23 16:04 etc drwxr-xr-x=C2=A0 4 0=C2=A0 =C2=A01=C2=A0 512 N= > ov 16 00:20 htdocs drwxr-xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov 15 23:0= > 2 logs drwxr-xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov 24 02:27 perl drwxr= > -xr-x=C2=A0 2 0=C2=A0 =C2=A01=C2=A0 512 Nov 24 23:18 run drwxr-xr-x=C2=A0 2= > 0=C2=A0 =C2=A01=C2=A0 512 Nov 25 01:36 sbin drwxr-xr-x=C2=A0 7 0=C2=A0 =C2= >=A01=C2=A0 512 Nov 23 13:22 usr drwxr-xr-x=C2=A0 3 0=C2=A0 =C2=A01=C2=A0 51= > 2 Nov 25 02:06 var # /sbin/ldconfig && echo 'LDCONFIG SUCCESS'=C2=A0=C2=A0 = you don't pass the directories to ldconfig. alternative if you use /var/www/usr/lib for all libraries rather than /var/www/usr/local/lib for some, you can use ld.so's fallback (#4 in "ld.so searches for shared objects in the following lists" in the manual). or there's "slowcgi -p /"... > LDCONFIG SUCCESS # cd perl/ # perl sqlite.pl=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= >=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= >=A0 =C2=A0 install_driver(SQLite) failed: Can't load '/usr/local/libdata/pe= > rl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so' for module DBD::SQLi= > te: Cannot load specified object at /usr/libdata/perl5/XSLoader.pm line 94.= > =C2=A0at /usr/local/libdata/perl5/site_perl/amd64-openbsd/DBD/SQLite.pm li= > ne 16. Compilation failed in require at (eval 5) line 3. Perhaps a required= > shared library or dll isn't installed where expected =C2=A0at sqlite.pl li= > ne 12. =C2=A0 =C2=A0 > ------=_Part_642578_2063540506.1764038680440 > Content-Type: text/html; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > ><html> > <head></head> > <body>=20 > <p>Hi.</p>=20 > <p>I apologise for the inconvenience.<br> In short, I thought I had copie= > d all the necessary files into /var/www. However, it's not working.</p>=20 > <p> </p>=20 > <p> </p>=20 > <div> > ----- Reply to message -----=20 > <br> Subject: Re: install_driver(SQLite) failed: Can't load SQLite.so=20 > <br> Date: Tue, Nov 25, 2025, 05:05=20 > <br> From: Stuart Henderson <=20 > <a href=3D"mailto:[email protected]"; target=3D"_blank" rel=3D"no= > opener noreferrer">[email protected]</a>>=20 > <br> To: <=20 > <a href=3D"mailto:[email protected]"; target=3D"_blank" rel=3D"noopener no= > referrer">[email protected]</a>>=20 > </div>=20 > <p> </p>=20 > <p> </p>=20 > <p> </p>=20 > <blockquote> > your email formatting is very difficult to decipher (either here or=20 > <br> at=20 > <a href=3D"https://marc.info/?l=3Dopenbsd-misc&m=3D176400768821493&a= > mp;w=3D2%29" target=3D"_blank" rel=3D"noopener noreferrer">https://marc.inf= > o/?l=3Dopenbsd-misc&m=3D176400768821493&w=3D2)</a>=20 > <a href=3D"https://marc.info/?l=3Dopenbsd-misc&m=3D176400768821493&a= > mp;w=3D2%29%20but%20guessingyou%20probably%20forgot%20to%20run%20ldconfig%2= > 0for%20the%20libraries%20inside%20the%20chroot.however,%20it's%20debatable%= > 20whether%20there's%20any%20point%20bothering%20with%20achroot%20jail%20if%= > 20you're%20going%20to%20copy%20in%20a%20shell,%20libc,%20perl%20and%20a%20b= > unchof%20CPAN,%20etc.#%20ls%20-l%20/usr/local/lib/libsqlite3.so.37.34-rw-r-= > -r-- %201%200&nb=3D>%20sp;%201 %202055936%20Nov%2023%2014:50%= > 20/usr/local/lib/libsqlite3.so.37.34#%20l=3D>%20s%20-l%20/usr/lib/libpthrea= > d.so.28.0-r--r--r-- %201%200 %201 %20129=3D>%20304%20Nov%202= > 3%2014:51%20/usr/lib/libpthread.so.28.0#%20ls%20-l %20/usr/lib/lib=3D>= > %20m.so.10.1-r--r--r-- %201%200 %201 %20595096%20Nov%2023%20= > 12:19%20/usr/l=3D>%20ib/libm.so.10.1#%20ls%20-l %20/usr/lib/libz.so.7.= > 1-r--r--r-- =3D>%201%200 %201 %20297856%20Nov%2023%2014:37%2= > 0/usr/lib/libz.so.7.1 %20&nbs=3D>%20p;%20 %20 %20 %= > 20 %20 %20 %20 %20 %20 %20 %20&n=3D>= > %20bsp;%20 %20 %20 %20 %20 %20 %20 %20&n= > bsp;%20 %20 %20=3D>%20 %20 %20 %20 %20 &= > nbsp;#%20perl%20-cw%20sqlite.pl %20&nb=3D>%20sp;%20 %20 = > %20 %20 %20 %20 %20 %20 %20 %20 %20= > &=3D>%20nbsp;%20 %20 %20 %20 %20 %20 %20&= > nbsp;%20 %20 %20 =3D>%20 %20 sqlite.pl%20syntax%20= > OK=3D20>#%20perl%20sqlite.pl %20 %20 install_driver%28= > SQL=3D>%20ite%29%20failed:%20Can't%20load%20'/usr/local/libdata/perl5/site_= > perl/amd64-openbsd/a=3D>%20uto/DBD/SQLite/SQLite.so'%20for%20module%20DBD::= > SQLite:%20Cannot%20load%20specified%20obj=3D>%20ect%20at%20/usr/libdata/per= > l5/XSLoader.pm%20line%2094. at%20/usr/local/libd=3D>%20ata/perl5/site_= > perl/amd64-openbsd/DBD/SQLite.pm%20line%2016.Compilation%20fa=3D>%20iled%20= > in%20require%20at%20%28eval%205%29%20line%203.Perhaps%20a%20required%20shar= > ed%20library%20o=3D>%20r%20dll%20isn't%20installed%20where%20expected = > at%20sqlite.pl%20line%2012.=3D20>=3D20>Here%20is%20my%20sqlite.pl=3D20>=3D2= > 0>#!/usr/bin/perl=3D20>=3D20>use%20strict;use%20warnings;use%20DBI;=3D20>= >=3D20>#%20Connection%20details%20%28DSN:%20Data%20Source%20Name%29#%20'sqli= > te:dbname=3D3D:m=3D>%20emory:'%20is%20the%20standard%20DSN%20for%20an%20in-= > memory%20SQLite%20database.my%20$dsn%20=3D>=3D3D%20"dbi:SQLite:dbname= >=3D3D:memory:";=3D20>=3D20>#%20Connect%20to%20the%20databasemy%20$dbh%= > 20=3D3D%20DBI->connect%28$dsn,%20"",%20""=3D>%20,%20%7b= >>%20 %20 %20RaiseError%20=3D3D>%201,%20#%20Throw%20an%20exception= > %20if=3D>%20connection%20fails %20 %20AutoCommit%20=3D3D>%201,%7d= > %29%20or%20die%20$DB=3D>%20I::errstr;=3D20>=3D20>#%20Disconnect%20from%20th= > e%20database%20%28immediate%20disconnection%29$dbh->=3D>%20disconnect;=3D20= >>=3D20>print%20"Content-type:%20text/html\n\nHello,%20World!\n";e= > xit;=3D20>>>%20------=3D_Part_626261_193540646.1764003591766-->>--Please%20= > keep%20replies%20on%20the%20mailing%20list." target=3D"_blank" rel=3D"noope= > ner noreferrer"> but guessing<br> you probably forgot to run ldconfig for t= > he libraries inside the chroot.<br> <br> however, it's debatable whether th= > ere's any point bothering with a<br> chroot jail if you're going to copy in= > a shell, libc, perl and a bunch<br> of CPAN, etc.</a>=20 > <br>=20 > <br>=20 > </blockquote>=20 > <blockquote> > =20 > </blockquote>=20 > <p> </p>=20 > <p> </p>=20 > <p># chroot /var/www/ /bin/sh &n= > bsp; = > <br> /bin/sh: No controlling tty (open /d= > ev/tty: No such file or directory)<br> /bin/sh: warning: won't have full jo= > b control</p>=20 > <p># ls -l<br> total 56<br> drwxr-xr-x 2 0 1 512 = > Nov 15 23:38 acme<br> drwxr-xr-x 2 0 1 512 Nov 23 1= > 6:13 bin<br> drwx-----T 2 67 1 512 Oct 12 18:32 cache<br>= > drwxr-xr-x 2 0 1 512 Nov 23 12:01 cgi-bin<br> drwx= > r-xr-x 2 0 1 512 Nov 15 10:53 conf<br> drwxr-xr-x&n= > bsp; 2 0 1 512 Nov 23 15:59 dev<br> drwxr-xr-x 2 0&= > nbsp; 1 512 Nov 23 16:04 etc<br> drwxr-xr-x 4 0 &nb= > sp;1 512 Nov 16 00:20 htdocs<br> drwxr-xr-x 2 0 1&n= > bsp; 512 Nov 15 23:02 logs<br> drwxr-xr-x 2 0 1 512= > Nov 24 02:27 perl<br> drwxr-xr-x 2 0 1 512 Nov 24 = > 23:18 run<br> drwxr-xr-x 2 0 1 512 Nov 25 01:36 sbi= > n<br> drwxr-xr-x 7 0 1 512 Nov 23 13:22 usr<br> drw= > xr-xr-x 3 0 1 512 Nov 25 02:06 var</p>=20 > <p># /sbin/ldconfig && echo 'LDCONFIG SUCCESS' <br> LD= > CONFIG SUCCESS</p>=20 > <p># cd perl/<br> # perl sqlite.pl &nbs= > p; &n= > bsp; <= > br> install_driver(SQLite) failed: Can't load '/usr/local/libdata/perl5/sit= > e_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so' for module DBD::SQLite: Can= > not load specified object at /usr/libdata/perl5/XSLoader.pm line 94.<br> &n= > bsp;at /usr/local/libdata/perl5/site_perl/amd64-openbsd/DBD/SQLite.pm line = > 16.<br> Compilation failed in require at (eval 5) line 3.<br> Perhaps a req= > uired shared library or dll isn't installed where expected<br> at sql= > ite.pl line 12.</p>=20 > <p> </p>=20 > <p> </p>=20 > </body> ></html> > ------=_Part_642578_2063540506.1764038680440-- > > -- Please keep replies on the mailing list.
