Apache Friends Support Forum

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