Hi. I would like to solve this error on OpenBSD 7.8. My sqlite.pl does not
work. Out of /var/www, I used ldd command. # ldd
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so:
Start End Type Open Ref GrpRef Name
00000efff7ac4000 00000efff7af9000 dlib 2 0 0
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so
00000f00ba75c000 00000f00ba92a000 rlib 0 1 0
/usr/local/lib/libsqlite3.so.37.34 00000f0066013000 00000f0066020000
rlib 0 1 0 /usr/lib/libpthread.so.28.0 00000f00c23f7000
00000f00c2428000 rlib 0 1 0 /usr/lib/libm.so.10.1
00000f008c799000 00000f008c7b7000 rlib 0 1 0 /usr/lib/libz.so.7.1 I
copied some files in /var/www. # cp /usr/bin/env /var/www/usr/bin/ # cp
/usr/bin/perl /var/www/usr/bin/ # cp /usr/libexec/ld.so /var/www/usr/libexec/ #
cp /usr/lib/libm.so.10.1 /var/www/usr/lib/ # cp /usr/lib/libc.so.102.0
/var/www/usr/lib/ # cp /usr/lib/libperl.so.26.0 /var/www/usr/lib/ # cp -r
/usr/libdata/perl5/* /var/www/usr/libdata/perl5/ # cp /usr/lib/libz.so.7.1
/var/www/usr/lib/ # cp /usr/local/lib/libsqlite3.so.37.34
/var/www/usr/local/lib/ # cp /usr/lib/libpthread.so.28.0 /var/www/usr/lib/ #
cp /usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so
/var/www/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/ # cp
-r /usr/local/libdata/perl5/site_perl/*
/var/www/usr/local/libdata/perl5/site_perl/ Then I moved in /var/www. #
chroot /var/www/ /bin/sh # ldd
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so:
Cannot load specified object
/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so:
exit status 1 # ls -l /usr/local/lib/libsqlite3.so.37.34 -rw-r--r-- 1 0 1
2055936 Nov 23 14:50 /usr/local/lib/libsqlite3.so.37.34 # ls -l
/usr/lib/libpthread.so.28.0 -r--r--r-- 1 0 1 129304 Nov 23 14:51
/usr/lib/libpthread.so.28.0 # ls -l /usr/lib/libm.so.10.1 -r--r--r-- 1 0 1
595096 Nov 23 12:19 /usr/lib/libm.so.10.1 # ls -l /usr/lib/libz.so.7.1
-r--r--r-- 1 0 1 297856 Nov 23 14:37 /usr/lib/libz.so.7.1
# perl -cw sqlite.pl
sqlite.pl syntax OK # perl sqlite.pl
install_driver(SQLite) failed: Can't load
'/usr/local/libdata/perl5/site_perl/amd64-openbsd/auto/DBD/SQLite/SQLite.so'
for module DBD::SQLite: Cannot load specified object at
/usr/libdata/perl5/XSLoader.pm line 94. at
/usr/local/libdata/perl5/site_perl/amd64-openbsd/DBD/SQLite.pm line 16.
Compilation failed in require at (eval 5) line 3. Perhaps a required shared
library or dll isn't installed where expected at sqlite.pl line 12. Here is
my sqlite.pl #!/usr/bin/perl use strict; use warnings; use DBI; #
Connection details (DSN: Data Source Name) # 'sqlite:dbname=:memory:' is the
standard DSN for an in-memory SQLite database. my $dsn =
"dbi:SQLite:dbname=:memory:"; # Connect to the database my $dbh =
DBI->connect($dsn, "", "", { RaiseError => 1, # Throw an exception if
connection fails AutoCommit => 1, }) or die $DBI::errstr; # Disconnect
from the database (immediate disconnection) $dbh->disconnect; print
"Content-type: text/html\n\nHello, World!\n"; exit;
