user wird ständig rausgeworfen

OtSchr

Benutzer
Beiträge
8
Hallo, ich benutze Ubuntu 18.04 mit der aktuellen mariadb.
Wenn ich über phpmyadmin anmelde, klappt das erst mal nicht.
Ich muss den Dienst neu starten:
sudo systemctl restart mariadb
Danach kann ich mich anmelden und auch was tun.
Aber nach so ca. 30 Minuten bin ich wieder raus. Ein neues Anmelden klappt nicht.
Ich muss den Dienst jedesmal neu starten.
Gibt da einen Parameter?
Oder woran liegt das?
Danke euch für Info.
 
Werbung:
Wo wirst Du rausgeworfen?
Aus phpmyadmin oder aus mariadb?

Wie lautet die Meldung zum Rauswurf?

PHP ist ein anderes System als die Datenbank Maria DB.
Du könntest Dich per cmd cli in der DB anmelden und warten, ob Du dort auch rausgeworfen wirst. Vermutlich wird das nicht geschehen. Dann hättest Du ein PHP Problem, kein Datenbankproblem.

Wieviel Maria DB und wieviel PBP Installationen hast Du auf dem System?
 
Hier der Versuch mich in der Konsole (mariadb / mysql) anzumelden:

mariadb -ugrit -p
Enter password:

Hier die Meldungen:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

mysql -ugrit -p
Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Dann der Neustart:

sudo systemctl restart mariadb
[sudo] Passwort für otmar:

Und der neue Versuch sich anzumelden:

mariadb -ugrit -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.12-MariaDB-1:10.4.12+maria~bionic mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
 
Hier das log-file: (sagt mir nicht wirklich etwas was auf den Fehler hinweist, daher alles von eben):

2020-04-25 10:53:31 0 [Note] InnoDB: Using Linux native AIO
2020-04-25 10:53:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-25 10:53:31 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:53:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:53:31 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:53:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:53:31 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-04-25 10:53:31 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-25 10:53:31 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:53:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-25 10:53:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:53:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:53:32 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:53:32 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-25 10:53:32 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:53:32 0 [Note] InnoDB: 10.4.12 started; log sequence number 1693888; transaction id 10176
2020-04-25 10:53:32 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-25 10:53:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:53:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200425 10:53:32
2020-04-25 10:53:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-25 10:53:34 0 [Note] Reading of all Master_info entries succeeded
2020-04-25 10:53:34 0 [Note] Added new Master_info '' to hash table
2020-04-25 10:53:34 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2020-04-25 10:56:13 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-04-25 10:56:13 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-25 10:56:13 0 [Note] InnoDB: FTS optimize thread exiting.
2020-04-25 10:56:13 0 [Note] InnoDB: Starting shutdown...
2020-04-25 10:56:13 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-04-25 10:56:13 0 [Note] InnoDB: Buffer pool(s) dump completed at 200425 10:56:13
2020-04-25 10:56:15 0 [Note] InnoDB: Shutdown completed; log sequence number 1693897; transaction id 10177
2020-04-25 10:56:15 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 10:56:15 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-04-25 10:56:15 0 [Note] InnoDB: Using Linux native AIO
2020-04-25 10:56:15 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-25 10:56:15 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:56:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:56:15 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:56:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:56:15 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-04-25 10:56:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-25 10:56:15 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:56:15 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-25 10:56:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:56:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:56:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:56:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-25 10:56:15 0 [Note] InnoDB: 10.4.12 started; log sequence number 1693897; transaction id 10176
2020-04-25 10:56:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:56:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-25 10:56:15 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-25 10:56:15 0 [Note] InnoDB: Buffer pool(s) load completed at 200425 10:56:15
2020-04-25 10:56:15 0 [Note] Reading of all Master_info entries succeeded
2020-04-25 10:56:15 0 [Note] Added new Master_info '' to hash table
2020-04-25 10:56:15 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2020-04-25 11:00:59 8 [Warning] Access denied for user 'otmar'@'localhost' (using password: NO)
2020-04-25 11:01:23 9 [Warning] Access denied for user 'otmar'@'localhost' (using password: NO)
2020-04-25 11:01:32 10 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-04-25 11:02:13 11 [Warning] Access denied for user 'otmar'@'localhost' (using password: NO)
2020-04-25 11:11:15 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-04-25 11:11:15 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-25 11:11:15 0 [Note] InnoDB: FTS optimize thread exiting.
2020-04-25 11:11:15 0 [Note] InnoDB: Starting shutdown...
2020-04-25 11:11:15 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-04-25 11:11:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 200425 11:11:15
2020-04-25 11:11:16 0 [Note] InnoDB: Shutdown completed; log sequence number 1693906; transaction id 10177
2020-04-25 11:11:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 11:11:16 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-04-25 11:13:23 0 [Note] InnoDB: Using Linux native AIO
2020-04-25 11:13:23 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-25 11:13:23 0 [Note] InnoDB: Uses event mutexes
2020-04-25 11:13:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 11:13:23 0 [Note] InnoDB: Number of pools: 1
2020-04-25 11:13:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 11:13:23 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2020-04-25 11:13:23 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-04-25 11:13:23 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 11:13:23 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-04-25 11:13:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 11:13:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 11:13:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 11:13:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-04-25 11:13:23 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 11:13:23 0 [Note] InnoDB: 10.4.12 started; log sequence number 1693906; transaction id 10176
2020-04-25 11:13:23 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-04-25 11:13:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 11:13:23 0 [Note] InnoDB: Buffer pool(s) load completed at 200425 11:13:23
2020-04-25 11:13:23 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-04-25 11:13:23 0 [Note] Reading of all Master_info entries succeeded
2020-04-25 11:13:23 0 [Note] Added new Master_info '' to hash table
2020-04-25 11:13:23 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
 
Irgendwas fährt wohl den DB Server herunter:
2020-04-25 10:56:13 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown

Läuft MariaDB auf deiner Arbeitsrechner und gibt es dort irgendwelche Stromsparmaßnahmen? Standby? Screensaver?
 
Das ist eben passiert, ohne das ich auf die DB zugegriffen hätte:

2020-04-25 11:28:23 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-04-25 11:28:23 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-25 11:28:23 0 [Note] InnoDB: FTS optimize thread exiting.
2020-04-25 11:28:23 0 [Note] InnoDB: Starting shutdown...
2020-04-25 11:28:23 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-04-25 11:28:23 0 [Note] InnoDB: Buffer pool(s) dump completed at 200425 11:28:23
2020-04-25 11:28:24 0 [Note] InnoDB: Shutdown completed; log sequence number 1693915; transaction id 10177
2020-04-25 11:28:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 11:28:24 0 [Note] /usr/sbin/mysqld: Shutdown complete
 
Apr 25 11:28:23 otmar-Aspire-5750G systemd[1]: mariadb.service: Start operation timed out. Terminating.
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.206074] audit: type=1400 audit(1587806903.040:79): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.268200] audit: type=1400 audit(1587806903.100:80): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.368020] audit: type=1400 audit(1587806903.200:81): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.468438] audit: type=1400 audit(1587806903.300:82): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.568797] audit: type=1400 audit(1587806903.404:83): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.669176] audit: type=1400 audit(1587806903.504:84): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.769560] audit: type=1400 audit(1587806903.604:85): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:23 otmar-Aspire-5750G kernel: [ 2137.821662] audit: type=1400 audit(1587806903.656:86): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:24 otmar-Aspire-5750G kernel: [ 2138.845315] audit: type=1400 audit(1587806904.680:87): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:24 otmar-Aspire-5750G kernel: [ 2138.845675] audit: type=1400 audit(1587806904.680:88): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=3523 comm="mysqld" requested_mask="w" denied_mask="w" fsuid=112 ouid=0
Apr 25 11:28:24 otmar-Aspire-5750G systemd[1]: mariadb.service: Failed with result 'timeout'.
Apr 25 11:28:24 otmar-Aspire-5750G systemd[1]: Failed to start MariaDB 10.4.12 database server.
Apr 25 11:28:47 otmar-Aspire-5750G nautilus[2778]: g_key_file_load_from_file: assertion 'file != NULL' failed
 
Werbung:
Zurück
Oben