DokuWiki Installer

:

This page assists in the first time installation and configuration of Dokuwiki. More info on this installer is available on it's own documentation page.

DokuWiki uses ordinary files for the storage of wiki pages and other information associated with those pages (e.g. images, search indexes, old revisions, etc). In order to operate successfully DokuWiki must have write access to the directories that hold those files. This installer is not capable of setting up directory permissions. That normally needs to be done directly on a command shell or if you are using hosting, through FTP or your hosting control panel (e.g. cPanel).

This installer will setup your DokuWiki configuration for ACL, which in turn allows administrator login and access to DokuWiki's admin menu for installing plugins, managing users, managing access to wiki pages and alteration of configuration settings. It isn't required for DokuWiki to operate, however it will make Dokuwiki easier to administer.

Experienced users or users with special setup requirements should use these links for details concerning installation instructions and configuration settings.

For security reasons this script will only work with a new and unmodified Dokuwiki installation. You should either re-extract the files from the downloaded package or consult the complete Dokuwiki installation instructions

driven by DokuWiki powered by PHP
System i Support [Mantis Bug Tracker Wiki]

User Tools

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

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;

* Using native i5 DB2/400

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

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