Error after upgrading to trunk

[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

1. 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”;

3. 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.