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.


* Installing MANTIS

Obtain the latest stable version of Mantis from http://sourceforge.net/project/showfiles.php?group_id=14963&package_id=166159 Download the file mantis-1.0.6.tar.gz to a folder.

Unpack the gz file and place the contents in the default http documents folder in the root file system of the IFS:

/www/zendcore/htdocs/

and use either the default folder name mantis-1.0.6 or a more convenient name like mantis or bugtracker or issues. For this example we will use the folder mm.

Start the install process by using your browser to run the index.php in the root folder of the Mantis software:

http://your_system_ip_or_name:89/mm/index.php

Provide the userIDs and passwords you configured for MySQL in the previous steps:


* Using native i5 DB2/400

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

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