Her is the output:
[netadmin@linux3 ~]$ telnet localhost 3306
Trying 127.0.0.1…
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
4
5.0.22%YqLiIs&,`5%Vf{X(\xg|
As you can see we´re both running the same version of mysql...

Sorry that I´ve puzzled you. I currently trying to install i-doit on two different Linux flavours: CentOS 5, the one which is most of the thread about and Trustix 2.2, the one with the 'mysql xml standard pcre session' was not installed' error. Trustix is actually the system of our production servers. But while support seems to go down for this great system we are looking for another distro. Centos 5 is now the first test environment and I thought it is a good idea to also implement one or two of this "ever wanted but never had the time to get one" services like an it inventory. There is one included with our Zabbix network monitoring system but it´s much too basic to meet our requirements.
So while I know my ways around with Trustix I´ve tried to install i-doit on such a system but the setup doesn´t start and just the above error pops up. I´ve tried to find the module but hadn´t any success. If you could point me to the right direction I would be very happy.

Sorry, here comes the .ini file

php.txt

Did the entry, restarted apache, same result. The php installation is the distribution based one, which is similar to the RedHat EL 5 installation. I have added my php.ini file. This is the resulting page of info.php:
'./configure' '–build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter'
The infos of the module mysql:
Active Persistent Links 1
Active Links 1
Client API version 5.0.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
And the infos of the module mysqli
Client API library version 5.0.22
Client API header version 5.0.22
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect

And finally the output of the package management system:
php-mysql.i386                          5.1.6-15.el5          installed

So maybe you can see some problems.

Greetings,

Mike

Just a small update: I did a eGroupware installation on the same Centos box which works without any problems. The installation and setup procedure is pretty close to i-doit. The eGroupware didn´t have any problems creating it´s mysql databases, tables and database users at the localhost and port 3306. So the problem is really somewhere inside the i-doit application. Maybe some kind of encryption? The root user password is a combination of the letters a, g and m, so there shouldn´t be any problems with the encoding.

Regards,

Mike

Hi, back from a long weekend. Ok, the password is much too simple to cause any problems, it´s not even a password anybody would use in the wild. So what I´ve tried now is to set up the i-doit system on a Trustix box. Here I get the following message when I try to login to do the i-doit setup:
Not all needed extensions are installed.
I need: mysql xml standard pcre session
I have: xml standard pcre session
Looks like some php related stuff. If you may give me a hint I will try to setup i-doit. While I´m not very familiar it would be nice if you give me some more detailed instructions, where to find the extension or where to but it.
Thanks,

Mike

Hm, there is no table user in the idoit_sys database. But I guess you are meaning the mysql database. Here is the output of the command:
| %                        | idiot | 5203a74776cb92fd |
| localhost                | idiot | 5203a74776cb92fd |
| idiot                    | idiot | 5203a74776cb92fd |
I have absolutly no idea where the idiot comes from, the name of the box is linux3, it is configured in /etc/hosts and the local nameserver.  No idiot host in both…
I´ve now dropped all tables, deleted all i-doit users from the mysql database and started the auto setup all over again: No tables were created, no users where created.

Since your mandator's name seems to be in german, erm, you could also use our german side of the forum

Yes, you are right, even if my real first name is Mike. Just jumped into the forum from the start page and jumped into the first matching category without any closer looks…

Hi,
I´ve made three screenshots. First is from system check, second is the error itself, third is a database login from the command line.
The system can´t be accessed from the internet, but I will follow any directions you may guide me.

Hi,
I´m trying to do a clean install of i-doit on an up to date Centos 5 Linux box. I´m actually using revision 2844. I´m trying to do the setup via the web interface but it always ends with an error 13 in the database field, a failed for the database root password (which is correct) and two no link errors for the databases. While this is a fresh installation of the system i´ve installed phpMyAdmin to check the amp setup, it works without any problems. I´ve checked password and usernames at the cli, no problems here. I´m a bit puzzled what might be wrong with my setup so any help is welcome.

Regards,
Mike