User Tools

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

Site Tools


mantisbt:systemi

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mantisbt:systemi [2007/01/31 14:01]
slashsplat
mantisbt:systemi [2011/12/14 14:54]
atrol The page rendering was broken (maybe since new PHP version on mantisbt.org). Added new line to fix it at end of file.
Line 1: Line 1:
-====== System i Support ====== 
- 
-Mantis support for IBM System i platform (AS/400, iSeries) and DB2. 
- 
-* [[MySQLi5|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. 
- 
----- 
-* [[Mantisi5|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: 
- 
- 
- 
- 
- 
- 
----- 
-* [[DB2i5|Using native i5 DB2/400]] 
- 
- 
- 
-http://wiki.splitbrain.org/wiki:syntax 
  
mantisbt/systemi.txt ยท Last modified: 2011/12/14 14:54 by atrol