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 00:59]
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 
- 
-Continue with Unix Post Install docs at  
-http://​dev.mysql.com/​doc/​refman/​5.0/​en/​unix-post-installation.html ​   ​ 
- 
-Start MySQL 
-  > cd . ; ./​bin/​mysqld_safe &                                        ​ 
-    [1]     ​128192 ​                                                   ​ 
-    # Starting mysqld daemon with databases from /​usr/​local/​mysql/​data 
- 
-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; 
- 
- 
- 
- 
- 
- 
-* [[DB2i5|Using native i5 DB2/400]] 
- 
- 
- 
-http://​wiki.splitbrain.org/​wiki:​syntax 
  
mantisbt/systemi.txt ยท Last modified: 2011/12/14 14:54 by atrol