Unable to Access Koha # Critical
Hi, With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57 I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was running successfully and only during weekend (sunday), system was not accessed. but, when I tried to access Koha for Checkout and Checkin today, I am facing problem It is very critical for me to get this fixed, as it is a busy day for users and for me. Kindly help to fix this error. I am looking forward to hearing from you. #Critical Problem #Priority 1 So for I tried to know the status of MySQL: (as 'root' user) 1) mysql login ------------------------ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2) Mysql Status --------------------------- service mysql start start: Job failed to start 3) System Log Verification ---------------------------- tail -f syslog Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Linux version 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016 (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39) Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] KERNEL supported cpus: Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Intel GenuineIntel Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] AMD AuthenticAMD Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] NSC Geode by NSC Sep 3 11:07:42 gechlibrary bluetoothd[786]: Bl 4) PID ps aux | grep mysqld root 3603 0.0 0.0 4688 832 pts/2 S+ 11:19 0:00 grep --color=auto mysqld 5) MySQL log ----------------- /var/log/mysql/error.log is empty 6) MySQL Status ------------------------------ # mysqld status 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting as process 4036 ... 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled. 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8 190903 11:30:48 InnoDB: Using Linux native AIO mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30) 190903 11:30:48 InnoDB: Error: unable to create temporary file; errno: 30 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error. 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mysqld: Too many arguments (first extra is 'status'). Use --verbose --help to get a list of available options 190903 11:30:48 [ERROR] Aborting 190903 11:30:48 [Note] mysqld: Shutdown complete -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish@gmail.com College Website: www.gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library
Satish, Just a hunch... Pls check free diskspace Regards -indranil On Tue 3 Sep, 2019, 12:12 PM SATISH, <lis4satish@gmail.com> wrote:
Hi,
With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57
I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was running successfully and only during weekend (sunday), system was not accessed. but, when I tried to access Koha for Checkout and Checkin today, I am facing problem It is very critical for me to get this fixed, as it is a busy day for users and for me. Kindly help to fix this error. I am looking forward to hearing from you.
#Critical Problem #Priority 1
So for I tried to know the status of MySQL: (as 'root' user)
1) mysql login ------------------------ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
2) Mysql Status --------------------------- service mysql start start: Job failed to start
3) System Log Verification ---------------------------- tail -f syslog Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Linux version 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016 (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39) Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] KERNEL supported cpus: Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Intel GenuineIntel Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] AMD AuthenticAMD Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] NSC Geode by NSC Sep 3 11:07:42 gechlibrary bluetoothd[786]: Bl
4) PID ps aux | grep mysqld root 3603 0.0 0.0 4688 832 pts/2 S+ 11:19 0:00 grep --color=auto mysqld
5) MySQL log ----------------- /var/log/mysql/error.log is empty
6) MySQL Status ------------------------------ # mysqld status 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting as process 4036 ... 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled. 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8 190903 11:30:48 InnoDB: Using Linux native AIO mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30) 190903 11:30:48 InnoDB: Error: unable to create temporary file; errno: 30 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error. 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mysqld: Too many arguments (first extra is 'status'). Use --verbose --help to get a list of available options 190903 11:30:48 [ERROR] Aborting
190903 11:30:48 [Note] mysqld: Shutdown complete
-- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish@gmail.com College Website: www.gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Indranil, The system is dedicated to Koha Server only. The diskspace details are as follows. root@gechlibrary:/home/satish# df -h Filesystem Size Used Avail Use% Mounted on udev 2.0G 4.0K 2.0G 1% /dev tmpfs 396M 1.1M 395M 1% /run /dev/sda1 413G 5.6G 386G 2% / none 4.0K 0 4.0K 0% /sys/fs/cgroup none 5.0M 8.0K 5.0M 1% /run/lock none 2.0G 4.0K 2.0G 1% /run/shm none 100M 0 100M 0% /run/user /dev/sda3 1.9G 63M 1.7G 4% /boot /dev/sda5 37G 1.1G 34G 4% /home regards Satish
Hi Is it possible you have done dome modification at my.cnf? mysql can't start... perhaps it was a modification in the past and now has been reboot the changes have been activated... I suggest to start analyzing my.cnf if you have not knowledge on this file, perhaps backup it, and replace by my.cnf from standard installation El mar., 3 sept. 2019 a las 8:42, SATISH (<lis4satish@gmail.com>) escribió:
Hi,
With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57
I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was running successfully and only during weekend (sunday), system was not accessed. but, when I tried to access Koha for Checkout and Checkin today, I am facing problem It is very critical for me to get this fixed, as it is a busy day for users and for me. Kindly help to fix this error. I am looking forward to hearing from you.
#Critical Problem #Priority 1
So for I tried to know the status of MySQL: (as 'root' user)
1) mysql login ------------------------ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
2) Mysql Status --------------------------- service mysql start start: Job failed to start
3) System Log Verification ---------------------------- tail -f syslog Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Linux version 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016 (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39) Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] KERNEL supported cpus: Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Intel GenuineIntel Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] AMD AuthenticAMD Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] NSC Geode by NSC Sep 3 11:07:42 gechlibrary bluetoothd[786]: Bl
4) PID ps aux | grep mysqld root 3603 0.0 0.0 4688 832 pts/2 S+ 11:19 0:00 grep --color=auto mysqld
5) MySQL log ----------------- /var/log/mysql/error.log is empty
6) MySQL Status ------------------------------ # mysqld status 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting as process 4036 ... 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled. 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8 190903 11:30:48 InnoDB: Using Linux native AIO mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30) 190903 11:30:48 InnoDB: Error: unable to create temporary file; errno: 30 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error. 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mysqld: Too many arguments (first extra is 'status'). Use --verbose --help to get a list of available options 190903 11:30:48 [ERROR] Aborting
190903 11:30:48 [Note] mysqld: Shutdown complete
-- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish@gmail.com College Website: www.gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Director Passeig Comte Vilardaga, 118 3-3 08980 -Sant Feliu de Llobregat - Tel: 933 856 138 hagud@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
Hi Hugo, Thank you for the reply. I have not modified the file at /etc/mysql/my.cnf. I do not have good knowledge about MySQL. Only my.cnf file back is enough or entire folder /etc/mysql is required to be backedup ?
From where do I get standard installation of my.cnf. please advise.
regards Satish
participants (3)
-
Hugo Agud -
Indranil Das Gupta -
SATISH