Koozali.org: home of the SME Server

Software Collections:MySQL57

Offline calisun

  • *
  • 601
  • +0/-0
Software Collections:MySQL57
« on: March 04, 2020, 08:11:16 AM »
It finally happened, Wordpress will no longer run on default SME install.
Now Wordpress required SQL 5.6 or higher to function.

So I have installed Software Collections:MySQL57
Using phpMyAdmin, I have exported my database from default SQL and tried to import into MySQL57.

The issue is that my Wordpress database is almost 200MB, but the message in MySQL57 states that maximum import allowed is 100MB.

So I have issued following command:
Code: [Select]
db configuration setprop php MemoryLimit 200M
db configuration setprop php PostMaxSize 200M
db configuration setprop php UploadMaxFilesize 200M
expand-template /etc/php.ini
sv t httpd-e-smith

But the message inside MySQL57 still tells me that maximum import size is 100MB

Any suggestions?
« Last Edit: March 04, 2020, 08:15:35 AM by calisun »
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Software Collections:MySQL57
« Reply #1 on: March 04, 2020, 09:16:59 AM »
Make sure you are setting configs for php57, perhaps

# db configuration show php57
# db configuration setprop php57 MemoryLimit 200M

I dont have 57 installed but this is one of my other setups

# db configuration show php70
php70=configuration
    AllowUrlFopen=Off
    MaxExecutionTime=30
    MaxFileUpload=20
    MaxInputTime=60
    MemoryLimit=128M
    PhpModule=disabled
    PostMaxSize=20M
    UploadMaxFilesize=10M
--
qui scribit bis legit

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Software Collections:MySQL57
« Reply #2 on: March 04, 2020, 03:58:38 PM »
To be accurate...

https://wordpress.org/about/requirements/

Quote
MySQL version 5.6 or greater OR MariaDB version 10.1 or greater.

Note: If you are in a legacy environment where you only have older PHP or MySQL versions, WordPress also works with PHP 5.6.20+ and MySQL 5.0+, but these versions have reached official End Of Life and as such may expose your site to security vulnerabilities.

PHP - fair enough.

I tried to find EOL for MySQL 5.5 Hmm. Oracle are not particularly forward with that.. SNAFU....

This says 3rd Dec 2018
https://endoflife.software/applications/databases/mysql

This says it has 'sustaining support'

https://www.mysql.com/support/eol-notice.html

Quote
January 20, 2019
MySQL 5.5 covered under Oracle Lifetime Sustaining Support
Per Oracle's Lifetime Support policy, as of December 31, 2018, MySQL 5.5 is covered under Oracle Sustaining Support.

Either way 5.7 should work OK, and as long as your DB is not exposed to the world you are probably OK with older versions if you so choose.

...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline calisun

  • *
  • 601
  • +0/-0
Re: Software Collections:MySQL57
« Reply #3 on: March 04, 2020, 05:16:00 PM »
PHP - fair enough.

I have PHP Software Collections installed since last year and I have PHP 7.3 pointing to the iBay where my Wordpress is installed.
I did not implement it system wide, only by iBay, so the system is still using default PHP.



I tried to find EOL for MySQL 5.5 Hmm. Oracle are not particularly forward with that.. SNAFU....

I found this:


So the default MySQL in SME server has EOL in 2013

So going back to my original question, how do I allow MySQL57 to import database larger than 100MB?
« Last Edit: March 04, 2020, 06:22:41 PM by calisun »
SME user and community member since 2005.
Want to install Wordpress in iBay of SME Server?
See my step-by-step How-To wiki here:
http://wiki.contribs.org/Wordpress_Multisite

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Software Collections:MySQL57
« Reply #4 on: March 04, 2020, 07:46:47 PM »
Quote
So the default MySQL in SME server has EOL in 2013

Nope. You need to really read this stuff carefully and not jump to assumptions. It isn't quite so simple, and this has been explained here a number of times before.

SME is unusual because RHEL are unusual, and SME follows RHEL. The installed versions are supported by RHEL for life of the OS.

So both the *installed* versions of PHP 5.3.X and MySql 5.1.x are supported by Redhat until RHEL 6 goes EOL.

The fact that application may want a newer version does not change the fact they are still supported. But ONLY those versions.

The SCL versions are supported too, but ONLY for whatever the current versions of PHP are so currently PHP 7.2+

That isn't our fault. It's an upstream choice (and prior to SCL you had to take risks with various different builds of PHP)

RHEL chooses longevity & stability over latest & flakiest. I believe they supply quite a few places with strict compliance requirements so new stuff is tested over months before being released. Think say spys & other government orgs, banks etc.

They want it hardened, not the newest stuff on the block.

If you want cutting edge then use another distro.

As it is your near 10 year old OS can still run PHP 7.3 and MySql 5.7 and Maria db.

As to your original question I don't know right now. I have one of a nearly 500mb I restore for testing in mysql 5.5 and it is fine with stock settings.

You don't actually know which bit is failing right now. You refer to mysql57 telling you but provide no evidence of that.

What do your logs tell you?

Why don't you just import in the command line?

Something like:

Code: [Select]
mysql57 -u root mydatabase < daily_database_backup.sql
That may tell us a bit more.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Software Collections:MySQL57
« Reply #5 on: March 05, 2020, 01:07:08 PM »
Any suggestions?

Have you tried doing the restore at the command line?

Here's an old forum topic discussing sql database backup/restore:
https://forums.contribs.org/index.php/topic,53934.msg281179.html#msg281179

Offline Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Software Collections:MySQL57
« Reply #6 on: March 05, 2020, 02:28:56 PM »
Phpmyadmin has its own settings.

I can only recommand to use command line for larger db

Simply use mysql57 as command in place of mysql. 

Also to note the phpmyadmin veesion we have does not handle well mysql57. The user db has changed hence you need to handle users using command line.