Hi,
Trying to launch democa out of the latest stable community release
OpenXPKI-3.28.2 at
Linux Debian 12.5 with
MariaDB 10.11.6
Followed steps advised by
https://openxpki.readthedocs.io/en/latest/quickstart.html
(configuration for /etc/openxpki/ fetched from openxpki/openxpki-config
project)
and in particular:
$ apt install mariadb-server libdbd-mariadb-perl
...
$ openxpkictl start
It says:
Starting OpenXPKI Community Edition v3.28.2
OpenXPKI server is not running or does not accept requests.
Status check failed
(See error log attached below.)
Now I remove libdbd-mariadb-perl and install libdbd-mysql-perl instead,
as server openxpki wanted.
This helps:
$ openxpkictl start
OpenXPKI Server is running and accepting requests.
DONE.
Is it reasonable to switch dbd-mariadb for dbd-mysql?
The quoted Quickstart insists (with red letters) that dbd-mariadb is a
preferable choice for MariaDB2 and OpenXPKI.
What is MariaDB2 (mentioned by Quickstart) by the way? Google only finds
this name inside the OpenXPKI pages.
Debian 12.5 has MariaDB 10.11.6. Is it MariaDB1 or MariaDB2?
Also name "MariaDB2" is present multiple times in the configuration of
openxpki/openxpki-config.
Is it safe to leave it there?
NB.
When project DBD-MariaDB was founded they claimed (see here:
https://github.com/perl5-dbi/DBD-MariaDB) that it will be better than
the project DBD-mysql, because
"This Perl DBI driver is a fork of the DBD::mysql
<https://metacpan.org/pod/DBD::mysql> driver and was created because
said issues in the original DBD::mysql have not been addressed for more
than a year."
But today the project DBD-mysql evolves more rapidly than the project
DBD-MariaDB:
https://metacpan.org/dist/DBD-mysql/changes
Regards, Sergei
======================
$> cat /var/log/openxpki.log (with the driver DBD-MariaDB installed)
2024/03/12 14:18:27 ERROR Database not connected; __error__ =>
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (you may
need to install the DBD::mysql module) (@INC contains: /etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.36.0 /usr/local/share/perl/5.36.0
/usr/lib/x86_64-linux-gnu/perl5/5.36 /usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.36
/usr/share/perl/5.36 /usr/local/lib/site_perl) at (eval 974) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, Sponge.
at /usr/share/perl5/DBIx/Handler.pm line 41.
[pid=4925|]
2024/03/12 14:18:27 FATAL Error during initialization task 'dbi':
Database not connected [pid=4925|]
2024/03/12 14:18:27 FATAL Exception during server initialization:
Database not connected; __error__ => install_driver(mysql) failed: Can't
locate DBD/mysql.pm in @INC (you may need to install the DBD::mysql
module) (@INC contains: /etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.36.0 /usr/local/share/perl/5.36.0
/usr/lib/x86_64-linux-gnu/perl5/5.36 /usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.36
/usr/share/perl/5.36 /usr/local/lib/site_perl) at (eval 974) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, Sponge.
at /usr/share/perl5/DBIx/Handler.pm line 41.
(Database not connected; __error__ => install_driver(mysql) failed:
Can't locate DBD/mysql.pm in @INC (you may need to install the
DBD::mysql module) (@INC contains: /etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.36.0 /usr/local/share/perl/5.36.0
/usr/lib/x86_64-linux-gnu/perl5/5.36 /usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.36
/usr/share/perl/5.36 /usr/local/lib/site_perl) at (eval 974) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, Sponge.
at /usr/share/perl5/DBIx/Handler.pm line 41.
) [pid=4925|]
======================
_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users
