mantisbt:systemi
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mantisbt:systemi [2007/01/31 14:01] – slashsplat | mantisbt:systemi [2011/12/14 14:54] (current) – The page rendering was broken (maybe since new PHP version on mantisbt.org). Added new line to fix it at end of file. atrol | ||
---|---|---|---|
Line 3: | Line 3: | ||
Mantis support for IBM System i platform (AS/400, iSeries) and DB2. | Mantis support for IBM System i platform (AS/400, iSeries) and DB2. | ||
- | * [[MySQLi5|Installing MySQL on System i]] | + | ===== [[MySQLi5|Installing MySQL on System i]] ===== |
http:// | http:// | ||
Line 133: | Line 134: | ||
Save with F2 and exit with F3. | Save with F2 and exit with F3. | ||
+ | At this time, you should end and re-start PHP from the green screen menu at ZENDCORE/ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ---- | ||
+ | ---- | ||
+ | ---- | ||
---- | ---- | ||
- | * [[Mantisi5|Installing MANTIS]] | + | ===== [[Mantisi5|Installing MANTIS]] |
Obtain the latest stable version of Mantis from http:// | Obtain the latest stable version of Mantis from http:// | ||
- | Download the file mantis-1.0.6.tar.gz to a folder. | + | Download the file mantis-1.0.6.tar.gz to a PC folder. Since the file is " |
- | Unpack the gz file and place the contents in the default http documents folder in the root file system of the IFS: | + | Unzip gz file to a known folder on your PC. Use a real FTP program like WS-FTP or CuteFTP (free) to transfer the folder |
- | / | + | / |
- | and use either the default folder name '' | + | where xxx is either the default folder name '' |
Start the install process by using your browser to run the index.php in the root folder of the Mantis software: | Start the install process by using your browser to run the index.php in the root folder of the Mantis software: | ||
http:// | http:// | ||
- | Provide the userIDs and passwords you configured for MySQL in the previous steps: | + | Mantis will automatically detect that it is not yet installed, as this is the same file that is used to run the software also. |
+ | |||
+ | |||
+ | |||
+ | |||
+ | Once that is complete, you should modify the default configuration by editing the config_inc.php file in the main folder of your Mantis installation. | ||
+ | |||
+ | |||
+ | <?php | ||
+ | # leave these next three the same | ||
+ | $g_hostname = ' | ||
+ | $g_db_type = ' | ||
+ | $g_database_name = ' | ||
+ | # your database userid goes here | ||
+ | $g_db_username = ' | ||
+ | # your password goes here | ||
+ | $g_db_password = ' | ||
+ | # Used to link to manual for User Documentation. | ||
+ | # Updated URL for the Mantis online docs | ||
+ | $g_manual_url = ' | ||
+ | # String used to generate the confirm_hash for the 'lost password' | ||
+ | # ATTENTION: CHANGE IT TO WHATEVER VALUE YOU PREFER | ||
+ | $g_password_confirm_hash_magic_string = ' | ||
+ | # these next two require you to upload the file arial.ttf from your PC to a folder you create | ||
+ | # absolute path (with trailing slash!) to folder which contains your TrueType-Font files | ||
+ | # used to create the captcha image and since 0.19.3 for the Relationship Graphs | ||
+ | $g_system_font_folder = ' | ||
+ | # font name used to create the captcha image. i.e. arial.ttf | ||
+ | # (the font file has to exist in the system_font_folder) | ||
+ | $g_font_per_captcha = ' | ||
+ | # --- email variables ------------- | ||
+ | $g_administrator_email = ' | ||
+ | $g_webmaster_email = ' | ||
+ | # the 'From: ' field in emails | ||
+ | $g_from_email = ' | ||
+ | # the return address for bounced mail | ||
+ | $g_return_path_email = ' | ||
+ | # allow email notification | ||
+ | # note that if this is disabled, sign-up and password reset messages will | ||
+ | # not be sent. | ||
+ | $g_enable_email_notification = ON; | ||
+ | # --- sitewide variables ---------- | ||
+ | $g_window_title = ' | ||
+ | $g_page_title = ' | ||
+ | # FTP settings, used if $g_file_upload_method = FTP | ||
+ | # fill in your unique address or URL | ||
+ | $g_file_upload_ftp_server = ' | ||
+ | $g_file_upload_ftp_user = ' | ||
+ | $g_file_upload_ftp_pass = ' | ||
+ | # Files that are allowed or not allowed. | ||
+ | # eg. ' | ||
+ | # if $g_allowed_files is filled in NO other file types will be allowed. | ||
+ | # $g_disallowed_files takes precedence over $g_allowed_files | ||
+ | $g_allowed_files = ''; | ||
+ | $g_disallowed_files = ' | ||
+ | # --- cookie prefix --------------- | ||
+ | # set this to a unique identifier. | ||
+ | # should make this unique in case you have multiple implementations of Mantis from your same server | ||
+ | $g_cookie_prefix = ' | ||
+ | ?> | ||
Line 154: | Line 223: | ||
---- | ---- | ||
- | * [[DB2i5|Using native i5 DB2/400]] | + | ===== [[DB2i5|Using native i5 DB2/ |
+ | |||
+ | Issues of concern 2007-02-06 | ||
+ | |||
+ | ==== A. install.php user error ==== | ||
+ | |||
+ | === NOTE: / | ||
+ | |||
+ | / | ||
+ | |||
+ | db2 (experimental)\\ | ||
+ | ## system database name from DSPRDBDIRE AS/400 command " | ||
+ | S1071FDD\\ | ||
+ | PHP_IRA\\ | ||
+ | p0okmju7yg\\ | ||
+ | ## I tested with incrementing numbers for xxx, got up to 024, use a new one each time you run install.php\\ | ||
+ | MANTISxxx\\ | ||
+ | ## BOTH pw's are required, you cannot leave user blank\\ | ||
+ | PHP_IRA\\ | ||
+ | p0okmju7yg\\ | ||
+ | ## box below is unchecked\\ | ||
+ | [ ] Print SQL...\\ | ||
+ | ## then click\\ | ||
+ | [Install...]\\ | ||
+ | |||
+ | The LIBRARY *IS* being created with the database collection and journal, but the tables and indexes are not. The database is created by the admin but the tables are made by the user. The diff in the code for the two operations is: | ||
+ | |||
+ | FROM: / | ||
+ | TO CREATE DB which works | ||
+ | $g_db = ADONewConnection( $f_db_type ); | ||
+ | | ||
+ | |||
+ | The 9th green message at the top of the screen shows that the " | ||
+ | |||
+ | TO CREATE TABLES that does not | ||
+ | $g_db = ADONewConnection($f_db_type); | ||
+ | $t_result = @$g_db-> | ||
+ | |||
+ | The f_db_type is db2 for both. Then I tried using the SAME id and pw: | ||
+ | $t_result = @$g_db-> | ||
+ | |||
+ | And that does not work either. | ||
+ | $t_result = @$g_db-> | ||
+ | |||
+ | And that does not work either. | ||
+ | Database user doesn' | ||
+ | |||
+ | Makes no sense as the [] parms are correct. | ||
+ | |||
+ | |||
+ | ==== B. MD5 missing ==== | ||
+ | |||
+ | Enabled mcrypt/ | ||
+ | " | ||
+ | I had this with the MySQL install also! | ||
+ | |||
+ | |||
+ | ==== C. db2_tables error ==== | ||
+ | |||
+ | Install.php ERROR:\\ | ||
+ | SYSTEM WARNING: db2_tables() expects parameter 1 to be resource, boolean given | ||
+ | |||
+ | comes from FILE:\\ | ||
+ | / | ||
+ | |||
+ | function & | ||
+ | { | ||
+ | global $ADODB_FETCH_MODE; | ||
+ | $savem = $ADODB_FETCH_MODE; | ||
+ | $ADODB_FETCH_MODE = ADODB_FETCH_NUM; | ||
+ | $qid = db2_tables($this-> | ||
+ | |||
+ | I cannot figure this out and do not know if it affects issue A. | ||
+ | |||
+ | ==== D. Creating SQL database manually ==== | ||
+ | |||
+ | 1. Run the install.php to generate the SQL by checking the box. Copy and paste into a PC file editor. | ||
+ | |||
+ | 2. Removed formatting spaces to compact, as the SQL parser on the AS/400 has a length limit. | ||
+ | |||
+ | 3. Split any lines that exceeded 88. There are just a few. | ||
+ | |||
+ | 4. Add the required qualifier to tell DB2/400 WHERE to put the tables. | ||
+ | |||
+ | 5. Fix the error in the SQL generated: | ||
+ | |||
+ | |||
+ | 365 CREATE TABLE mantis011/ | ||
+ | ... | ||
+ | 371 date_created TIMESTAMP DEFAULT ' | ||
+ | 372 last_visit TIMESTAMP DEFAULT ' | ||
+ | ... | ||
+ | 380 | ||
+ | 381 ); | ||
+ | ERROR: | ||
+ | 395 INSERT INTO mantis_user_table(username, | ||
+ | ... | ||
+ | 399 ' | ||
+ | 400 ' | ||
+ | |||
+ | THIS:\\ | ||
+ | 399 ' | ||
+ | MUST BE:\\ | ||
+ | 399 ' | ||
+ | |||
+ | 6. Save the file as MANTISSQL on the PC | ||
+ | |||
+ | 7. Create a Source Physical File on the AS/400 | ||
+ | |||
+ | |||
+ | | ||
+ | Type choices, press Enter. | ||
+ | File . . . . . . . . . . . . . . > MANTISSQL | ||
+ | | ||
+ | Record length | ||
+ | Member, if desired . . . . . . . | ||
+ | Text ' | ||
+ | |||
+ | CRTSRCPF FILE(MANTIS011/ | ||
+ | |||
+ | 8. Add the working LIBRARY to your library list:\\ | ||
+ | addlible | ||
+ | |||
+ | 9. FTP the mantissql pc file tp MANTIS011/ | ||
+ | |||
+ | 230 ICHANDLER logged on. | ||
+ | ftp> cd mantis011 | ||
+ | 250 " | ||
+ | ftp> lcd md | ||
+ | Local directory now W: | ||
+ | ftp> pwd | ||
+ | 257 " | ||
+ | ftp> lcd | ||
+ | Local directory now W: | ||
+ | ftp> lcd md | ||
+ | Local directory now W: | ||
+ | ftp> put mantissql | ||
+ | 200 PORT subcommand request successful. | ||
+ | 150 Sending file to member MANTISSQL in file MANTISSQL in library MANTIS011. | ||
+ | 226 File transfer completed successfully. | ||
+ | ftp: 17753 bytes sent in 0.00Seconds 17753000.00Kbytes/ | ||
+ | |||
+ | 10. Once the file is in the source file on the AS/400, execute it by the Run SQL Statement command, shown prompted with F4: | ||
+ | |||
+ | Run SQL Statements (RUNSQLSTM) | ||
+ | Type choices, press Enter. | ||
+ | Source file . . . . . . . . . . > MANTISSQL | ||
+ | Library | ||
+ | Source member | ||
+ | Commitment control . . . . . . . > *ALL *CHG, *UR, | ||
+ | Naming . . . . . . . . . . . . . | ||
+ | And below in command line format: | ||
+ | RUNSQLSTM SRCFILE(MANTIS011/ | ||
- | http://wiki.splitbrain.org/ | + | 11. Congratulations. |
mantisbt/systemi.1170270111.txt.gz · Last modified: 2008/10/29 04:31 (external edit)