Debian Etch Released

[till]

Lets all welcome the long awaited Debian Etch :)

http://lists.debian.org/debian-announce/debian-announce-2007/msg00002.html

That's really a nice easter gift.

[sjau]

Hears so in irc that it shall be released today but it wasn't yet at noon :)

Great that it's out now :)

[edge]

Now the next nightmare.. Upgrading a "perfect" running (live) Dell PowerEdge SC 1425 from Debian Sarge (32bit) to Etch :/

Knowing me I'll f**k it up badly :(

[sjau]

you could wait 2-3 days until falko writes the perfect howto for etch :)

[edge]

you could wait 2-3 days until falko writes the perfect howto for etch :)

Knowing falko, he is working at it as we speak, and that it will be online later today :-)

[sjau]

not much time left for "today" - just about 1h....

but I see your point... he now has a new toy to play with ^^

[Hans]

Debian 4.0, a nice gift for Easter indeed, but now the upgrade...

I have read some articles, how to upgrade from 3.1 to 4.0, but i really like to know what is the best and recommended way to do this upgrade.

Probably, there is more to then changing /etc/apt/sources.list, an apt-get update and finally an apt-get dist-upgrade. I do not like a spaghetti of independencies, so a small howto would be nice! :D

[falko]

Here you go: http://www.howtoforge.com/perfect_setup_debian_etch :)

[bschultz]

Thank You!!!!! I haven't gone through the HOW-TO yet, but can I ask why you recommend Courier on Etch and Postfix on Sarge?


edit: now that I'm done with the setup, nevermind! Thanks again!

[till]

He recommends postfix on etch and sarge. Postfix is the MTA. What has changed is the usage of courier as pop3 and imap deamon because it supports maildie instead of mbox format. the courier installation was optional in the sarge howto and is now the default.

[Hans]

Today, i've succesfully updated my ISPConfig test-server.
This is what i've done (it might help others):

Verify if the /etc/apt/sources.list has the right content, it should be:

deb http://security.debian.org/ stable/updates main

deb http://ftp.nl.debian.org/debian/ stable main
deb-src http://ftp.nl.debian.org/debian/ stable main

Checking for available updates:
Apt-get update

Make the system up to date:
Apt-get upgrade

Check the current kernel:
uname -r
Output: 2.6.8-2-386

Checking for new available kernels for my system:
apt-cache search kernel-image | grep 386

apt-get install kernel-image-2.6.8-3-386

Remove old kernel:
dpkg --purge --force-remove-essential kernel-image-2.6.8-2-386

Reboot the system with the new kernel.

apt-get update
(You'll see the kept back packages).

Here we go to Etch...(Crossing my fingers)
apt-get dist-upgrade

or:

aptitude -f --with-recommends dist-upgrade

Later on this week, i plan to update my two production servers!

:)

[till]

Thanks for reporting your update success. That's why I love Debian :) Have you ever tried this with SuSe... , I did, but only once and never again.

[Hans]

:D No Till, no Suse for me! Debian is rock solid!

Successful without any independencies!!!
And...ISPConfig is not affected at all. Just up and running!
Great system.

[edge]

Later on this week, i plan to update my two production servers!

:)

Good luck! I'll wait till I'm at the datacenter, cause for sure this will go wrong for me when I do this myself ;/

An other option for me is to see if Till or Falko can do this! (i'll pay!)

I can not afford one of my servers to go down for more than 10 minutes! (I've got two that I would like to get Etch on)

Anyway. I'll have to wait 10 days cause I'm off to home (Scotland)

[Hans]

@Edge,

We are here to help. Do not have nightmares! ;)

[schmidtedv]

Well, I did it your way, Hans...exept at the end it shows:

Starting Courier IMAP-SSL server: imapd-ssl.
Errors were encountered while processing:
sasl2-bin
E: Sub-process /usr/bin/dpkg returned an error code (1)

Might not be important by now, I'm going to reboot now.

On the other hand, did you chose not to take the updated config-files for all or did you look through them and put ispconfig-configuration in in the new files? I left the old ones for now....and hope my server is still working, otherwise this will become a long night....

[schmidtedv]

A first view...it seemed to work, although it would be nice to se the maybe important changes that would have been done with the etch-config-files which I skipped for now...

PHP is 4.4.4 and MySQL is 5.0.32 after dist-upgrade...hope this makes no problems :-)

Actually, pearl (was it pearl?) was throwing out warnings during the upgrade process because of my de_euro...that there are some missing modules for it, but this I guess wasn't important, too.....

[Hans]

Giving the command:

aptitude -f --with-recommends dist-upgrade

gives you better control and helps you to solve probable independencies.

You can perform that command after all, it does not hurt.

[schmidtedv]

Thanks, right now I look through the differencec between 3.1 and 4 by kicking php4 and get php5 by removing the old howto-3.1-command and install the new howto-4-commands...hope this works...maybe you have any idea for http://www.howtoforge.com/forums/showpost.php?p=68052&postcount=7 ? :-)

[Hans]

I am sorry, but i've not an answer for that :(
But i would try to solve it with the command: aptitude -f --with-recommends dist-upgrade

After updating my test-server to Debian Etch, i just upgraded my two production servers from Debian Sarge to Etch as well.
ISPConfig is up and running.
No problems with the RAID1 configuration.
Reboot via SSH went ok!

After crossing my fingers again, i almost broke one! :D

Now i realise how stable Debian is!
Happy me.

(((:))))

[Spudchat]

Thanks hans for your tips!

I followed what you did, except that I used apt-get dist-upgrade instead of aptitude and selected "critical" when it asked about what kind of questions I wanted it to ask me during installation.

It basically asked me about all the things I installed during the Perfect setup of Sarge, and asked me if I wanted to change the config files or keep the ones I had allready. I selected change in most cases, but keep in a few, then went back and changed the files to reflect the way they were (e.g. commenting out some mime types again, adding those lines to my proftpd.conf etc). Then I rebooted the server and everything works just as expected!

Spudchat

[Hans]

I am happy to hear you did it!

[edge]

No problems with the RAID1 configuration.

Hello from Scotland.

Hans.. Are you using the same setup as me?
Dell Poweredge SC 1425 and a 3Ware RAID card (I think it's a 8006-2LP what I have in my servers, but I need to look at the info that I have at home (Holland) to make sure.)

If so, the RAID card is one less worry for me when doing the Etch update.

[Hans]

Hi Edge,

Yes we have the same Dell server, but there is one difference.
You have hardware RAID1 and i use Software RAID1, which has been configured by using the Debian Sarge CD in that time.

What i can say is this.
When you start with the upgrade to Etch, some questions will be asked.
I accepted all the defaults, but for MySQL i choose for old passwords.
Have also a look to the Postfix/Saslautd configuration.
And yes, first make a backup.

It is a good idea to have Falko's perfect setup for Etch on your screen as well. Probably, you need to install libmysqlclient15-dev for example or maybe some more.

To solve probable independencies, i advice to use the command:

If you have aptitude -f --with-recommends dist-upgrade

You also can use this after your dist-update with apt.

I wish you good luck an I hope that you are successful!

[edge]

Strange...

I just did an ISPconfig update on all my servers.
One of the servers that I updated showed Debian 4.0 when I did the ./setup to start installing ISPconfig.

The other servers showed Debian 3.1. (**edit. I typed 3.9)

All I did extra on that server before the ./setup was an apt-get update and apt-get upgrade.. It did find and installed a lot of (needed?) updates.
I did not touch the kernel! (the updates are also shown for the other servers)

Is Debian 4 the same as Etch, or is this only an update of Sarge? (I think the last)

[Hans]

Hi Edge,

I guess, you have "stable" within your /etc/apt/sources.list in stead of "sarge".

Because Debian 4.0, alias Etch is stable now, ISPConfig recognises your Linux version as Etch, but actually it is still Sarge, because you did not upgrade to Etch yet. Probably, if you had "sarge" within your /etc/apt/sources.list, ISPConfig should recognise your Linux version as Debian 3.1, which is Sarge.

[edge]

Hi Edge,

I guess, you have "stable" within your /etc/apt/sources.list in stead of "sarge".

Because Debian 4.0, alias Etch is stable now, ISPConfig recognises your Linux version as Etch, but actually it is still Sarge, because you did not upgrade to Etch yet. Probably, if you had "sarge" within your /etc/apt/sources.list, ISPConfig should recognise your Linux version as Debian 3.1, which is Sarge.

Hmm..
My sources.list (on ALL my servers look like this)

#deb file:///cdrom/ sarge main

deb http://ftp.debian.nl/debian/ stable main
deb-src http://ftp.debian.nl/debian/ stable main
deb http://security.debian.org/ stable/updates main


The only thing I did on the "4.0" version before the ISPconfig update was the apt-get update / upgrade.

Anyway.. I'll do the reall Etch move when I'm back home again next week.

[falko]

Is Debian 4 the same as Etch
Yes.

You have "stable" in /etc/apt/sources.list. Because Etch is the new stable branch since April 8, you have updated you system to Etch by running
apt-get update
apt-get upgrade

[edge]

Wow... So I updated one of my servers to Etch without even knowing it :-/ (I think I still need to update the kernel)

That was even easier than doing a Windows update!

[Hans]

Upgraded to Etch indeed, because of the /etc/apt/sources.list, but after that it is whise to check if there is a newer kernel available. If so, install it and after a reboot, you need the an apt-get dist-upgrade to upgrade to the packages which come with Debian Etch. Now some packages are kept back. But beware, first make a backup.

Just a small attention:
Have a look between small differences within the configuration.
For example have a look here: http://www.howtoforge.com/forums/showthread.php?t=10106&highlight=Etch+Sarge+saslauthd

And probably, you need to install libmysqlclient15-dev
But it must be said, everything is within Falko's great new howto, published here: http://www.howtoforge.com/perfect_setup_debian_etch

[edge]

Great!

Just a small attention:
Have a look between small differences within the configuration.
For example have a look here: http://www.howtoforge.com/forums/showthread.php?t=10106&highlight=Etch+Sarge+saslauthd

And probably, you need to install libmysqlclient15-dev
But it must be said, everything is within Falko's great new howto, published here: http://www.howtoforge.com/perfect_setup_debian_etch

Thank Hans,

I'm not having any of the problems as in the 1st link you posted, and as far as I can see, all is working fine (again. All I did was an apt-get update / upgrade from Debian 3.1)

Maybe I'm still on 3.1, but did ISPconfig "think" it was 4.0?
How can I see if I'm running 4.0?

[Tenaka]

ok guys, I think my upgrade went smooth, still I'd like to fix some things.

a) can someone mail me at ovizii at zice dot ro or post here a complete sources.list, maybe someone knows also the local debian servers for getting packages from Strato? (they have ther own mirrors so traffic is not counted)

b) I am unsure which php version I ended with. because of this:
php -v
PHP 4.4.4-8+etch1 (cli) (built: Mar 7 2007 23:55:48)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
and
dpkg -l | grep php5
ii libapache-mod-php5 5.2.0-8+etch1 server-side, HTML-embedded scripting languag
ii php5-common 5.2.0-8+etch1 Common files for packages built from the php
rc php5-imap 5.2.0-8+etch1 IMAP module for php5


why do I have php5 packages installed? shall I replace all those php5 packages with php4 versions? I'd like to always stick to stable so I am unsure about those php5 stuff

###edit###
I checked the etch howto from howtoforge, and have these questions:

apt-get install automake1.9 bison libdb4.3-dev -u
Reading package lists... Done
Building dependency tree... Done
Suggested packages:
automake1.9-doc bison-doc db4.3-doc
The following packages will be REMOVED:
apache2-prefork-dev libaprutil1-dev libdb4.4-dev
The following NEW packages will be installed:
automake1.9 bison libdb4.3-dev
0 upgraded, 3 newly installed, 3 to remove and 0 not upgraded.
Need to get 1311kB of archives.
After unpacking 1274kB of additional disk space will be used.
Do you want to continue [Y/n]?

why does it want to deinstall the apache2-prefork-dev package? I remember having needed it somewhere else it wouldn't be installed...

furthermore I just followed that etch tutorial from falko and I got to the point where one installs php5 - whats this? I am confused, I thought etch shipped with php 4.4.8???

[till]

why does it want to deinstall the apache2-prefork-dev package? I remember having needed it somewhere else it wouldn't be installed...

Etch comes with apache 2.2, so the new dev package might have another name. Most likely apache2.2-prefork-dev or similra, so you can install it again after you installed the above packages.

furthermore I just followed that etch tutorial from falko and I got to the point where one installs php5 - whats this? I am confused, I thought etch shipped with php 4.4.8???

Etch ships with php4 and php5, if you upgrade from sarge and had php4 installed, it will upgrade to php 4.4.8. Id all your scripts are working fine with php 4.4.8, I recommend to not upgrade to php5 as some CMS systems still have ptoblems with php5 and it might happen that some of your sites wont work properly after the upgrade to php5.

[Tenaka]

I did the apt-get isntall I quoted above. apache2-prefork-dev got removed. there is no other package for apache2.2 or likely. if I try to install it again it removes libdb4.3-dev again and installs libdb4.4-dev ... I remember that I needed this dev package for something contained called apxs or similar...

thx for the clarification about php4 and php5 included. I will stay with 4 as it is working flawless... I will just deinstall all php5 packages I find installed and install their php4 counterparts...

###edit###
this does not work. if I try apt-get remove --purge php5-common it wants to delete a lot of packages like this: php*-*** lots of * in tehre so I guess I could end up without some needed php4 packages... when I am at home later on I'll post the exact output here.

one more question: how is this parallel install achieved? how woudl clients choose which one to use and which one would be default?

And I still would like to see a default sources.list (maybe with the strato server addon)

[Hans]

@Edge,

You are running Etch already, because you have "stable" within your /etc/apt/sources.list list in stead of "sarge".
But as you can see if you perform an update, there are kept back packages.
You are only able to update the packages, which are provided by Etch, if you perform a dist-upgrade as describes here:
http://www.howtoforge.com/forums/showthread.php?t=11957&page=2

You have to realise that Etch comes with a lot of new packages, which are stable now.
So, by default, your server will be updated to php5, mysql5, and Apache2.2.3 for example.

[Ben]

@edge / @hans: So both of you upgraded a Sarge system with installed ISPConfig to etch wihtout negative influences to running services / ISPConfig?

[till]

Hi Ben, I updated two of my sarge installations too without problems. Here is a small howto for upgrading the perfect setup sarge to etch, maybe it helps you a bit:


Check /etc/apt/sources.list

Then:

apt-get update

apt-get -u dist-upgrade


Answer the following questions, they might differ a bit according to your setup.


Debconf configuration:

-> Dialog
-> medium

Do you want system wide readable home directories?

-> yes

Trust new CAs certificates?

-> yes

Major possible upgrade issues

-> Ok

Warning on syntax changes in ProFTPd configuration.

-> Ok

Configuring console-data

-> Don't touch keymap

New password for MySQL "root" user:

-> Do not enter any password

Support MySQL connections from hosts running Debian "sarge" or older?

-> Yes

Should man and mandb be installed 'setuid man'?

-> No

Disable challenge-response authentication?

-> No

Modified Authentication Infrastructure

Beginning with Courier 0.48, the authentication modules that used to be part of Courier have been separated into a standalone library. All Courier applications are now using the same authentication infrastructure, the Courier authentication library. Packages for this library consists of a base package (courier-authlib) and one for each authentication method (courier-authlib-userdb, -mysql, -postgresql, -ldap, -pipe). Unfortunately it wasn't possible to setup the dependencies in order to allow a seamless upgrade. Please install the package for your authentication method manually.



Do you want to upgrade glibc now? [Y/n]

-> Y

Do you wish to restart services? [Y/n]

-> Y


Configuration file `/etc/mysql/my.cnf'
==> Modified (by you or by a script) since installation.

-> y

Configuration file `/etc/mime.types'
==> Modified (by you or by a script) since installation.

-> y

Configuration file `/etc/apache2/apache2.conf'
==> Modified (by you or by a script) since installation.

-> n

A new version of configuration file /etc/php4/cli/php.ini is available, but your version has been locally modified.

-> keep your currently-installed version

A new version of configuration file /etc/php4/apache2/php.ini is available, but your version has been locally modified.

-> keep your currently-installed version

Configuration file `/etc/default/saslauthd'
==> Modified (by you or by a script) since installation.

-> y

Configuration file `/etc/init.d/saslauthd'
==> Modified (by you or by a script) since installation.

-> y

Configuration file `/etc/init.d/sysklogd'
==> Modified (by you or by a script) since installation.

-> y

A new version of configuration file /etc/proftpd/proftpd.conf is available, but your version has been locally modified.

-> keep your currently-installed version

Configuring webalizer

-> Ok

Enable DNSCache Option?

-> Yes


---------

Now we have to edit /etc/default/saslauthd in order to activate saslauthd. Set START to yes and change the line OPTIONS="-c" to OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r":

#
# Settings for saslauthd daemon
#

# Should saslauthd run automatically on startup? (default: no)
START=yes

# Which authentication mechanisms should saslauthd use? (default: pam)
#
# Available options in this Debian package:
# getpwent -- use the getpwent() library function
# kerberos5 -- use Kerberos 5
# pam -- use PAM
# rimap -- use a remote IMAP server
# shadow -- use the local shadow password file
# sasldb -- use the local sasldb database file
# ldap -- use LDAP (configuration is in /etc/saslauthd.conf)
#
# Only one option may be used at a time. See the saslauthd man page
# for more information.
#
# Example: MECHANISMS="pam"
MECHANISMS="pam"

# Additional options for this mechanism. (default: none)
# See the saslauthd man page for information about mech-specific options.
MECH_OPTIONS=""

# How many saslauthd processes should we run? (default: 5)
# A value of 0 will fork a new process for each connection.
THREADS=5

# Other options (default: -c)
# See the saslauthd man page for information about these options.
#
# Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
# Note: See /usr/share/doc/sasl2-bin/README.Debian
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r"


Now restart saslauthd

/etc/init.d/saslauthd restart


Disable PHP Globally

(If you do not plan to install ISPConfig on this server, please skip this section!)

In ISPConfig you will configure PHP on a per-website basis, i.e. you can specify which website can run PHP scripts and which one cannot. This can only work if PHP is disabled globally because otherwise all websites would be able to run PHP scripts, no matter what you specify in ISPConfig.

To disable PHP globally, we edit /etc/mime.types and comment out the application/x-httpd-php lines:

vi /etc/mime.types

[...]
#application/x-httpd-php phtml pht php
#application/x-httpd-php-source phps
#application/x-httpd-php3 php3
#application/x-httpd-php3-preprocessed php3p
#application/x-httpd-php4 php4
[...]

Then restart Apache

/etc/init.d/apache2 restart

ISPConfig expects the configuration to be in /etc/proftpd.conf instead of /etc/proftpd/proftpd.conf, therefore we create a symlink (you can skip this command if you don't want to install ISPConfig):

ln -s /etc/proftpd/proftpd.conf /etc/proftpd.conf

We need to modify /etc/default/syslogd so that we can still get important messages logged to the system logs. Modify the line: SYSLOGD="" so that it reads: SYSLOGD="-a /var/lib/named/dev/log":

vi /etc/default/syslogd

#
# Top configuration file for syslogd
#

#
# Full documentation of possible arguments are found in the manpage
# syslogd(8).
#

#
# For remote UDP logging use SYSLOGD="-r"
#
SYSLOGD="-a /var/lib/named/dev/log"

Restart the logging daemon:

/etc/init.d/sysklogd restart

[Hans]

@Ben,

I have upgraded succesfully indeed.
(1 testserver, 2 production-servers).

I also did also some small modifications, as described within Falko's perfect howto for Debian Etch.
i do recognise the chosen options, mentioned by Till. :)

[Ben]

Thx @Till @Hans for the info, I will upgrade then, soon ;)

[Tenaka]

I entered my old password here and chose NO at the second question. still everythign ran smooth.

New password for MySQL "root" user:

-> Do not enter any password

Support MySQL connections from hosts running Debian "sarge" or older?

-> Yes

[edge]

Ben,

I'm not so sure if I have Etch on my server!
ISPconfig did show Debian 4.0 when doing the upgrade, but all other "test" are showing me that I'm still on 3.1


php -v
PHP 4.3.10-19 (cli) (built: Mar 5 2007 20:46:29)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

The apt-get update, apt-get upgrade did not update the PHP to 4.4.8.

When I do an apt-get update and apt-get upgrade now I get this:

The following packages have been kept back:
adduser apache2 apache2-mpm-prefork apache2-utils apt apt-utils aptitude at
autoconf base-passwd bash bc bin86 bind9 bind9-host binutils bison
bsdmainutils bsdutils bzip2 console-common console-tools coreutils cpio cpp
cpp-3.3 cron curl dash dc debianutils dhcp-client discover1 dnsutils dpkg
dpkg-dev dselect e2fslibs e2fsprogs eject fdutils fetchmail file findutils
finger flex fontconfig ftp g++ g++-3.3 gcc gcc-3.3 gcc-3.3-base gdb
gettext-base gnupg grep groff-base grub gzip hostname ifupdown imagemagick
info initrd-tools initscripts ipopd iptables iputils-ping ispell klogd less
libacl1 libapache2-mod-perl2 libapache2-mod-php4 libasn1-6-heimdal libattr1
libblkid1 libbz2-1.0 libc-client2002edebian libc6 libc6-dev libcomerr2
libcompress-zlib-perl libconsole libcrypt-ssleay-perl libcurl3 libdb1-compat
libdb3 libdb3-dev libdb4.2 libdb4.3 libdbd-mysql-perl libdbi-perl
libdigest-sha1-perl libdiscover1 libexpat1 libfontconfig1 libfreetype6
libgcc1 libgcrypt11 libgd2-xpm libgdbm3 libglib2.0-0 libgpg-error0 libgpmg1
libhtml-parser-perl libice6 libidn11 libisccc0 libjpeg62 libkrb5-17-heimdal
libkrb53 liblcms1 libldap2 liblocale-gettext-perl liblockfile1 libltdl3
liblzo1 libmagic1 libmcal0 libmhash2 libncurses5 libncursesw5
libnet-dns-perl libnet-server-perl libnet-ssleay-perl libnss-db libopencdk8
libpam-modules libpam0g libpcre3 libperl5.8 libpng12-0 libpng12-dev
libpopt-dev libpopt0 libreadline5 librrds-perl libsasl2 libsasl2-modules
libsm6 libssl-dev libssl0.9.7 libstdc++5 libstdc++5-3.3-dev
libtext-charwidth-perl libtext-iconv-perl libtextwrap1 libtiff4 libusb-0.1-4
libuuid1 libwrap0 libx11-6 libxext6 libxi6 libxml2 libxmu6 libxmuu1 libxp6
libxpm4 libxrandr2 libxrender1 libxslt1.1 libxt6 libxtrap6 libxtst6
libzzip-0-12 locales login logrotate lsof lynx m4 mailagent make man-db mc
mlock module-init-tools modutils mount mpack mtools mtr-tiny munin
munin-node mutt mysql-server-4.1 nano ncftp ncurses-base ncurses-bin netbase
nget nmap ntp ntpdate nvi openssl passwd patch pciutils perl perl-base
perl-modules php4 php4-cli php4-common php4-curl php4-dev php4-domxml
php4-gd php4-imap php4-ldap php4-mcal php4-mhash php4-mysql php4-odbc
php4-pear php4-xslt postfix procmail procps proftpd psmisc python
python-gdbm python-newt quota quotatool rcs rdate rdiff-backup reportbug
rsync sasl2-bin screen sed spamassassin spamc ssh strace sysklogd sysvinit
tar tasksel tcpd tcsh telnet texinfo traceroute ucf unixodbc unzip usbutils
util-linux uw-imapd vnstat w3m webalizer wget whiptail whois xlibs-data zip
zlib1g zlib1g-dev
0 upgraded, 0 newly installed, 0 to remove and 268 not upgraded.

I'm in ther UK at the moment (to far from my servers to fix things if needed).
As soon as I'm back home, I'll have a go at the "real" update with "dist-upgrade" and some luck

[Tenaka]

I entered my old password here and chose NO at the second question. still everythign ran smooth.

New password for MySQL "root" user:

-> Do not enter any password

Support MySQL connections from hosts running Debian "sarge" or older?

-> Yes

Hey guys, I just felt the consequences of this decision. I can't login anymore into ispconfig. it gives me these errors:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60

How can I fix this? this is extremely urgent, I know its my fault, but please HELP :-)

[till]

Yes, thats the result of answering "Support MySQL connections from hosts running Debian "sarge" or older?" with no. But thats easy to solve.

Just run:

apt-get install libmysqlclient15-dev

Then download the latest ISPConfig version and run setup to update your installation. ISPConfig will recompile your PHP so that it supports your new database version.

[Tenaka]

THX :-)

I'll try that immediately. I installed the newest ispconfig before upgrading as I had read it fixed compatibility with etch. So this means that when I updated ispcfg, it installed with support for the sarge version as at that time I was running sarge...

actually it would have been better to upgrade ispcfg after upgrading to etch... maybe you could specify that in the changelog as it seemed logical to me to upgrade ispcfg first then sarge => etch, just a proposal anyway thx for helping.

[Tenaka]

I am almost there. Now when I try to logon I always get ERROR 101: Wrong username or password...

what could still be wrong???

Configuration file `/etc/mysql/my.cnf'
==> Modified (by you or by a script) since installation.

-> N

Here I chose NO, I wanted to keep my old optimized config file... the databases are runnign fine, its just that I can't login to ispcfg with any user

[falko]

I am almost there. Now when I try to logon I always get ERROR 101: Wrong username or password...

Can you check if the ISPConfig database is existing and what is in the sys_user table?

[Tenaka]

I exported all databases before these upgrades, but I did not have to import them as all sites are perfectly working after the upgrade, its just ispcfg not working, so somehow I doubt its the DB, but I'll check as soon as I am home...
In the worst case I would have to import the ISPCfg database later on... anyway I did not change anything so the backup should contain the latest data...

[till]

Please check that the mysql password in /home/admispconfig/ispconfig/lib/config.inc.php is correct.

[Tenaka]

the password for root is ok, still not arrived at home to check the content like falko advised...

found a pc and db_ispconfig is empty.
I will try and import now.

WORKS.

thx a lot

[Ben]

@till: What I forgot to ask, is there a problem if www-dir is still set to /home/www instead to the "new" /var/www (I just read anyhwere here that this has changed for new installs since one ispconfig version), when I want to upgrade?

[falko]

@till: What I forgot to ask, is there a problem if www-dir is still set to /home/www instead to the "new" /var/www (I just read anyhwere here that this has changed for new installs since one ispconfig version), when I want to upgrade?
No, that's no problem. After the upgrade, ISPConfig still uses the old values. :)

[Tenaka]

here is another link with some help for upgrading, I thought it might prove useful.

http://www.debian.org/releases/stable/i386/release-notes/ch-upgrading.en.html

it helped me :-) I first upgraded the kernel, followed by the rest of the system.

[edge]

Anyone here who migh know if it's possible to do the apt-get -u dist-upgrade, and keep the good old Apache 2.054 instead if the new 2.2.3 version?

I've got an application that (for now) does not work with the new 2.2.3 version :/

[falko]

Anyone here who migh know if it's possible to do the apt-get -u dist-upgrade, and keep the good old Apache 2.054 instead if the new 2.2.3 version?

I think you must use apt-pinning for this: http://www.howtoforge.com/forums/showpost.php?p=17170&postcount=15

[edge]

Thank you falko,

I'm at the moment getting really close of running the application with the new Apache (I've done about 10 test installs now on VMware)

Pinning will be an other option if needed for me.

[edge]

Okay. I'm about ready to do the apt-get -u dist-upgrade

One question.
At some stage (on my VMware test server) it's wants to configure the uw-imaps
I have 3 options. IMAP2, IMAP3 and IMAPS.
IMAP2 and IMAPS are selected.
Till now I've only used IMAPS (when selecting IMAP2 and IMAPS the system hangs till a ctrl & c is given)

I'm sure IMAPS is only needed, but I would love to know if this is correct.

After that it's asking for a "Enforce port selection" for the uw-imaps. Only option here is Yes or No.
Till now I've done a Yes, but again I'm not sure if this is correct.

The VMware image is a home made one from the perfect howto Debian Sarge

[falko]

Okay. I'm about ready to do the apt-get -u dist-upgrade

One question.
At some stage (on my VMware test server) it's wants to configure the uw-imaps
I have 3 options. IMAP2, IMAP3 and IMAPS.
IMAP2 and IMAPS are selected.
Till now I've only used IMAPS (when selecting IMAP2 and IMAPS the system hangs till a ctrl & c is given)

I'm sure IMAPS is only needed, but I would love to know if this is correct.

After that it's asking for a "Enforce port selection" for the uw-imaps. Only option here is Yes or No.
Till now I've done a Yes, but again I'm not sure if this is correct.

The VMware image is a home made one from the perfect howto Debian Sarge
Do you use uw-imap or Courier? If you use Courier, then you don't need uw-imap.
IMAP2 is the normal IMAP on port 143, IMAPS is encrypted IMAP on port 993. IF you haven't used IMAP2 till now, then you probably don't need it.

[edge]

I'm not sure what I'm using on the VMware install (it's only a test server, and not used for email stuff). As far as I remember it's a "copy" of the perfect howto for Debian Sarge.

Is there a way to see what I'm using (again. It's a VWware install on a local system here only used for testing things)

[edge]

Okay.

I've done the update on one of my real servers.

I got two more options that I was not sure of (I selected no)
Configuration file `/etc/crontab'
==> Modified (by you or by a script) since installation.
==> Package distributor has shipped an updated version.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** crontab (Y/I/N/O/D/Z) [default=N] ?
and
Configuration file `/etc/spamassassin/local.cf'
==> Modified (by you or by a script) since installation.
==> Package distributor has shipped an updated version.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** local.cf (Y/I/N/O/D/Z) [default=N] ?

Is this okay? All looks like it's workgin for me, but I need to do some more testing to make sure.

I've also got Coldfusion MX7 on this server, and it was a pain in the a$$ to get that up and runngin..

[edge]

Looking at "/etc/crontab.dpkg-dist", it's good I selected No (got some more custom stuff in my old crontab)
I do not think that the "/etc/spamassassin/local.cf" is used by ISPconfig.

[Tenaka]

just noticed a small glitch afetr the upgrade: I started getting foreach errors all over the place with different sites. her is an example:

Warning: Invalid argument supplied for foreach() in /var/www/web23/web/wp-content/plugins/redirection/redirection.php on line 297

googling brought me to a lot of unrelated stuff, at least nothing explainign a quick fix or explaining why this happens.

[falko]

I do not think that the "/etc/spamassassin/local.cf" is used by ISPconfig.
No, it's not used by ISPConfig. :)

[falko]

just noticed a small glitch afetr the upgrade: I started getting foreach errors all over the place with different sites. her is an example:

Warning: Invalid argument supplied for foreach() in /var/www/web23/web/wp-content/plugins/redirection/redirection.php on line 297

googling brought me to a lot of unrelated stuff, at least nothing explainign a quick fix or explaining why this happens.
Maybe your PHP scripts work only with PHP4, but not PHP5?

[edge]

Wow. The new Etch does work nice.
Today I've updated my last server to it.. Thank God again with no problems (-:

I do notice that the number of processes used with the new Etch have gone down about 1/2 on both my Debian servers :)

Server 2 (the one I updated 1st some days ago)
http://www.data-hosting.eu/vip/001055/data-processes-week-server2.gif

Server 1 (updated yesterday)
http://www.data-hosting.eu/vip/001055/data-processes-week-server1.gif

Anyone else noticing this also?

[Tenaka]

regarding those foreach problems: it seems like there were some changes involved from php4 to php5 regarding this function.

another thing: could anyone care to explain how I could use both php4 and php5 on my server, as someone said they both ship with Etch?

is it complicated? can it mess things up?

[falko]

another thing: could anyone care to explain how I could use both php4 and php5 on my server, as someone said they both ship with Etch?

This might give you the idea: http://www.howtoforge.com/apache2_with_php5_and_php4
http://www.howtoforge.com/apache2_suphp_php4_php5

[Tenaka]

do those howtos now also work with Apache/2.2.3 (Debian)? they state they only work before 2.2 !?

[falko]

I haven't tried yet.

[Ben]

I did the update as well, worked fine with nearly no problems (just vsftpd did not work temporarily, but http://www.howtoforge.com/forums/showthread.php?p=70878#post70878 did help)

[jsanglier]

First, thanks to all of you I have eventually upgraded my debian box to etch.

THis is a major achievement as I am a musician by trade and therefore thick as a plank! Also, what I don't know about linux could fill the British Library!

However, the next thing is the Kernel.

My system was built using the perfect setup serge, then upgraded to etch using Hans' stuff, and I have the latest ISPConfig version.

Running uname -r etc give me:

server1:~# uname -r
2.4.27-2-386
server1:~# apt-cache search kernel-image | grep 386
kernel-image-2.6-386 - Linux 2.6 image on 486-class - transition package
kernel-image-2.4.27-2-386 - Linux kernel image for version 2.4.27 on 386

Now, before I make a complete mess, destroy my emails and send myself into backruptcy, are there issues of leaping from 2.4.27-2-386 all the way to the 2.6 listed above?

Should I just leave it as it is or am I alright to proceed as with Hans' instructions and upgrade?

All the best


Joss

[falko]

An upgrade from kernel 2.4 to 2.6 is a rather big leap, and I wouldn't try it without a backup of your system (although it's perfectly possible that it work without glitches, but you never know).

[jsanglier]

Thanks Falko - I think I will go and think about it a bit! OR even, quite a lot!