[Koha] Unable to Access Koha # Critical

Tue Sep 3 18:44:16 NZST 2019

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 at 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 at 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 at 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 at 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 at 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.