Monthly Archives: March 2017

ERROR 1290 (HY000) at line 1: The MySQL server is running with the –secure-file-priv

mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.00 sec)

mysql> Bye

mysql -e "SELECT CONCAT('KILL ',ID,';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'user' AND COMMAND = 'Query' AND TIME > 100 INTO OUTFILE '/var/lib/mysql-files/kill_list.txt';" && mysql -e "source /var/lib/mysql-files/kill_list.txt" && rm -rf /var/lib/mysql-files/kill_list.txt

sddm won’t start

[vit@localhost ~]$ systemctl list-unit-files | grep sddm
sddm.service enabled
[vit@localhost ~]$ systemctl status default.target
● multi-user.target – Multi-User System
Loaded: loaded (/usr/lib/systemd/system/multi-user.target; enabled; vendor preset: disabled)
Active: active since Fri 2017-03-17 08:55:56 EET; 4min 8s ago
Docs: man:systemd.special(7)

Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
[vit@localhost ~]$ cat /proc/cmdline
BOOT_IMAGE=/vmlinuz-4.9.13-201.fc25.x86_64 root=/dev/mapper/fedora00-root ro rd.lvm.lv=fedora00/root vconsole.font=latarcyrheb-sun16 rd.lvm.lv=fedora00/swap rhgb quiet LANG=en_US.UTF-8
[vit@localhost ~]$ sudo systemctl set-default graphical.target
Removed /etc/systemd/system/default.target.
Created symlink /etc/systemd/system/default.target → /usr/lib/systemd/system/graphical.target.

[core:emerg] [pid :tid ] (28)No space left on device: AH00023: Couldn’t create the proxy mutex

[core:emerg] [pid 7732:tid 140396300543936] (28)No space left on device: AH00023: Couldn’t create the proxy mutex
[proxy:crit] [pid 7732:tid 140396300543936] (28)No space left on device: AH02478: failed to create proxy mutex

Fix:

ipcs | grep apache | awk ‘{print $2}’ > sem.txt
for i in `cat sem.txt`; do { ipcrm -s $i; }; done

Permanant fix:

vi /etc/sysctl.conf

kernel.msgmni = 1024
kernel.sem = 250 256000 32 1024