Topic: [Announce]: Update script for 6.0.1-01 for testing (v2)

[gregswallow]

[ANNOUNCE] Update script for 6.0.1-01 for testing (v2)

By Greg Swallow (greg_at_skynetbc.com)

LATEST VERSION CAN BE FOUND HERE:
I made a Wiki Page with a copy of the 2 scripts and I am hoping others will help keep it up to date and add things if you'd like.  
It can be found here:
http://no.longer.valid/phpwiki/index.php/Latest%20version%20of%20update%20scripts


This is version 2 of this script - the original one is here:
http://forums.contribs.org/index.php?topic=24202.0

So here are the two scripts.  I'd suggest running the downloads.sh script twice.  The second time it should only take half a second as it won't download the files twice.  If you see any file not found errors, then maybe figure out another place to download that file from, as ***you really don't want to run the updates script if you are missing any files***.  Once you have all the files you can run the update script.  Everything installs cleanly for me, but I haven't tested this much.  

What's included: (Again, thanks to everyone who contributed to these!)
PHP 4.3.8
http://forums.contribs.org/index.php?topic=23270.0
http://forums.contribs.org/index.php?topic=23301.0

Phpmyadmin-2.6.0-10 (updated again)
http://forums.contribs.org/index.php?topic=23242.msg92492#msg92492

Zlib 1.2.1.1-4
Proftpd 1.2.10-es1
fetchmail 6.2.5-1
rsync 2.6.2-1
gnupg 1.2.4-0_19
openssh 3.9p1-1es1
openssl 0.96m-1es1
http://sme.swerts-knudsen.dk/downloads/Updates/6.0.1/

imp 3.2.5-01dm (and associated updates)
http://no.longer.valid/mylinks/singlelink.php?cid=117&lid=416

apache 1.3.31-5 (required compat-glibc, db4, python2.3)
mod_ssl 2.8.19-1
(no howto/contrib available - not extensivly tested)

mysql 4.0.21-0
http://forums.contribs.org/index.php?topic=23920.0

Spamfilter add-on panel
http://sme.swerts-knudsen.dk/howtos/howto_29.htm

AWStats 2.3.3-0 (added)
http://www.neddix.de/

Antivirus Panel (added)
http://sme.swerts-knudsen.com/howtos/howto_22.htm

Mail Blocking panel (added - replaces the double bounce deletion howto)
http://www.dungog.net/sme/files/index.php

Securemail (added)
http://www.pagefault.org/howto/securemail.shtml

RootKit Hunter (added)
http://mirror.contribs.org/smeserver/contribs/dthomas/smeserver/6.x/Contrib/rkhunter/

---------------------------------------------

Downloads.sh
(The wget commands should each be on one line - be careful when copying and pasting)
Moved script to wiki page here:
http://no.longer.valid/phpwiki/index.php/Latest%20version%20of%20update%20scripts

Updates.sh
(run this after you are sure you have all the downloads)
Moved script to wiki page here:
http://no.longer.valid/phpwiki/index.php/Latest%20version%20of%20update%20scripts

NOTE:  If you are having a problem with one of the updates this script installs, please try to find your answer from the author of the invdividual conrib.  Any suggestions to make this script work better though are welcomed.

As well if you have any suggestions of things to add, that would be great.  I'd love to hear about the things that you just need to have on every SMEserver you install.  

Greg

[cjensen]

Great script!!

One concern... is the owner of sme.swerts-knudsen.dk OK with the traffic he is likely to receive?

Also, his site is apparently down at present.  Is there another location of these files?  It would be nice to have them mirrored on ibiblio.org, (hint to sme.swerts-knudsen.dk).

Thanks again for the leg work in compiling this and the script to boot!!

Craig Jensen

[smeghead]

Hi Greg

Quick question. what is your exact testing base for this?

Is it the contribs 6.0.1 or one of the custom builds floating around (Keane or Skav)?

TIA

[wyron]

A word of caution regarding the MySQL update!
I tried to install it from the original contrib on a freshly installed 6.01-01, and lost mysql entirely (rpm -q mysql = package mysql not installed / rpm -Uvh mysql*et cetera = packages already installed).
After yet another fresh install I tried this script - with exactly the same result.
Btw. swerts-knudsen isn't down. He just got a new external ip-address this morning (Danish time), so DNS is perhaps a bit unstable through today.

[gregswallow]

wyron - check that in the mysql folder that you have all 4 files.  I would try doing just that upgrade and see what errors you are getting.  If you are still having any problems, I would suggest posting a message to the forum thread where that particular contrib was announced.

smeghead - I have only tried it with the 6.01-01 release.  And only installing it on a fresh install - not as an upgrade.  If you have some of these or other addons, I wouldn't run the script, rather do one thing at a time as needed.

cjensen - Perhaps here: http://www.ibiblio.org/pub/Linux/distributions/smeserver/contribs/swerts-knudsen/ - But it seemed like other site is more updated.  He has a PayPal donate button on his site (seems to be working now), which I'm sure he would appreciate people using if they have found his contributions useful, and to help with the bandwith - http://sme.swerts-knudsen.com/.
 
My idea was to link to the authors site so you will always have the latest rpms, and know where to find updated ones, or help with problems.  I think that is better than downloading all the files and uploading them to one server.

[cjensen]

Mysql issues...

Make sure this section:
---------------------------------------
chkconfig --levels 2345 mysql on
mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /root/.my.cnf
ln -s /usr/sbin/mysqld /usr/libexec/
service mysqld restart
/usr/bin/mysql_fix_privilege_tables
cd ..
-----------------------------------
...copies into your script on a separate line for each command.  My issue was with this not being the case.  Running them each separatly after fixed my issue.

For securemail:
If you get a failed deps message...
install these first:
e-smith-smtp-authentication-6.0.1-02dc.noarch.rpm \
e-smith-ssl-imap-6.0.1-02dc.noarch.rpm \
e-smith-ssl-mailfront-6.0.1-02dc.noarch.rpm \
e-smith-ssl-popd-6.0.1-02dc.noarch.rpm...
Then install:
e-smith-securemail-6.0.1-01dc.noarch.rpm

All of the above are deps of the last.

Script works great though!!  Great option for updates.  I have always loved Jesper's scripts as well.

Craig Jensen

[jdanvers]

 Guys...  see below    
++++++++++++++++++++++++++++++++++++++

I just built a new box from scratch - 6.01-01 (or whatever the contribs.org version number is...  lol! ) - anyway - fresh install.  I'm updating / adding on right now via this script (nice piece of work too!) and just want to let everyone know that the myphpadmin download will fail.  It is trying to fetch phpmyadmin-2.6.0-8 - the file that is at the contibuters space (nightspirit) is 2.6.0-9 - ~NINE~.  That will have to be change in the updates script as well.

I didn't catch any other "404's" - there may have been some but I didn't have my putty sroll buffer set big enough - I definately caught this one though.  just thought I'd pass it on...  

-=- jd -=-

[jdanvers]

   
Greg / Wyron...

I am experiencing the exact same thing that he (Wyron) has experienced - brand new install - mysql is dead - as in non-existent.  

Ummmm ...  any suggestions on how to resolve this???  I have all four files per the download script:
MySQL-client-4.0.21-0.i386.rpm
MySQL-devel-4.0.21-0.i386.rpm
MySQL-server-4.0.21-0.i386.rpm
MySQL-shared-compat-4.0.21-0.i386.rpm

... the rpm db appears to be wacked.  I just tried (for the hell of it) rpm -e MSQL*.rpm ---> those four files (after repeated rpm -qa | grep sql and being told that mysql is installed).  Guess what rpm -e MYSQL*.rpm got me - RPM-client, -devel, server, etc...  not installed!  Arghh....  lol (shaking head)

I'm doing a rpm --rebuilddb right now...

I'll post later... its getting late and I might have to just fall back, punt, and put the old box back up for the time being.

-=- jd -=-

[wyron]

Well, the situation has changed a bit at my house.
The rpm's are still not registered ('rpm -qa | grep mysql' turns out only e-smith-mysql and phpmyadmin), but mysql is working anyway.
I once more did the post-upgrade commands mentioned in the original contrib howto, and since then phpmyadmin can access the databases.
Horde/Imp is working as well since webmail is suddenly accessible.
I'm confused (at a rather low level) ???

[edb]

After upgrade Horde has no users?
How long is the "/sbin/e-smith/signal-event post-upgrade" command suppose to take? I find that it just sits with a blinking prompt forever? Can anyone point me in the right direction. Thanks for your help

Ps: Otherwise I think that the upgrade script is of tremendous assistance to all SME users. Thanks for all your hard work ...

Ed

[gregswallow]

The rpm's are still not registered ('rpm -qa | grep mysql' turns out only e-smith-mysql and phpmyadmin), but mysql is working anyway.

Try :

rpm -qa | grep MySQL

Capitalization is everything.

I think it's best for anyone having problems with the MySQL part of the updates is to try the update manually on a clean install as described here (or just check that when you copy and paste the script it is the same as this) - http://forums.contribs.org/index.php?topic=23920.0 - all I have done is copy these instructions into the script.

Greg

[smeghead]

.. jst ran the update on a reasonably modified SME 6.0 box and found probs with the MySQL component; the table update routine failed.

I back tracked step by step and concluded that the MySQL 4 installed partially failed so I reinstalled the rpms with --nodeps and ran each of the additional commands manually one by one - they all worked fine.

HTH

[edb]

Thanks Greg that fixed my issue.  

Ed

[gregswallow]

I am testing a few things right now that I will probably add:

Lets you control the access of ftp users:
http://www.dungog.net/sme/files/dungog-proftpd-chroot-0.1-5.noarch.rpm

Allows webmail users to change their password: (be careful with this - see contribs.org link first - and notes on page 2 for another solution)
http://no.longer.valid/mylinks/singlelink.php?cid=89&lid=426
http://www.ibiblio.org/pub/Linux/distributions/smeserver/contribs/dmusty/SME6.0/webmail/passwd/

Newer version of Awstats:
http://sme.swerts-knudsen.com/howtos/howto_7.htm

Fetchmail for users pop3 accounts:
http://forums.contribs.org/index.php?topic=22814.0

Backup2Ws - (for >2GB backups)
http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/6.x/beta/backup2ws/

Enable HTML webmail:
http://sme.swerts-knudsen.com/howtos/howto_3.htm

Also noticed there is a PHP 4.3.9 install script announced in the forums.
http://forums.contribs.org/index.php?topic=24305.0


Just wondering if anyone has any suggestions of things to add to the script...  What else do you guys install on your servers???

Greg

[kirkf]

Hi.  Looks like a great script.  I usually install:

clam/amavis
pattern matching
rblsmtp
securemail
rkhunter
ssh/ssl updates

I have one concern about your proposed additions:

Allows webmail users to change their password:
http://www.ibiblio.org/pub/Linux/distributions/smeserver/contribs/dmusty/SME6.0/webmail/passwd/

This contrib is not ready for widespread distribution just yet.  It seems to work with fresh installs, but completely breaks upgraded systems.  Details are here:


http://no.longer.valid/mylinks/singlelink.php?cid=89&lid=426

Kirk[/quote]