Error after upgrading to trunk

rhekkers

I’m still testing/toying around with FOG, which so far works rather well with just windows being a bit of a jerk at moment. But now I tried upgrading to trunk as it might have resolved an issue. But now it reached the “you still need to install/update your database schema” the <x.x.x.x>/fog/management page only shows a white screen with the text “Error communicating with the database”

Re-installing won’t be too much of a hassle because it was still a test, but I want to know if there is a way to fix this.

ITSolutions

You say you tried upgrading to trunk, is this from 1.2? For trunk it is a good idea to do a fresh install and not upgrade from 1.2 as it has changed quite a bit

ITSolutions

@rhekkers Welcome to the FOG community, Just for future it is best that when you post let us know what OS FOG is on such as Ubuntu, CentOS, Debian, etc. Also the version of FOG, usually found in the cloud on the webUI, and if it has anything to do with the client the version of Windows you are using.

rhekkers

@ITSolutions It was upgraded from 1.2 yes. Thanks for notifying, then I’ll just reinstall it. I was using Ubuntu 14.04. I used the browsers Vivaldi and firefox to visit /fog/management on windows 8.1 pro. If it helps for future reference. Thank you for your quick response.

ITSolutions

@rhekkers No problem, definitely stick with 14.04, there have been problems reported with 16.04 and some of the packages FOG installs.

rhekkers

@ITSolutions I’ve seen them. Tried 16.04 first but has some PHP5 issues, now trying 14.04 which installed fine with 1.2. But now the trunk installation won’t let me install/update my database.

Reinstalled Ubuntu and fog (14.04.1LTS), but still the Error communicating with the database on a blank screen in Firefox.
It said it installed anything, but didn’t ask me for a password for the database. I gave the instruction I left the password for the database blank.

ITSolutions

@rhekkers Can you check to see if mysql is running?

sudo /etc/init.d/mysql status

If not then try starting it, sometimes the installer doesn’t start it correctly

sudo /etc/init.d/mysql start

rhekkers

@ITSolutions

It was running as process 14020, tried restarting it through
sudo /etc/init.d/mysql restart
and through
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
sadly it made no difference.

ITSolutions

@rhekkers Can you check /opt/fog/.fogsettings and see if the following lines are in it

snmysqluser="root";
snmysqlpass="this may contain a password";
snmysqlhost="p:localhost";

If you left the password blank then the snmysqlpass should look like this,

snmysqlpass='';

If it isn’t try blanking it out and rerunning the installer to see if it fixes the issue.

rhekkers

@ITSolutions
They have all been left blank.

I made a quick backup and tried using root without password in the user and localhost or the ipaddress as host. Neither of those combinations yielded results.

removed .fogsettings and copied .fogsettings.bak to .fogsettings

lionheart1986

@rhekkers @ITSolutions

I have same issue

What i tryed:

I had same problem as you FOG 1.3.0 Ubuntu 14.04 LTS

First i checkd:
/opt/fog/.fogsettings

and this positions was blank:
snmysqluser=“”;
snmysqlpass=“”;
snmysqlhost=“”;

2.Second i setup my sql pass

sudo dpkg-reconfigure mysql-server-5.5

and modify /opt/fog/.fogsettings

snmysqluser=“root”;
snmysqlpass=“mypassword”;
snmysqlhost=“p:localhost”;

i checked sql connection:

mysql -u root -p

but still have same issue

rhekkers

@lionheart1986 Did you recently install it, upgraded it from a previous trunk version, or upgraded it from 1.2 like I did? Just curious.

<edit>
I also pulled it from the git repository

lionheart1986

@rhekkers The first time I tried to do the upgrade from 1.2.0 but I had the same problem. Currently I installed a fresh system 14.04 but it did not help.

<edit>
On 1.2.0 during installation it asks me about setup sql password but on 1.3.0 it won’t ask

RLane

Also having this problem. Clean install on CentOS 7 x64 using the latest git version (7695).

Tom Elliott

Anybody having this issue, please post the log.

“I’m having this issue” where we don’t know what issue is even occurring doesn’t help anybody.

RLane

@Tom-Elliott Am I missing something here? /opt/fog/log is empty.

Tom Elliott

@RLane It should be under apache error logs. If it’s not getting that far, it should be under installer->bin/error_logs/fog_error_${versionInstalling}.log

RLane

@Tom-Elliott

fog_error_7695.log

/bin/lsb_release
/bin/systemctl
grep: /opt/fog/.fogsettings: No such file or directory
ln: failed to create symbolic link ‘/usr/lib/systemd/system/mysql.service’: File exists
ln: failed to create symbolic link ‘/usr/lib/systemd/system/mysqld.service’: File exists
ln: failed to create symbolic link ‘/etc/systemd/system/mysql.service’: File exists
ln: failed to create symbolic link ‘/etc/systemd/system/mysqld.service’: File exists
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

base: bay.uchicago.edu
epel: mirror.steadfast.net
extras: bay.uchicago.edu
remi: mirrors.mediatemple.net
remi-php56: mirrors.mediatemple.net
remi-safe: mirrors.mediatemple.net
updates: mirror.umd.edu
Package epel-release-7-6.noarch already installed and latest version
Nothing to do
package remi-release-7 is not installed
Retrieving http://rpms.remirepo.net/enterprise/remi-release-7.rpm
Preparing… ########################################
package remi-release-7.1-3.el7.remi.noarch is already installed
Loaded plugins: fastestmirror
================================== repo: remi ==================================
[remi]
async = True
bandwidth = 0
base_persistdir = /var/lib/yum/repos/x86_64/7
baseurl =
cache = 0
cachedir = /var/cache/yum/x86_64/7/remi
check_config_file_age = True
cost = 1000
deltarpm_metadata_percentage = 100
deltarpm_percentage =
enabled = True
enablegroups = True
exclude =
failovermethod = priority
gpgcadir = /var/lib/yum/repos/x86_64/7/remi/gpgcadir
gpgcakey =
gpgcheck = True
gpgdir = /var/lib/yum/repos/x86_64/7/remi/gpgdir
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
hdrdir = /var/cache/yum/x86_64/7/remi/headers
http_caching = all
includepkgs =
ip_resolve =
keepalive = True
keepcache = False
mddownloadpolicy = sqlite
mdpolicy = group:small
mediaid =
metadata_expire = 21600
metadata_expire_filter = read-only:present
metalink =
minrate = 0
mirrorlist = http://rpms.remirepo.net/enterprise/7/remi/mirror
mirrorlist_expire = 86400
name = Remi’s RPM repository for Enterprise Linux 7 - x86_64
old_base_cache_dir =
password =
persistdir = /var/lib/yum/repos/x86_64/7/remi

Tom Elliott

All should be fixed in latest.

Error after upgrading to trunk

fog_error_7695.log

120

12.1k

17.3k

155.3k