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)