[Koha] Problems with MYQSL

Russel G. P. Shihepo russellgeeps at gmail.com
Wed Apr 20 01:16:18 NZST 2022


Dear Community

I have run into some problems with mysql when i tried to root access
because I am attempting to set up my vufind, see the steps below:
*My version is: *
>From Koha interface/  About page:
MySQL version: mysql Ver 15.1 Distrib 10.3.34-MariaDB, for debian-linux-gnu
(x86_64) using readline 5.2

*However when i attempt to access it like below i got stuck: *

root at sciwhk-abcd:~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

*and then i try;*

sudo service mysql start
*I get:*
Failed to start mysql.service: Unit mysql.service not found.

*then i try to reinstalling the package:*
*apt-get install mysql-server mysql-client and i get this message*

0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up koha-common (21.11.04-2) ...
failed to load external entity "/etc/koha/sites/namscience/koha-conf.xml"
Upgrading database schema for namscience
unable to locate Koha configuration file koha-conf.xml at
/usr/share/koha/lib/C4/Context.pm line 170.
unable to locate Koha configuration file koha-conf.xml at
/usr/share/koha/lib/C4/Context.pm line 170.
unable to locate Koha configuration file koha-conf.xml at
/usr/share/koha/lib/C4/Context.pm line 170.
Use of uninitialized value $file in exists at
/usr/share/koha/lib/Koha/Config.pm line 78.
Use of uninitialized value $file in hash element at
/usr/share/koha/lib/Koha/Config.pm line 79.
Use of uninitialized value $file in hash element at
/usr/share/koha/lib/Koha/Config.pm line 82.
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't
call method "get" on an undefined value at
/usr/share/koha/lib/Koha/Database.pm line 61. at
/usr/share/koha/lib/Koha/Database.pm line 139
dpkg: error processing package koha-common (--configure):
 installed koha-common package post-installation script subprocess returned
error exit status 2
Setting up dictionaries-common (1.28.1) ...
Can't exec "/var/lib/dpkg/info/dictionaries-common.config": Permission
denied at /usr/share/perl/5.30/IPC/Open3.pm line 281.
open2: exec of /var/lib/dpkg/info/dictionaries-common.config configure
1.28.1 failed: Permission denied at /usr/share/perl5/Debconf/ConfModule.pm
line 59.

My question is: Does uninstalling the myqsl packages affect koha data or is
there a solution i can perhaps explore further.


Thank you for help in advance

Regards
Russel
*Wissenschaftliche Gesellschaft - Namibia*


More information about the Koha mailing list