-osTicket-v1.14.4
-PHP 7.4.3
==============================================
systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.25 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2020-11-25 15:42:13 EST; 5s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1852 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 1859 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1867 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery
; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$V>
Process: 1950 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1952 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 1919 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 31 (limit: 9451)
Memory: 69.9M
CGroup: /system.slice/mariadb.service
└─1919 /usr/sbin/mysqld
Nov 25 15:42:13 ticketmaster systemd[1]: Starting MariaDB 10.3.25 database server...
Nov 25 15:42:13 ticketmaster mysqld[1919]: 2020-11-25 15:42:13 0 [Note] /usr/sbin/mysqld (mysqld 10.3.25-MariaDB-0ubuntu0.20.04.1) starting as process 1919 ...
Nov 25 15:42:13 ticketmaster systemd[1]: Started MariaDB 10.3.25 database server.
Nov 25 15:42:13 ticketmaster /etc/mysql/debian-start[1954]: Upgrading MySQL tables if necessary.
Nov 25 15:42:13 ticketmaster debian-start[1970]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
==============================================
/var/log/mysql/error.log
2020-11-25 13:41:20 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2020-11-25 13:41:51 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2020-11-25 13:41:51 0 [ERROR] Plugin 'Aria' init function returned error.
2020-11-25 13:41:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-11-25 13:41:51 0 [Note] InnoDB: Using Linux native AIO
2020-11-25 13:41:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-25 13:41:51 0 [Note] InnoDB: Uses event mutexes
2020-11-25 13:41:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-25 13:41:51 0 [Note] InnoDB: Number of pools: 1
2020-11-25 13:41:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-25 13:41:51 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-11-25 13:41:51 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-25 13:41:51 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-25 13:41:51 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:51 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:51 0 [Note] InnoDB: Retrying to lock the first data file
2020-11-25 13:41:52 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:52 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:53 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:53 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:54 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:54 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-11-25 13:41:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-11-25 13:41:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
==============================================
I CAN login if I use "mysql -u root -p" because I set and know the current password. Still it gives this error when I start the mysqld.service
==============================================
Where I noticed this was a problem:
-Simply put, when you try to create a ticket and hit "Create Ticket" you are automatically logged out.