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/02/07 00:31]
slashsplat
mantisbt:systemi [2011/12/14 14:54] (current)
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 227: Line 227:
 Issues of concern 2007-02-06 Issues of concern 2007-02-06
  
-==== A. /www/zendcore/htdocs/md/admin/install.php ====+==== A. install.php user error ====
  
 === NOTE: /www/zendcore/htdocs/md/config_inc.php should NOT exist prior to running install.php. === === NOTE: /www/zendcore/htdocs/md/config_inc.php should NOT exist prior to running install.php. ===
  
-Install.php will not work.  When run with the following parms (fields only in order):+/www/zendcore/htdocs/md/admin/install.php will not work.  When run with the following parms (fields only in order):
  
 db2 (experimental)\\  db2 (experimental)\\ 
Line 273: Line 273:
    
  
-==== B. /www/zendcore/htdocs/md/admin/install.php ====+==== B. MD5 missing ====
  
 Enabled mcrypt/mhash in the PHP extensions, and bounced.  That did NOT eliminate the MD5 warning.   Enabled mcrypt/mhash in the PHP extensions, and bounced.  That did NOT eliminate the MD5 warning.  
Line 280: Line 280:
  
  
-==== C. /www/zendcore/htdocs/md/core/adodb/drivers/adodb-db2.inc.php  ==== +==== C. db2_tables error ==== 
-ERROR:\\ + 
 +Install.php ERROR:\\ 
 SYSTEM WARNING: db2_tables() expects parameter 1 to be resource, boolean given SYSTEM WARNING: db2_tables() expects parameter 1 to be resource, boolean given
    
 comes from FILE:\\  comes from FILE:\\ 
-./core/adodb/drivers/adodb-db2.inc.php and is complaining that the value of this->connection is null.+/www/zendcore/htdocs/md/core/adodb/drivers/adodb-db2.inc.php and is complaining that the value of this->connection is null.
  
   function &MetaTables($ttype=false)   function &MetaTables($ttype=false)
Line 296: Line 297:
 I cannot figure this out and do not know if it affects issue A. I cannot figure this out and do not know if it affects issue A.
  
-==== D. Creating SQL database from statements ==== +==== D. Creating SQL database manually ====
-In order to get the database built, I ran the install.php to generate the SQL and captured it.+
  
-Pasted into a PC file editor.+1. Run the install.php to generate the SQL by checking the box.  Copy and paste into a PC file editor.
  
-Changed:\\  +2. Removed formatting spaces to compact, as the SQL parser on the AS/400 has a length limit.  I try to keep the lines below 88 bytes.
-1. Removed formatting spaces to compact, as the SQL parser on the AS/400 has a length limit.  I try to keep the lines below 88 bytes.+
  
-2. Split any lines that exceeded 88.  There are just a few.+3. Split any lines that exceeded 88.  There are just a few.
  
-3. Fix the error in the SQL generated:+4. Add the required qualifier to tell DB2/400 WHERE to put the tables.  Prefix all table and index names with xxxx/ where xxxx is the library name that you designate in the "Database name" field in the install.php input screen.  "CREATE TABLE mantis_user_table" becomes "CREATE TABLE mantis011/mantis_user_table", for instance. 
 + 
 +5. Fix the error in the SQL generated:
  
  
Line 327: Line 328:
   399 '2007-02-06 09:10:36', '2007-02-06 09:10:36', 1, 0, 90, 3, 0, 0,   399 '2007-02-06 09:10:36', '2007-02-06 09:10:36', 1, 0, 90, 3, 0, 0,
  
-4. Save the file as MANTISSQL on the PC+6. Save the file as MANTISSQL on the PC
  
-5. Create a Source Physical File on the AS/400+7. Create a Source Physical File on the AS/400
  
  
Line 342: Line 343:
   CRTSRCPF FILE(MANTIS011/MANTISSQL) RCDLEN(300)TEXT('Mantis SQL installation script')   CRTSRCPF FILE(MANTIS011/MANTISSQL) RCDLEN(300)TEXT('Mantis SQL installation script')
  
-6. Add the working LIBRARY to your library list:\\ +8. Add the working LIBRARY to your library list:\\ 
   addlible  mantis011   addlible  mantis011
  
-7. FTP the mantissql pc file tp MANTIS011/mantissql  SRCPF+9. FTP the mantissql pc file tp MANTIS011/mantissql  SRCPF
  
   230 ICHANDLER logged on.   230 ICHANDLER logged on.
Line 364: Line 365:
   ftp: 17753 bytes sent in 0.00Seconds 17753000.00Kbytes/sec.   ftp: 17753 bytes sent in 0.00Seconds 17753000.00Kbytes/sec.
  
-8. Once the file is in the source file on the AS/400, execute it by the Run SQL Statement command, shown prompted with F4:+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)                          Run SQL Statements (RUNSQLSTM)
Line 378: Line 379:
   RUNSQLSTM SRCFILE(MANTIS011/MANTISSQL) SRCMBR(MANTISSQL) COMMIT(*ALL)   RUNSQLSTM SRCFILE(MANTIS011/MANTISSQL) SRCMBR(MANTISSQL) COMMIT(*ALL)
  
-9. Congratulations. +11. Congratulations.
- +
- +
- +
- +
- +
- +
- +
- +
- +
  
-http://wiki.splitbrain.org/wiki:syntax 
mantisbt/systemi.1170826314.txt.gz · Last modified: 2008/10/29 04:31 (external edit)