after starting xampp in linux, mysql server gets killed

Problems with the Linux version of XAMPP, questions, comments, and anything related.

after starting xampp in linux, mysql server gets killed

Postby tanzeem » 01. October 2019 11:26

I have installed the Bitnami XAMPP

XAMPP for Linux 64bit 5.6.40-1
having
- PHP to 5.6.40
- MariaDB to 10.1.37
- OpenSSL 1.0.2q
installed on Debian GNU Linux 9
I tried to start my xampp for linux

Code: Select all
tanzeem@debian-tzm:~$ sudo /opt/lampp/lampp restart
[sudo] password for tanzeem:
Restarting XAMPP for Linux 5.6.40-1...
XAMPP: Stopping Apache...ok.
XAMPP: Stopping MySQL...not running.
XAMPP: Stopping ProFTPD...ok.
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.

Immediately the mysql server stops automatically with the following message
Code: Select all
 /opt/lampp/bin/mysql.server: 264: kill: No such process


I have the following entries int /etc/mysql even after I uninstalled my default mysql server
debian.cnf koha-common.cnf mariadb.conf.d/
debian-start mariadb.cnf

Part of Content of file `/opt/lampp/var/mysql/<hostname>.err` for the date after reinstalling xampp and when tried to start xampp in linux is attached:

Code: Select all
2019-10-01 13:22:46 6702 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:22:47 140061563180864 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:22:47 140061563180864 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 6850 ...
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:22:47 140061563180864 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibu62mPf' (Errcode: 13 "Permission denied")
2019-10-01 13:22:47 7f629fb85740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:22:47 140061563180864 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:22:47 140061563180864 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:22:48 140061563180864 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:22:48 140061563180864 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:22:48 140061563180864 [ERROR] Aborting

2019-10-01 13:22:48 6702 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 13:24:16 7244 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:24:16 140082405451584 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:24:16 140082405451584 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 7389 ...
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:24:16 140082405451584 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibPSJwOL' (Errcode: 13 "Permission denied")
2019-10-01 13:24:16 7f677a042740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:24:16 140082405451584 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:24:16 140082405451584 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:24:16 140082405451584 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:24:16 140082405451584 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:24:16 140082405451584 [ERROR] Aborting

2019-10-01 13:24:16 7244 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 13:25:47 7799 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:25:47 140061192259392 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:25:47 140061192259392 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 7946 ...
2019-10-01 13:25:47 140061192259392 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:25:48 140061192259392 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibtoby2q' (Errcode: 13 "Permission denied")
2019-10-01 13:25:48 7f62899c8740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:25:48 140061192259392 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:25:48 140061192259392 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:25:48 140061192259392 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:25:48 140061192259392 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:25:48 140061192259392 [ERROR] Aborting

2019-10-01 13:25:48 7799 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 14:50:43 2896 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 14:50:44 139657902384960 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 14:50:44 139657902384960 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 3041 ...
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 14:50:44 139657902384960 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibVmFshy' (Errcode: 13 "Permission denied")
2019-10-01 14:50:44 7f04a3a96740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 14:50:44 139657902384960 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 14:50:44 139657902384960 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 14:50:44 139657902384960 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 14:50:44 139657902384960 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 14:50:44 139657902384960 [ERROR] Aborting

2019-10-01 14:50:44 2896 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 15:22:43 3503 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 15:22:44 140687290926912 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 15:22:44 140687290926912 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 3648 ...
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 15:22:44 140687290926912 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibLoJISK' (Errcode: 13 "Permission denied")
2019-10-01 15:22:44 7ff450000740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 15:22:44 140687290926912 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 15:22:44 140687290926912 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 15:22:44 140687290926912 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 15:22:44 140687290926912 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 15:22:44 140687290926912 [ERROR] Aborting

2019-10-01 15:22:44 3503 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
tanzeem
 
Posts: 1
Joined: 01. October 2019 09:03
XAMPP version: XAMPP for Linux 64bit 5.6.40-0
Operating System: Debian GNU/Linux 9

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests