Setup on I-spy

• Installed mysql, apache, php, phpMyAdmin on i-spy.cc.gt.atl.ga.us
  • Newest version of mysql uses new password hashing algorithm not supported by phpMyAdmin yet. So, we had to add the "old passwords" directive to "my.ini".
    • (Jose) - This means adding the following two lines (without quotes):
    • "#Use old password encryption method "
    • "old_passwords "

• PHP Setup (php.ini, probably located in C:\WINNT)
  • Left REGISTER GLOBALS to OFF (Default setting)
  • Set upload_max_filesize to 60MB
  • Set memory_limit to 60MB
  • Set post_max_size to 60MB
  • Set max_input_time to 600 (this value might not be enough)

• APACHE Setup (httpd.conf, probably in G:\Program Files\Apache Group\Apache 2\conf)
  • Added directive for max uploads LimitRequestBody to approx. 70MB
  • Set HostnameLookups On (can now tell what hostname visitors come from)

• I then reset the root users password so that it would rehash with the older algorithm.
  • Might need to change the way we authenticate within the pages...not sure.
• Works great now!
• Databases moved successfully from messena despite the lack of an export...we just moved the raw files over.