Archlinux & Ispconfig

[misterm]

Hello with all

I am spirit to function ISPConfig under the archlinux, is all function, finally almost, with some modifications, on the file dist.txt, setup1 is setup2...

I have a problem with the server mysql, at the time of the checking of setup2, it says to me that the server after restarting, functions more....

Then, I will show you the compilation of mysql, is with you to say itself, if this one is correct:

./configure --prefix=/usr --libexecdir=/usr/sbin \
--without-debug --without-docs --without-bench --without-readline \
--with-innodb --enable-local-infile --with-openssl \
--with-charset=latin1 --with-collation=latin1_general_ci \
--with-extra-charsets=complex --enable-thread-safe-client \
--with-libwrap --with-berkeley-db

5.0.26 Version

Help me so, very important for the community which I represent...

Yours sincerely

MM ;)

[falko]

I have a problem with the server mysql, at the time of the checking of setup2, it says to me that the server after restarting, functions more....

What's the exact error message?

[misterm]

Hello falko

I am to afflict to expose the code of the setup2, but it there with a problem like same, when the setup2, makes a checking of the waiter mysql, it says that, it is not to start, but when I go a PS to | the grep mysql, mysql functions....

if [ -f /etc/my.cnf ]; then
mv -f /etc/my.cnf /etc/my.cnf_orig
grep -wv "skip-networking" /etc/my.cnf_orig > /etc/my.cnf
/etc/init.d/mysql restart &> /dev/null
/etc/init.d/mysqld restart &> /dev/null
fi
if [ -f /etc/mysql/my.cnf ]; then
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf_orig
grep -wv "skip-networking" /etc/mysql/my.cnf_orig > /etc/mysql/my.cnf
/etc/init.d/mysql restart &> /dev/null
/etc/init.d/mysqld restart &> /dev/null
fi
netstat -ta | grep -i mysql > /dev/null
if [ $? != 0 ]; then
error "$q_mysql_running_check";
else
if [ ! -S /var/lib/mysql/mysql.sock ] && [ ! -h /var/lib/mysql/mysql.sock ] && [ -S /tmp/mysql.sock ]; then
if [ ! -d /var/lib/mysql ]; then
mkdir -p /var/lib/mysql
caselog "directory /var/lib/mysql created" "directory /var/lib/mysql could not be created!"
fi
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
caselog "symbolic link from /var/lib/mysql/mysql.sock to /tmp/mysql.sock created" "symbolic link from /var/lib/mysql/mysql.sock to /tmp/mysql.sock could not be created!"
fi
if [ ! -S /var/lib/mysql/mysql.sock ] && [ ! -h /var/lib/mysql/mysql.sock ] && [ -S /var/run/mysqld/mysqld.sock ]; then
if [ ! -d /var/lib/mysql ]; then
mkdir -p /var/lib/mysql
caselog "directory /var/lib/mysql created" "directory /var/lib/mysql could not be created!"
fi
ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock
caselog "symbolic link from /var/lib/mysql/mysql.sock to /var/run/mysqld/mysqld.sock created" "symbolic link from /var/lib/mysql/mysql.sock to /var/run/mysqld/mysqld.sock could not be created!"
fi
if [ ! -S /var/lib/mysql/mysql.sock ] && [ ! -h /var/lib/mysql/mysql.sock ] && [ -S /var/run/mysql/mysql.sock ]; then
if [ ! -d /var/lib/mysql ]; then
mkdir -p /var/lib/mysql
caselog "directory /var/lib/mysql created" "directory /var/lib/mysql could not be created!"
fi
ln -s /var/run/mysql/mysql.sock /var/lib/mysql/mysql.sock
caselog "symbolic link from /var/lib/mysql/mysql.sock to /var/run/mysql/mysql.sock created" "symbolic link from /var/lib/mysql/mysql.sock to /var/run/mysql/mysql.sock could not be created!"
fi
if [ ! -S /var/lib/mysql/mysql.sock ] && [ ! -h /var/lib/mysql/mysql.sock ] && [ ! -S /tmp/mysql.sock ] && [ ! -h /tmp/mysql.sock ] && [ ! -S /var/run/mysqld/mysqld.sock ] && [ ! -h /var/run/mysqld/mysqld.sock ] && [ ! -S /var/run/mysql/mysql.sock ] && [ ! -h /var/run/mysql/mysql.sock ]; then
error "$q_mysql_sock_check";
fi
fi

MM;)

[falko]

What's the output of netstat -tap, and where is mysql.sock (might also be mysqld.sock) located in ArchLinux?

[misterm]

Hello falko

I have your configuration, during the installation of ispconfig, but, I would like that you looks with your code that I put above, with causse of your code, I would not have yourself never to install ispconfig without other possible problems.....

tcp 0 0 *:3306 *:* LISTEN 2258/mysqld


MM:mad:

[falko]

Where's the MySQL socket located?

[misterm]

Hello falko

You fall well...

I have just made a simulation of a update of ispconfig, is by misfortune, the update it is planted....

./setup
Archlinux 0.7.2
Upgrade einer existierenden ISPConfig-Installation. / Upgrading an existing ISPConfig installation. / Mise �jour d'une installation d'ISPConfig existante.

Das Upgrade wird von Ihnen ge�derte Templates/Dateien von ISPConfig berspielen. Wenn Sie diese Dateien sichern m�hten, sollten Sie jetzt eine zweite Shell �fnen, um ein Backup der betroffenen Dateien durchzufhren.
The upgrade will overwrite your manual changes to files/templates of ISPConfig. In order to save those files you should open a second shell to make a backup of the affected files.
En uppgradering kommer att skriva �er manuella �dringar gjorda p�filer/mallar i ISPConfig.F� att spara dessa �dringar b� du �pna ett andra skal f�ster f� att g�a en backup p�ber�da filer.
Cette mise �jour va supprimer vos changements dans les fichiers des manuels/modeles d'ISPConfig. Pour sauvegarder ces fichiers vous devez ouvrir une seconde fen�re shell et enregistrer les fichiers concern�.
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd stopped
ISPConfig system stopped!
W�len Sie Ihre Sprache (deutsch/englisch/spanisch/franz�isch/italienisch/niederl�disch/polnisch/schwedisch): / Please choose your language (German/English/Spanish/French/Italian/Dutch/Polish/Swedish): / Merci de choisir votre langue (Allemand/Anglais/Espagnol/Fran�is/Italien/N�rlandais/Polonais/Su�ois):
1) de
2) en
3) es
4) fr
5) it
6) nl
7) pl
8) se
Ihre Wahl: / Your Choice: / Votre Choix:4

Merci de lire la license avec attention:

Copyright (c) 2005, projektfarm GmbH, Till Brehm, Falko Timme
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

* Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above copyright notice,
this list of conditions and the following disclaimer in the documentation
and/or other materials provided with the distribution.
* Neither the name of ISPConfig nor the names of its contributors
may be used to endorse or promote products derived from this software without
specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Acceptez vous la license ? [Oui=y/Non=n]y

Verification de la syntaxe de httpd.conf...
Syntax OK
La syntaxe est ok!

########## gcc ##########

/usr/bin/gcc
OK

########## make ##########

/usr/bin/make
OK

########## lex ##########

/usr/bin/lex
OK

########## INSTALLATION ##########

ERROR: MySQL ne fonctionne pas ! Merci de demarrer MySQL et de relancer l'installation d'ISPConfig.


I have make the command, ps aux | grep mysql, is it says to me:

[root@mich install_ispconfig]# ps aux | grep mysql
root 21409 0.0 0.4 2576 1216 pts/1 S 13:27 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 21434 0.0 2.9 127668 7672 pts/1 Sl 13:27 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mich.no-ip.biz.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
root 23136 0.0 0.2 1728 580 pts/2 R+ 14:35 0:00 grep mysql


Is the command following:

[root@mich install_ispconfig]# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:3306 *:* LISTEN 21434/mysqld


You have all information to say what to me this master key....

Well with you

MM;)

[falko]

What's the output of ls -l /tmp/mysql.sock?

[misterm]

Hello falko

I have your command....

[root@mich ~]# ls -l /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Dec 13 10:05 /tmp/mysql.sock

Well with you

MM;)

[falko]

Then ISPConfig should have no problems with MySQL. Sorry, that's the only help I can give, I don't have an Archlinux system here.

[misterm]

OK falko

But, I has you on without this problem with the installation, mysql, is ispconfig, functions with wonder, I has you on, I will try to look at, with this now...

But like same thank you of assistance, falko

MM;)

[misterm]

Falko, I have to find....

I go mêttre a howto on my site perso, for the installation of ISPConfig on the archlinux....

http://www.michelrenard.be/fr/installation-de-ispconfig-sur-larchlinux.html

It's a pity that I is not a server of test....

As that you know it, but I will add you a small thing on this order :

netstat -ta

tcp 0 0 *:3306 *:* LISTEN


You see that your order initial, "netstat -ta | grep -i mysqld" does not function or does not find the server mysql..

MM;)

[misterm]

Hello falko

Soon you will be able to add to it archlinux in your list of distribution, that ISPConfig, can function, version archlinux 0.7.2...

To add distributtion in dist.txt

dist_init_scripts=/etc/rc.d ## # ArchLinux072
dist_runlevel= ## # ArchLinux072
dist_smrsh= ## # ArchLinux072
dist_shells=/etc/shells ## # ArchLinux072
dist_http_user=nobody ## # ArchLinux072
dist_http_group=nobody ## # ArchLinux072
dist_bind_init_script=named ## # ArchLinux072
dist_bind_user=named ## # ArchLinux072
dist_bind_group=named ## # ArchLinux072
dist_bind_conf=/etc/named.conf ## # ArchLinux072
dist_bind_dir=/var/named/ ## # ArchLinux072
dist_bind_pidfile=/var/named/named.pid ## # ArchLinux072
dist_bind_hintfile=named.ca ## # ArchLinux072
dist_bind_localfile=named.local ## # ArchLinux072
dist_passwd=/etc/passwd ## # ArchLinux072
dist_shadow=/etc/shadow ## # ArchLinux072
dist_group=/etc/group ## # ArchLinux072
dist_cron_daemon=crond ## # ArchLinux072
dist_cron_tab=/var/spool/cron/root ## # ArchLinux072
dist_mysql_group=mysql ## # ArchLinux072
dist_httpd_daemon=httpd ## # ArchLinux072

Modification to be added in the files setup1 is setup2

if [ -f /etc/arch-release ] && [ ! -h /etc/arch-release ]; then
version=`cat /etc/arch-release | cut -f3 -d' '`
echo $version | grep \\. &> /dev/null
if [ $? != 0 ]; then
version=`echo $version.0`
fi
distversion=`echo Archlinux $version`
echo $distversion
distvers=Archlinux${version//./}
echo dist=$distvers '##' > dist.info.tmp
grep -i $distvers dist.txt >> dist.info.tmp
cp -f dist.info.tmp dist.info
VAR1=`cat dist.info.tmp | cut -f1 -d=`
for var1 in $VAR1
do
echo export $var1 >> dist.info.ende
done
cat dist.info.ende >> dist.info.tmp
rm -f dist.info.ende
fi

echo "########## INSTALLATION ##########"
echo
if [ -f /etc/my.cnf ]; then
mv -f /etc/my.cnf /etc/my.cnf_orig
grep -wv "skip-networking" /etc/my.cnf_orig > /etc/my.cnf
/etc/init.d/mysql restart &> /dev/null
/etc/init.d/mysqld restart &> /dev/null
/etc/rc.d/mysqld restart &> /dev/null
fi
if [ -f /etc/mysql/my.cnf ]; then
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf_orig
grep -wv "skip-networking" /etc/mysql/my.cnf_orig > /etc/mysql/my.cnf
/etc/init.d/mysql restart &> /dev/null
/etc/init.d/mysqld restart &> /dev/null
/etc/rc.d/mysqld restart &> /dev/null
fi
netstat -tap | grep -i mysql > /dev/null
if [ $? != 0 ]; then
error "$q_mysql_running_check";
else


Thank you for your confidence

With soon

MM;)

[misterm]

Hello falko Can you to look in your file "install.php" of ispconfig if you can look at the error right below, is that you says to me, what I must modify in my parameters, on the archlinux..

cp: missing destination file operand after `.orig'
Try `cp --help' for more information.

Warning: fclose(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 97

Warning: fwrite(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 1033

Warning: fwrite(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 1035

Warning: fclose(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 1036

Warning: fwrite(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 111

Warning: fclose(): supplied argument is not a valid stream resource in /root/install_ispconfig/install.php on line 112
Connected successfully to MySQL server
Redemarrage des services...
:: Stopping Postfix [DONE]
:: Starting Postfix [DONE]
:: Stopping Postfix [DONE]
:: Starting Postfix [DONE]
./setup2: line 1117: [: ==: unary operator expected

Thank you

MM