• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. pavon87
    3. Posts
    P
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 2
    • Best 0
    • Controversial 0
    • Groups 0

    Posts made by pavon87

    • RE: Database migration and database in external host

      Reading the forum I was expecting this answer, but I tried it equals! hahaha
      I will move to 1.3.0.

      I have less tan 15 clients, I can do it manually

      Thank you very much!

      posted in Linux Problems
      P
      pavon87
    • Database migration and database in external host
      Server
      • FOG Version: 1.2.0
      • OS: Ubuntu 16.04
      Description

      Hi all,

      I’m installing Fog 1.2.0 in a new VM with Ubuntu 16.04, preparing an update of my old server, with Fog .32 and Ubuntu 12.04.

      After a few work, finaly i have it working in 16.04, to get it i did:
      - Delete referenes of php5 in install file fog_1.2.0/lib/ubuntu/config and install manually the php7 versions
      - Delete line “@set_magic_quotes_runtime(0);” of file /var/www/fog/commons/init.php to avoid it, because is deprecated function in php7
      - Dissable “Strict SQL Mode” adding a file “disable_strict_mode.cnf” in configuration folder with this content:
      [mysqld]
      sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

      After this tweaks I have Fog 1.2.0 apparently working, but I have two questions:

      First, I want to upgrade my old database, I try follow the instructions (Wiki -> Upgrade to 1.x.x) but when I import the sql dump of old DB, nothing happends. I miss something?

      The other problem also is related with database, with 0.32 version I had the DB in other host, a dedicated DB server (with diferents DB), but with 1.2.0 I can’t find the right way to do it. I tried to change it before install, indicating the host, user and pass (with snmysqluser, snmysqlpass, snmysqlhost) in .install.sh but fog still connecting to localhost. In 0.32 version exist a file …fog/commons/config.php with a directive MYSQL_HOST that I used for this purpose.

      Any idea?

      Thanks in advance!

      posted in Linux Problems ubuntu 16.04 mysql
      P
      pavon87
    • 1 / 1