User Tools

  • Logged in as: anonymous (anonymous)
  • Log Out

Site Tools


mantisbt:systemi

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.

* Using native i5 DB2/400

http://wiki.splitbrain.org/wiki:syntax

mantisbt/systemi.1170224809.txt.gz · Last modified: 2008/10/29 04:32 (external edit)