On Saturday 25 October 2014 19.05:06 upscope wrote:
Originally had openSUSE 13.2 snapshot10112014.iso installed..This ran wit no problems. Configuration was and is:
[CODE]
@linux-1cbj:~> sudo /usr/sbin/fdisk -l
Disk /dev/sda: 931.5 GiB, 1000204886016 bytes, 1953525168 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disklabel type: gpt Disk identifier: 1B4640A9-841E-41AA-9D48-7917046056CC
Device Start End Sectors Size Type /dev/sda1 2048 2105343 2103296 1G Microsoft basic data [gpt] /dev/sda2 2105344 85995519 83890176 40G Microsoft basic data [swap] /dev/sda3 85995520 295708671 209713152 100G Microsoft basic data [ /] /dev/sda4 295708672 1082138623 786429952 375G Microsoft basic data [/home]
Disk /dev/sdb: 931.5 GiB, 1000204886016 bytes, 1953525168 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disklabel type: gpt Disk identifier: F3DF41EC-FCEA-4FFF-BB79-932FC2270198
Device Start End Sectors Size Type /dev/sdb1 2048 321535 319488 156M EFI System [gpt] /dev/sdb2 321536 157614079 157292544 75G Microsoft basic data [/] /dev/sdb3 157614080 1048899583 891285504 425G Microsoft basic data [/home] /dev/sdb4 1048899584 1153757183 104857600 50G Microsoft basic data [swap2]
Disk /dev/sdc: 931.5 GiB, 1000204886016 bytes, 1953525168 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disklabel type: dos Disk identifier: 0x969b09a3
Device Boot Start End Sectors Size Id Type /dev/sdc1 63 209712572 209712510 100G c W95 FAT32 (LBA) /dev/sdc2 209728575 1468019698 1258291124 600G 83 Linux [Backup13.x] [/CODE]
Completely deleted sdb - all partitions.
Then installed opensuse from openSUSE 13.2 DVD. Changed repo's to factory.
updated, only a couple of updates since distribution dvd links to factory..
Everything I have tested so far worked except Nvidia driver and mysql..
Tried both command line and phpmyadmin to get to mysql server;
Following is from command line attempt;
here are the instal sql files:
[CODE] linux-1cbj:~ # rpm -qa |grep mysql
libmysqlclient_r18-10.0.13-2.3.1.x86_64 libmysqlcppconn6-1.1.2-6.2.2.x86_64 libmysqlclient18-10.0.13-2.3.1.x86_64 libreoffice-base-drivers-mysql-4.3.1.2-1.5.x86_64 libQt5Sql5-mysql-5.3.2-2.1.x86_64 libqt4-sql-mysql-4.8.6-4.3.1.x86_64 php5-mysql-5.6.0-1.6.x86_64 perl-DBD-mysql-4.021-8.1.4.x86_64 libmysqlclient-devel-10.0.13-2.3.1.x86_64 libmysqld18-10.0.13-2.3.1.x86_64 [/CODE]
Here is the error on start of mysql. Note: there is no socket in
/varrun/mysql/
[CODE] @linux-1cbj:~> mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2 "No such file or directory") [/CODE]
[CODE] @linux-1cbj:~> ls -l /var/run/mysql total 8 -rw-r--r-- 1 root root 32 Oct 25 15:17 protecteddir -rw-r--r-- 1 root root 22 Oct 25 15:17 tmpdir [/CODE]
Not sure why it is running in protected mode. I did not specify it ever. What puts the socket there? It exists in 13.1.
[CODE] apache2.service - The Apache Webserver
Loaded: loaded (/usr/lib/systemd/system/apache2.service; enabled) Active: active (running) since Sat 2014-10-25 14:44:42 PDT; 3h 53min ago> Main PID: 1640 (httpd2-prefork)
Status: "Total requests: 0; Current requests/sec: 0; Current traffic: 0> B/sec"
CGroup: /system.slice/apache2.service
├─1640 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
├─1831 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
├─1832 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
├─1833 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
├─1835 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
└─1836 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D
SYSTEMD -DFOREGROUND -k start
@linux-1cbj:~> systemctl status mysql.service mysql.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled) Active: failed (Result: exit-code) since Sat 2014-10-25 15:17:57 PDT; 3h> 20min ago
Process: 6400 ExecStart=/usr/lib/mysql/rcmysql start (code=exited,
status=1/FAILURE)
@linux-1cbj:~> sudo systemctl start mysql.service root's password: Job for mysql.service failed. See "systemctl status mysql.service" and "journalctl -xn" for details.
@linux-1cbj:~> systemctl status mysql.service mysql.service - MySQL server> Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled) Active: failed (Result: exit-code) since Sat 2014-10-25 18:39:34 PDT; 11min> ago
Process: 7547 ExecStart=/usr/lib/mysql/rcmysql start (code=exited,
status=1/FAILURE)
@linux-1cbj:~> sudo journalctl -xn root's password: -- Logs begin at Sun 2014-10-19 05:16:19 PDT, end at Sat 2014-10-25 18:54:56 PDT. -- Oct 25 18:39:34 linux-1cbj rcmysql[7547]: Something went wrong Oct 25 18:39:34 linux-1cbj systemd[1]: Failed to start MySQL server. -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel Are we really talking about mysql or mariadb ??? Above code is talking about mariadb, but it does the same thing with
Answers in-line On Sunday, October 26, 2014 09:49:29 AM you wrote: the mysql server.
After a reboot (with first systemctl disable mysql.service) check if directory /run/mysql exist Will try this and post result later today, presently on 13.1. if not I would say there's a packaging bug with a missing file to recreate the path /run/mysql at reboot time.cd .. That's what I was leaning to. Tried to search Bugzilla but did not see anything about specific 13.2 RC1 error. Will Look again. cat /usr/lib/tmpfiles.d/mysqld.conf # See tmpfiles.d(5) for details d /run/mysql 0755 mysql mysql -
Check if you add this file it is working, then report bug against the package.
-- openSUSE 13.1(Linux 3.11.10-21-desktop x86_64| Intel(R) Quad Core(TM) i5-4440 CPU @ 3.10GHz|8GB DDR3| GeForce 8400GS (NVIDIA-Linux-x86_64-340.46)|KDE 4.14.2 -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org