Topic: SME 6.5 Beta 1 Update scripts

[gregswallow]

Just starting slowly with adding contribs to the 6.5 Beta 1 release.  I made a wiki page here that (so far) install yum and updates any rpms in the official /updates/ directory, and updates mysql to 4.0.23.  Will be adding a few more things tonight...  

http://no.longer.valid/phpwiki/index.php/SME6.5UpdateScripts

Anyone is welcome to add/fix things, but I'd like to keep the theme of the updates on this wiki page in-line with the SME philosophy of not adding anything that may cause the server to be less secure or negatively affect the stability.

Hope you like it,

[Tib]

Hello gregswallow,

I ran all 4 update scripts on my SME 6.5 test server ... all went ok except I lost phpmyadmin.

I got a:
phpMyAdmin - Error
phpMyAdmin was unable to read your configuration file!
Then it says to click on the link config.inc.php ... when I click on it it comes up with ... The requested URL /phpmyadmin/config.inc.php was not found on this server.

I'm guessing that the file was missing ... a simple uninstall of phpmyadmin then a re-install fixed it.

Now i have to mention as well that before I ran the sme6.5 update scripts I had run the smeplus script before hand ... had no errors other than spam filter pannel not working ... but on boot it says that spamassasin loaded ok.

will test some more later.

Regards

Tib

[bovnet]

step 2 - there isnt any /etc/openldap.pw

should it be /etc/openldap/ldap.pw ?

[bovnet]

step 2 then causes this

Jan 23 15:29:50 private esmith::event[2136]: Added SMEServer-up *
Jan 23 15:29:50 private esmith::event[2136]: S06conf-lilo=action|Event|local|Action|S06conf-lilo|Start|1106494179 537295|End|1106494190 686621|Elapsed|11.1493
26
Jan 23 15:29:52 private mysql.init: Loading 20horde.mysql_update_privs.sql into mysql succeeded
Jan 23 15:29:52 private mysql.init: Loading 20mysql_migrate_horde.sql into mysql succeeded
Jan 23 15:29:52 private mysql.init: Loading 21horde.mysql_set_password.sql into mysql succeeded
Jan 23 15:29:52 private mysql.init: Loading 30mysql_create_tables.sql into mysql succeeded
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.s
o' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm lin
e 206.
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2:  at (eval 2) line 3
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: Compilation failed in require at (eval 2) line 3.
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: Perhaps a required shared library or dll isn't installed where expected
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2:  at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Jan 23 15:29:53 private mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Jan 23 15:29:54 private mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded
J

[gregswallow]

step 2 - there isnt any /etc/openldap.pw

should it be /etc/openldap/ldap.pw ?

<
yup - sorry - I just fixed that

[gregswallow]

step 2 then causes this
...
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/mysql/mysql.s
o' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm lin
e 206.
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2:  at (eval 2) line 3
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: Compilation failed in require at (eval 2) line 3.
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2: Perhaps a required shared library or dll isn't installed where expected
Jan 23 15:29:53 private 50turba_upgrade_1.1_to_1.2:  at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Jan 23 15:29:53 private mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Jan 23 15:29:54 private mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded
J

I don't get those errors.  Maybe try it again on a fresh install of 6.5b1.

[bovnet]

it was fresh install or at least it was when announced.

Its only had the edonkey howto added which is just a single rpm

Very strange

[Tib]

Hello

Just a curiosity question ... when you update mysql is it neccessary to uninstall the old one.

In SME 6.5 I had updated to mysql 4.0.22 earlier then I ran gregswallow's update script but it didn't uninstall the old mysql:
rpm -e --nodeps mysql mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

as you can see it's all in lower case ... ver 4.0.22 has some uppercase same as MySQL 4.0.23:
MySQL mysql-server, MySQL-client etc

Even though it didn't uninstall the old mysql it is still working after the update ... as far as I can tell anyway ... it loads and I can access it.

Regards,

Tib

[gregswallow]

Tib, if you installed 4.0.22 already on 6.5beta1 using the method for 6.0.1, then the mysql_fix privelege_tables command probably had errors that maybe you didn't notice.  You'd just have to make this script to fix it:

Code: [Select]

#!/bin/sh
MYSQL_PW=sed q /etc/openldap/ldap.pw
/usr/bin/mysql_fix_privilege_tables --user=root --password=$MYSQL_PW

[jahlewis]

tried step 1 and 2 against a clean/fresh install of 6.5b1

step one performed fine - no errors.  Thanks!

step two gave a grantor error, and when the server rebooted, gave a lot of mysql update errors, but it looks as though mysql did not start, when I ran a service mysql start, it started up fine, and webmail worked fine.

I'm looking forward to the completion of your php update, and the imp/turba scripts...

thanks for your work.

[gregswallow]

Step two gave a grantor error, and when the server rebooted, gave a lot of mysql update errors, but it looks as though mysql did not start, when I ran a service mysql start, it started up fine, and webmail worked fine.

Hmm., I just updated that part yesterday (without testing it)  oops.  I will check it tonight.

[guest22]

Greg, YFYI please keep in mind that any final version will require further modifications to any contribs/script. The 6.5B1 is STILL beta

[gregswallow]

Greg, YFYI please keep in mind that any final version will require further modifications to any contribs/script. The 6.5B1 is STILL beta

Yup, I realize that.  My goal with this is just to get Horde3/IMP4 working - which requires PHP > 4.30, and while I don't think MySQL 4 is required for Horde3, it is a fairly popular addition to SME 6 I think - and the upgrade procedure did change (at least in the beta )

PS - What is YFYI? - I googled it any found nothing.  My guess was "Yo! For Your Information"  Am I close?