This is an old revision of the document!
System i Support
Mantis support for IBM System i platform (AS/400, iSeries) and DB2.
* Installing MySQL on System i
http://dev.mysql.com/downloads/mysql/5.0.html#downloads
(as of 2007-01-30)
IBM AIX downloads AIX 5.2 (POWER, 64-bit) Standard 5.0.27 28.1M Max 5.0.27 28.1M
Download filename: mysql-max-5.0.27-aix5.2-powerpc-64bit.tar.gz
W:\LIVE\mantis-sql>dir Directory of W:\LIVE\mantis-sql 10/20/2006 21:24 80,732,160 mysql-max-5.0.27-aix5.2-powerpc-64bit.tar W:\LIVE\mantis-sql>ftp -i as400 Connected to AS400. 220-QTCP at 192.168.0.222. 220 Connection will close if idle more than 5 minutes. User (RUBY:(none)): yourUserId 331 Enter password. Password: ********** 230 YOURUSERID logged on. ftp> cd /usr/local 550-NAMEFMT set to 1. 250 "/usr/local" is current directory. ftp> ls 200 PORT subcommand request successful. 125 List started. Zend/ 250 List completed. ftp: 7 bytes received in 0.00Seconds 7000.00Kbytes/sec. ftp> bin 200 Representation type is binary IMAGE. ftp> put *.tar 200 PORT subcommand request successful. 150 Sending file to /usr/local/mysql-max-5.0.27-aix5.2-powerpc-64bit.tar ftp: 80732160 bytes sent in 11.36Seconds 7107.33Kbytes/sec. ftp>quit
On the AS/400 command line, as QSECOFR, issue the following commands (responses not shown):
call qp2term cd /usr/local tar -xvf mysql-max-5.0.27-aix5.2-powerpc-64bit.tar ln -s mysql-max-5.0.27-aix5.2-powerpc-64bit mysql cd /usr/local/mysql scripts/mysql_install_db
Start MySQL
> cd . ; ./bin/mysqld_safe & [1] 128192 # Starting mysqld daemon with databases from /usr/local/mysql/data
Continue with Unix Post Install docs at http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
First, set default priviledges: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
> ./bin/mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.27-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> > SET PASSWORD FOR ''@'localhost' = PASSWORD('secret'); Query OK, 0 rows affected (0.00 sec) mysql> > SELECT Host, User FROM mysql.user; +-------------------+------+ | Host | User | +-------------------+------+ | AS400 | | | AS400 | root | | localhost | | | localhost | root | +-------------------+------+ 4 rows in set (0.01 sec) mysql> > SET PASSWORD FOR ''@'AS400' = PASSWORD('secret'); Query OK, 0 rows affected (0.06 sec) mysql> > UPDATE mysql.user SET Password = PASSWORD('secret') -> WHERE User = ''; Query OK, 0 rows affected (0.07 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql> > UPDATE mysql.user SET Password = PASSWORD('secret') WHERE User = 'root'; Query OK, 2 rows affected (0.01 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> > FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql>
Optionally remove anonymous access:
mysql> DELETE FROM mysql.user WHERE User = ''; mysql> FLUSH PRIVILEGES;
Validate with:
> ./bin/mysqladmin version -psecret ./bin/mysqladmin Ver 8.41 Distrib 5.0.27, for ibm-aix5.2.0.0 on powerpc Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.27-max Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 37 min 56 sec Threads: 1 Questions: 15 Slow queries: 0 Opens: 12 Flush tables: 2 Open tables: 0 Queries per second avg: 0.007 #
Now edit ZendCore to tell it to use MySQL. We will do this manually by editing the php.ini file. Go to an AS/400 command line and issue the command:
wrklnk '/usr/local/Zend/core/etc'
Place a 5 in the option column at ETC and Press Enter.
Place a 2 in the option column at PHP.INI and Press Enter.
Use the search command:
f =mysql
to find the lines:
;extension=mysql.so ;extension=mysqli.so
It is possible that they are already un-commented (without a leading semicolon). If not, remove the leading semicolon resulting in:
extension=mysql.so extension=mysqli.so
Save with F2 and exit with F3.