SuperLuminate Install Notes: (c)Copyright 2003-2012 SuperLuminate, All Rights Reserved updated 17-Feb-2012 (pjn) ver 1_9_0_120 ------------------------------------------------------------------------------- NOTE: It is better to edit files using a text editor that is intended for programming (we prefer UltraEdit-32). Your text editor should be designed to edit text files. Editors for Rich Format Text files tend add unprintable formatting characters that can create issues. In a pinch use Microsoft Notepad. To see the SuperLuminate files with the intended format set the tabs to 4 spaces in your editor. ------------------------------------------------------------------------------- If you are already a SuperLuminate user and just want to upgrade to the next version go to the end of this document. Chapter (UPGRADING FROM PREVIOUS VERSION) ------------------------------------------------------------------------------- Determine the IP Address of the server for the SuperLuminate install: To display the IP Address of your server: On server Desktop press [start] button Select option [Run...] Where it says Open: Type "cmd" without quotes, then press [OK] button Now after the > symbol type "ipconfig" without quotes and press [Enter] This action will display the IP Address --> 192.168.1.190 (Example) You can enter this address when asked for the network domain or server name during software installs Note down the server IP Address and close the window After Apache is installed, to access your web server home page, type the IP Address of your server into the browser address line (example) http://192.168.1.190/ (use your IP Address) After SuperLuminate is installed, to access the SuperLuminate home page: http://192.168.1.190/sl/ (use your IP Address) To access the SuperLuminate Lite (Glossary) home page after install: http://192.168.1.190/sl/sl_main.php?Glossary (use your IP Address) ------------------------------------------------------------------------------- NOTE: As you go through the install process you will be asked to decide where to place software on your machine. We suggest you override the default locations and use the suggestions we provide. This will ease your maintenance because in many cases programs do not act well with spaces in the directory path names. These changes to default directory paths are described in the install process but are also listed below for your convenience. Directory paths are shortened and directory path names are lowercased. Default directory assignment: C:\Program Files\Apache Software Foundation\Apache2.2\ Suggested new directory assignment: C:\apache\ Default directory assignment: C:\Program Files\Apache Software Foundation\PHP Suggested new directory assignment: C:\apache\php Default directory assignment: C:\Program Files\MySQL\MySQL Server 5.0\ Suggested new directory assignment: C:\mysql\ ------------------------------------------------------------------------------- NOTE: All software is available on the SuperLuminate download site but can also be retrieved directly from the source sites: http://www.apache.org/ http://www.mysql.com/ http://www.php.net/ ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Download and unzip SuperLuminate files: Create a folder on your desktop "SuperLuminate Downloads" Download all software and documents: 1) SL_Install_Guide_1_9_0_120.txt 2) sl_1_9_0_120.zip 3) SL_User_Guide_1_9_0_120.zip 4) Apache 2.2.8 Win 5) PHP 5.2.6 Win 6) MySQL 5.0.51b Win 7) instantclient_11_1.zip 8) php_oci8.zip 9) underground-php-oracle-manual.zip Unzip all Zipped files: 1) instantclient_11_1.zip 2) MySQL 5.0.51b Win 3) PHP 5.2.6 Win 4) php_oci8.zip 5) sl_1_9_0_120.zip 6) SL_User_Guide_1_9_0_120.zip 7) underground-php-oracle-manual.zip ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Apache Installation: NOTE: After Apache is installed, Apache will run as a service. Apache will automatically startup when the server boots. Apache will continue to run even if you should logoff the server. File: apache_2.2.8-win32-x86-no_ssl.msi Launch Apache Installer: double click on apache_2.2.8-win32-x86-no_ssl.msi Open File Security Warning window: press [Run] button Install Wizard window: press [Next >] button License Agreement window: press [I accept] radio button then press [Next >] button Read This First window: press [Next >] button Server Information window: Network Domain --> 192.168.1.190 (use your IP Address) Server Name --> 192.168.1.190 (use your IP Address) Admin email address --> patrick@superluminate.com (your email) keep radio button [All users on port 80] selected press [Next >] button Setup Type window: keep radio button [Typical] selected press [Next >] button Destination Folder window: change default destination press [Change...] button from --> C:\Program Files\Apache Software Foundation\Apache2.2\ to: ---> C:\apache\ press [OK] button Destination Folder window: keep new destination --> C:\apache\ press [Next >] button Ready to Install the Program window: press [Install] button takes about a minute to install Installation Wizard Completed window: press [Finish] button To test your Apache web server installation, type the IP Address of your server into the browser address line (example) http://192.168.1.190/ (use your IP Address and press [enter]) you should now see "It works!" if the install was successful ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Apache Configuration: httpd.conf configuration file: open folder C:\apache\conf in conf folder create a backup copy of file httpd.conf rename the backup copy to httpd.conf-dist for distribution version So Apache can recognize PHP files, add the following lines to the end of the httpd.conf configuration file via a text editor, e.g. Notepad: LoadModule php5_module ./php/php5apache2_2.dll PHPIniDir ./php/ AddType application/x-httpd-php .php NOTE: use forward slashes not back slashes and don't miss the periods e.g. "./php/" and ".php" ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- PHP Installation: In the SuperLuminate Downloads folder on your desktop: Rename the php-5.2.6-Win32 folder from --> php-5.2.6-Win32 to ----> php Move php folder to the Apache folder: Move php folder from desktop SuperLuminate Downloads folder to C:\apache\php Add php folder to Windows system PATH environment variable: From the desktop lower left side of the screen Select [Start] button Select [Settings] from the menu Select [Control Panel] from the menu Select [System] icon Select [Advanced] Tab Select [Environment Variables] button Highlight the [Path] variable in the [System Variables] window Then press the [Edit] button for the [System Variables] window At the end of the current PATH variable add the php folder path ;c:\instantclient_11_1;c:\apache\php\ext;c:\apache\php Press the [OK] button on the [Edit System Variable] window Press the [OK] button on [Environment Variables] window Press the [OK] button on [System Properties] window NOTE: A PATH addition starts with a semicolon (don't miss it) To save time we added all three PATH additions now: ;c:\instantclient_11_1 for the Oracle adapter ;c:\apache\php\ext for PHP extensions ;c:\apache\php for PHP Test PHP installation: Restart the server At the lower left side of the server desktop press [start] button Select option [Run...] Where it says Open: Type "cmd" without quotes, then press [OK] button Now after the > symbol type “php -v” without the quotes and hit the [enter] key You should now see the PHP version message If not the PHP folder path was not entered correctly ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- PHP Configuration: php.ini configuration file: Open folder C:\apache\php In the php folder copy the file php.ini-dist and rename the copy to php.ini Set the following variables in the php.ini configuration file via a text editor, e.g. Notepad: NOTE: Depending on version may already be set correctly. Use the find function in your text editor to find the correct entry. A command phrase that you are searching for may also be contained in comments so search for and change only the command phrases that starts in column one or two. EXAMPLE: column 123456789012345678901234567890 from -> doc_root = to -> doc_root = C:\apache\htdocs from -> ;session.save_path = to -> session.save_path = .\htdocs\sl\session NOTE: removed preceding semicolon to activate command In file C:\apache\php\php.ini display_errors = Off (will go to log) display_startup_errors = Off (will go to log) log_errors = On doc_root = C:\apache\htdocs extension_dir = C:\apache\php\ext session.save_path = .\htdocs\sl\session (uncomment -- remove semicolon (don't miss the period) extention=php_oci8.dll (uncomment -- remove semicolon) session.auto_start = 0 session.cache_limiter = none (enables browser back button) session.use_trans_sid = 1 (Zero in version 2.0) register_globals = On (Off in version 2.0) session.bug_compat_42 = 0 (One in version 2.0) session.bug_compat_warn = 0 (One in version 2.0) To use MySQL change line: from -> ;extension=php_mysql.dll to -> extension=php_mysql.dll remove the semicolon in front of the command ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Install Oracle Client Interface (OCI) A.K.A. Oracle Instant Client: In SuperLuminate OCI is used by the Oracle Database Catalog Adapter Move the instantclient_11_1 folder from the desktop SuperLuminate Downloads folder to C:\instantclient_11_1 In the desktop SuperLuminate Downloads folder you will find folder php_oci8 and in that folder you will find php_oci8.dll Replace version 12 with version 13 of the php_oci8.dll in directory C:\apache\php\ext Version 12 php_oci8.dll 101Kb Version 13 php_oci8.dll 149Kb NOTE: OCI requires the php_oci8.dll to be uncommented in the php.ini file and file PATH ;c:\instantclient_11_1 should have also been added to the System PATH when installing PHP and configuring the php.ini file NOTE: ;c:\instantclient_11_1 must be in the System PATH before the PATH ;c:\apache\php\ext and any Oracle related file paths ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- MySQL Install: On the desktop in the SuperLuminate Downloads folder, open the folder mysql-5.0.51b-win32 and press the [Setup.exe] icon Open File Security Warning window: press [Run] button Setup Wizard window: press [Next >] button Setup Type window: select the Custom install option so we can reassign where the MySQL files are installed (new installation directory) press radio button [Custom] press [Next >] button Custom Setup window: to change the default install directory location press [Change...] button Change Current Destination Folder window: change folder name entry to --> C:\mysql\ press [OK] button Custom Setup window: press [Next >] button Ready to Install the Program window: press [Install] button takes about a 20 seconds to install On more information window: press [Next >] button On monitoring window: press [Next >] button On wizard completed window: keep [Configure MySQL Server Now] checkbox checked press [Finish] button On Configuration Wizard window: press [Next >] button On MySQL Server Instance Configuration window: select [Standard Configuration] radio button press [Next >] button On Server Instance Configuration window: keep [Install as a Windows Service] checkbox checked keep [Service Name] as MySQL keep [Launch the MySQL Server automatically] checkbox checked select [Include Bin Directory in Windows PATH] checkbox press [Next >] button On Server Instance Configuration window: keep [Modify Security Settings] checkbox checked enter root password to (WebPa55) NOTE: you can use your own password -- remember it confirm root password (WebPa55) do not check [Enable Root Access Remotely]checkbox do not check [Create An Anonymous Account] checkbox press [Next >] button On the Ready to Execute window: press [Execute] button takes about a 20 seconds to configure Press [Finish] button NOTE: MySQL has been added as a new folder and has also added to the system PATH variable --> ;C:\mysql\bin\mysql.exe ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Test MySQL: At the lower left side of the server desktop press [start] button select option [Run...] where it says Open: Type "cmd" without quotes, then press [OK] button after the > symbol type "mysql -u root -pWebPa55" without quotes and press [Enter] NOTE: No space between -p and WebPa55 Use your own password When MySQL launches type "exit" without quotes, and press [Enter] to exit You can now close the command window ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Test PHP installation: Restart the server Create a file in the htdocs folder named phpinfo.php In the file create the following line and save the file Open your internet browser and enter: http://192.168.1.190/phpinfo.php (using your IP Address) This should display the PHP information page In almost alphabetical order you will find the MySQL section This indicates that MySQL is recognized by PHP and vise versa Right after the MySQL section you should find the OCI section This indicates OCI (Oracle adapter) was loaded correctly NOTE: If an error occurs the quotes in the httpd.conf file may be wrong If the phpinfo page shows up blank the semicolon or brackets in phpinfo(); command may be wrong If the MySQL section is not found in the phpinfo page check the semicolon ";extension=php_mysql.dll" in front of this command in the php.ini file (remove semicolon if there) Is OCI enabled: To use the Oracle adapters make sure on phpinfo page the section "OCI8" shows up right after the "MySQL" section If not there is an error with your OCI installation See the Trouble Shooting: chapter at the end of this document ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Install SuperLuminate Data Dictionary: In the desktop SuperLuminate Downloads folder is the folder sl Move sl to C:\apache\htdocs\sl The C:\apache\htdocs\sl folder will contain the following files: filestore --directory image --directory jsrs --directory session --directory index.html sl_about.html sl_colorchart.html sl_globals.php sl_help.html sl_license.html sl_main.php sl_report.php Edit global file to set your server database connections: Set the variables in the sl_globals.php file via a text editor, e.g. Notepad: $g_host = "localhost"; $g_user = "root"; $g_pass = "WebPa55"; -- Use the MySQL password you assigned $g_database = "SL_Prod"; Install SuperLuminate MySQL database and tables: (not required) The database and default metaschemas are now automatically installed when you start SuperLuminate for the first time To launch SuperLuminate via your web browser: URL --> http://192.168.1.190/sl/sl_main.php (use your IP Address) User ID = "admin" (administration default user id and password) Password = "Pass" (capital P) To launch SuperLuminate Lite: URL --> http://192.168.1.190/sl/sl_main.php?Glossary This will launch SuperLuminate Lite (Glossary only page) SL Lite is defaulted to display only objects of CLASS "Glossary" ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- UPGRADING FROM PREVIOUS VERSION: By way of the SuperLuminate [Administration] page: *** FIRST BACKUP YOUR DATABASE *** Make a copy of sl_main.php --> rename sl_main.php to sl_main.php.bak Add to sl folder new sl_main.php No database change is required from previous version The following is to setup new features: Via the administration page Admin page --> [Modify Configuration] set SL Lite URL Enabled: "N" off "Y" on set load and backup file path --> C:/apache/htdocs/sl/filestore/ set MySQL binaries file path --> C:/mysql/bin/ NOTE: use forward slashes (/) not backslashes (\) save configuration ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- TROUBLE SHOOTING: 1) Failed launch no such file in line ###: Check to make sure you did not change the name of the file during editing like sl_global.txt verse sl_global.php 2) mysql_connect() can't connect to MySQL server on ### (10061) on line ###: This error is encountered if the MySQL password has been set and your network requires a certificate. Set the MySQL password back to null (no password) until your network administrator can supply you with the correct credentials. 3) Can't get past the logon page: If you cannot get past the logon page, your installation is not recognizing your session (login). Make sure, the C:\apache\php\php.ini file has the following setting: register_globals = on (this will be changed in version 2.0) session.use_trans_sid = 1 (this will be changed in version 2.0) 4) Error message: [Error] Error in selecting database error: 1046 No database selected Check to make sure the global variables are set in the file C:\apache\htdocs\sl_globals.php and that they are not commented out (// in the first two columns) 5) Can’t access SuperLuminate from other computers via web browser: If the web browser hangs when you try to access the SuperLuminate URL can be caused by Windows firewall on the SuperLuminate server machine. Turn firewall off or have system administrator open the appropriate ports for your location 6) Warning mysql_connect() host ‘192.168.1.190’ is not allowed to connect to this MySQL server: Change $g_host in global.php file to “localhost” As long as MySQL and Apache are on the same machine If not change the MySQL setup to allow external server access 7) Warning PHP Startup: Unable to load dynamic library "C:\apache\php\ext\php_oci8.dll" the specified module could not be found or OCI not-enabled: Check all of the following: a) This error can occur if the Windows System PATH variable is not set correctly -- See the PHP Installation: chapter b) Check the semicolon ";extension=php_oci8.dll" in front of this command in the php.ini file (remove semicolon if there) c) Make sure the folder instantclient_11_1 was unzipped and placed in the C:/ directory additionally make sure the instantclient_11_1 folder contains the OCI components and not just another folder called instantclient_11_1 (previous zip/unzip issue) ------------------------------------------------------------------------------- -------------------------------------------------------------------------------