[mythtv-users] Mythweb PHP issue after upgrade from Ubuntu 16.04 to 18.04

[Bob Sully]

On Tue, 2018-10-02 at 15:48 -0700, Bob Sully wrote:
> On Tue, 2018-10-02 at 02:07 -0700, Bob Sully wrote:
> > > On 02/10/18 07:04, Bob Sully wrote:
> > > > Hi all -
> > > Upgraded Myth from 0.28 to 0.29 on Ubuntu 16.04 lastweek.
> > > Noproblems, completely painless.Upgraded the OS to 18.04 tonight.
> > > Mostly painless (a lot betterthanthe last one, from 14.04 to
> > > 16.04!)However, I'm running into issues with Mythweb and
> > > PHP,apparentlysince 18.04 is using 7.2. I have already enabled
> > > the 7.2modules inapache2. I also copied the mysqli.ini
> > > filefrom/etc/php/7.0/apache2/conf.d/ to
> > > /etc/php/7.2/apache2/conf.d/andrestarted apache2.
> > > I'm getting this error in Mythweb:Fatal Error!!NoTrans: You are
> > > missing a php extension for mysqlinteraction.Please install php-
> > > mysqli or similar!!datetime: 2018-10-01 22:40:43 (PDT) errornum:
> > > 256[rcs at vader: ~]$ sudo apt install php-mysqli error type:
> > > UserErrorerror string: !!NoTrans: You are missing a php extension
> > > formysqlinteraction. Please install php-mysqli orsimilar!!
> > > filename:/usr/share/mythtv/mythweb/includes/php_version_check.php
> > > errorline: 20
> > > However:$ sudo apt install php-mysqliReading package lists...
> > > DoneBuilding dependency treeReading stateinformation... DoneNote,
> > > selecting 'php7.2-mysql' instead of 'php-mysqli'php7.2-mysql is
> > > already the newest version (7.2.10-0ubuntu0.18.04.1).0 upgraded,
> > > 0 newly installed, 0 to remove and 1not upgraded.What am I
> > > missing?Thanks in advance!When I did the in-place upgrade from
> > > 16.04 to 18.04 thefollowingresolved the mythweb issue :sudo mv
> > > /etc/php/7.0/apache2/conf.d/20-
> > > mythweb.ini/etc/php/7.2/apache2/conf.d/20-mythweb.inisudo a2enmod
> > > php7.2 #tosort out apache2sudo systemctl restart apache2I did not
> > > have to do anything with 20-mysqli.iniMike
> >
> > Hi, Mike - I had seen your post to that effect previously, and
> > hadcopied the 20-mythweb.ini file to /etc/php/7.2/apache2/conf.d/
> > -should have mentioned that also.That didn't solve this problem,
> > though.Thanks, though!
> > --Regards,Bob_______________________________________________mythtv-
> > users mailing listmythtv-users at mythtv.org
> > http://lists.mythtv.org/mailman/listinfo/mythtv-users
> > http://wiki.mythtv.org/Mailing_List_etiquette
> > MythTV Forums: https://forum.mythtv.org
> >
> 
> is mysqli uncommented in php.ini ?
> 
> Glen:It was in /etc/php/7.2/apache2/php.ini but not in
> /etc/php/7.2/cli/php.ini.
> I went ahead and uncommented it and restarted - still no change.
> <scratching my head>
> Thanks

> i'm using arch linux, so how ubuntu configures apache and php is
> different. for me i just used the git for mythweb, and followed this
> wiki
> https://wiki.archlinux.org/index.php/MythWeb and it has always
> worked. i would still take a look at the arch wiki and see if you can
> relate it back to ubuntu. also have a look and double check the
> open_basedir folders in the php.ini and make sure everything you are
> pointing to is in the list. i hope something in there helps you get it
> work


Hi, Glen - thanks

Mythweb is already set up as per the wiki.  However, open_basedir in 
php,ini is commented out.  Never have set it before.  Which directory 
should it be set to, if used?

This is driving me nuts.  The mysqli extension *is* being loaded, as 
when I uncomment the "extension = mysqli" line in both /etc/php/7.2/cli 
and /etc/php/7.2/apache2, php --version tells me that the module has 
already been loaded.

Thanks -
Bob