Ubuntu 16.04 LTS

Hello,

I have set-up the Xibo CMS on Ubuntu 16 LTS 64-Bit. I uninstalled PHP7 and installed PHP 5.6.x. I used mariadb instead of mysql. The install completes correctly but when I try to log-in I cannot do so. I have tried this three times now and no success.

I tried the same install on Centos 7 64-Bit and it worked first time and the Centos Server is running Xibo happily.

Has anyone else had a similar issue with Ubuntu 16 LTS?

Regards,
Shahid

Hey Shahid,

I had the exact same problem and it seems to be PHP7. I had installed 5.6, every test I did on the server confirmed it was running 5.6… But it just wouldn’t work.

I wound up installing Ubuntu 14 LTS and everything worked perfectly first try. It just seems like it doesn’t matter what you do, if PHP 7 was installed, Xibo won’t work.

So I literally had this problem two days ago. It is PHP7 that’s causing the issue.

After some trial and error, I uninstalled PHP7 by uninstalling php-common. If you just uninstall PHP7.0, as I did initially, it just doesn’t work out, for some reason.

Then I installed the full php5.6 package and a couple other things (soap, etc.) that uninstalling php-common wiped out.

It was only after this that Xoom fired up without any problem, running PHP 5.6 on Ubuntu 16.04 LTS.

(Sidenote: Xoom seems to run A LOT faster under Ubuntu then it did under Windows Server. What was once a huge drawback for me - waiting forever for menus and previous to load - is no longer an issue. So happy I went through all the hassle.)

Hello Thomas,

I did some digging around on the Ubuntu Forums last night and uninstalling PHP7 doesn’t actually uninstall all of PHP7 and hence the issues.

There are some notes on how to uninstall PHP7 completely and some people trying to run both together.

I will do some more reading and try and work out what the Ubuntu Forums suggest and feed back here.

Regards,
Shahid

Hello MapleLeaf,

After your update to confirm it wasn’t just me, I did some digging around the Ubuntu Forums and there are some notes on this issue for other Apps. PHP7 doesn’t remove completely and I think even after the PHP 5.6 install some calls go to what is left of PHP 7.

There were some suggestions on how to remove PHP7 including using the purge option. But this then necessitates installing more PHP 5.6 components.

I will try and look at this at home later and let you know. I think it will work with Ubuntu 16 and its worth doing this as it has 5 years support.

Regards,
Shahid

It’s likely the database log format. You need to change it to be MIXED.

Hi Alex,

Thank you. Worked perfectly.

I permanently changed /etc/mysql/my.cnf and adjusted this setting:

binlog_format=‘Mixed’

Restarted the database and the CMS logged in perfectly on Ubuntu 16 LTS with PHP 5.6 installed.

Prior to this I used the following:

To view the binlog format log into the MariaDB or MySQL database and run:

show variables like ‘binlog_format’;

To adjust the binlog format temporarily to see if the CMS works run the following command in MariaDB or MySQL:

SET GLOBAL binlog_format = ‘MIXED’;

Will try and see if PHP7 and PHP 5.6 work together.

Regards
Shahid

Right. As you noted in this thread, I had to do a purging as well when taking out PHP7. I then installed PHP5.6 and a few components the uninstall/purge took out, and things worked fine.

Now that I’m participating in these forums, I’ll make a note of documenting the steps I take to fix things so I can share them in instances like this. :slight_smile: