Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: michelandre on May 21, 2018, 05:50:35 AM

Title: Software Collections:MySQL55
Post by: michelandre on May 21, 2018, 05:50:35 AM

Hi all,

I am trying to install Software Collections:MySQL55 on a SME-9.2/64 new, fully updated.

From: https://wiki.contribs.org/Software_Collections:MySQL55

Code: [Select]

/sbin/e-smith/db yum_repositories set centos-sclo-rh repository \
Name 'Centos - RH Software Collections' \
BaseURL 'http://mirror.centos.org/centos/$releasever/sclo/$basearch/rh/' \
EnableGroups no \
Visible yes \
status disabled

signal-event yum-modify

yum --enablerepo=smecontribs,centos-sclo-rh install smeserver-mysql55
signal-event post-upgrade
signal-event reboot

On reboot after the signal-event... I recieved a lot of:

Code: [Select]

...
ERROR 1060 [42S21) at line 606: Duplicate Column name 'Event_priv'
ERROR 1060 [42S21) at line 611: Duplicate Column name 'Event_priv'
ERROR 1060 [42S21) at line 620: Duplicate Column name 'sql_mode'
ERROR 1060 [42S21) at line 659: Duplicate Column name 'originator'
ERROR 1060 [42S21) at line 663: Duplicate Column name 'time_zone'
ERROR 1060 [42S21) at line 666: Duplicate Column name 'character_set_client'
ERROR 1060 [42S21) at line 672: Duplicate Column name 'colation_connection'
ERROR 1060 [42S21) at line 678: Duplicate Column name 'db_collation'
...
A normal reboot gives no messages, all is OK.

I also tried to install with the community based software collection and same problem. I installed MediaWiki-1.30.0 with SMW and CharInsert. All worked well even with those errors.

I found: https://bugs.contribs.org/show_bug.cgi?id=7467 with almost the same problem.

Any help appreciated,

Michel-André

Title: Re: Software Collections:MySQL55
Post by: Jean-Philippe Pialasse on May 21, 2018, 12:55:51 PM

Not a blocker as you demonstrate.

Just open a bug, if you expect this to be fixed.

Title: Re: Software Collections:MySQL55
Post by: michelandre on May 21, 2018, 03:42:10 PM

Hi Jean-Philippe,

Thank you for your reply.

https://bugs.contribs.org/show_bug.cgi?id=10585

Michel-André

Title: Re: Software Collections:MySQL55
Post by: michelandre on May 29, 2018, 02:45:54 PM

Hi all,

An easy solution, install MySQL57. 8-)
https://wiki.contribs.org/Software_Collections:MySQL57

Michel-André

Title: Re: Software Collections:MySQL55
Post by: Jean-Philippe Pialasse on May 29, 2018, 02:53:06 PM

Quote from: michelandre on May 29, 2018, 02:45:54 PM

Hi all,

An easy solution, install MySQL57. 8-)
https://wiki.contribs.org/Software_Collections:MySQL57

Michel-André

not a solution.

you should only install this one if you really need it for a specific usage. Phpmyadmin is not compatible with it, and php mysql connector on base  php is not fully compatible.
An example you can not handle db users with phpmyadmin.

This is a big loss of function for a "solution" to an error which is just a noise and do not prevent the db to work.