Getting hung up on mysql install on Fedora 23
-
Following this guide
https://wiki.fogproject.org/wiki/index.php/Configuration_on_Fedora_Workstation
At the part where it says
When it asks, the installer directory should be /images (we pre-made this during the Fedora install)
I get the error error reading information on service mysqld no such file or directory, Failed!
I looked it up and read that Mariadb has replaced mysql. I’m not sure how to progress past this part if mysql won’t work, how do I use Mariadb instead?
systemctl status mariadb.service - says it’s running, it’s installed, but I don’t know what I’m supposed to do to get it to work with FOG.
-
I found these instructions instead
https://wiki.fogproject.org/wiki/index.php?title=Fedora_23_Server
While I’m not using the server version, it did seem to work. I was able to get to the web GUI and update. I will continue on with the setup and hope that things go smoothly
-
@mageta52 I wrote both of these articles, actually. The first one you posted was my first round with FOG, in February of 2015. I had a pretty rough time and was still pretty green to Linux.
I left a note at the top of the article suggesting to follow the newer tutorials.
-
@Wayne-Workman So now there’s a new problem. The initial management page, where you go to update is just blank. Below are the Apache logs
URL reads 192.168.235.52/fog/management/?node=schemaupdater
[Thu Apr 21 15:26:00.631141 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 48 [Thu Apr 21 15:26:00.631544 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::select_db(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 36 [Thu Apr 21 15:26:00.631566 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 48 [Thu Apr 21 15:26:00.631958 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::select_db(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 36 [Thu Apr 21 15:26:00.631979 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 48 [Thu Apr 21 15:26:00.704199 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::select_db(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 36 [Thu Apr 21 15:26:00.704252 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 48 [Thu Apr 21 15:26:00.776411 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::select_db(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 36 [Thu Apr 21 15:26:00.776460 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 48 [Thu Apr 21 15:26:00.776631 2016] [:error] [pid 10057] [client 192.168.235.52:34464] PHP Fatal error: Call to a member function get() on null in /var/www/html/fog/lib/pages/schemaupdaterpage.class.php on line 8 [root@localhost httpd]# -
@mageta52 Probably your mysql DB is not properly started.
service mysql status? Maybe your disk is full.df -h? Try starting the DBservice mysql start -
[root@localhost httpd]# service mysql start Redirecting to /bin/systemctl start mysql.service Failed to start mysql.service: Unit mysql.service failed to load: No such file or directory.However, on Fedora 23, didn’t Mariadb replace Mysql?
[root@localhost httpd]# service mariadb status -l Redirecting to /bin/systemctl status -l mariadb.service ● mariadb.service - MariaDB 10.0 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Active: active (running) since Thu 2016-04-21 15:22:40 CDT; 17h ago Main PID: 9012 (mysqld_safe) CGroup: /system.slice/mariadb.service ├─9012 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─9126 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sockFilesystem Size Used Avail Use% Mounted on devtmpfs 991M 0 991M 0% /dev tmpfs 1000M 572K 1000M 1% /dev/shm tmpfs 1000M 1.8M 998M 1% /run tmpfs 1000M 0 1000M 0% /sys/fs/cgroup /dev/sda2 20G 5.5G 13G 31% / tmpfs 1000M 56K 1000M 1% /tmp /dev/sda3 9.5G 53M 9.0G 1% /home /dev/sda1 976M 131M 778M 15% /boot /dev/sda6 239G 60M 227G 1% /images tmpfs 200M 16K 200M 1% /run/user/42 tmpfs 200M 24K 200M 1% /run/user/1000 tmpfs 200M 36K 200M 1% /run/user/0 -
Yes, use whatever service it is that handles your database.
-
So from the above output, it looks like the Mariadb service is running, and disk space seems to be okay. Where else could the problem be?
-
@mageta52 SELinux. Also, on Fedora, firewall is ON by default. instructions for these are in those tutorials. -and they are not the same for 21 and 23.
-
@Wayne-Workman
Both are disabled. I know it’s not as secure, but I just wanted to take that possibility out of the equation during the testing and setup.[root@localhost httpd]# service firewalld status Redirecting to /bin/systemctl status firewalld.service ● firewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled) Active: inactive (dead)[root@localhost httpd]# sestatus SELinux status: disabled -
@mageta52 if you go to where you put your FOG Trunk install files, go into
bin/error_logs/you will see some files in there, namedfog_error_xxxx.logThe xxxx should be the revision number your on. Can you supply us with that file?
-
Remoted in. Found an error in the schema-page and fixed it. THen found that the DB connections weren’t operating properly and fixed that. All is updated in the codebase too.
