Installing an ICSD-for-WWW Server

Test your Apache+PHP+MySQL installation. Do not install the PHP-HTML files until PHP is working.

You may need to read-enable all icsd data files using eg Unix command chmod -R a+r icsd (or clicking the folder with the right mouse button in windows and selecting properties). You will also need to refresh the MySQL server using eg Unix command mysqladmin --password=[your pwd] refresh or rebooting the system. [Beware: files not updated to 2019 version]

You should now be able to use ICSD-for-WWW, but you will need icsd-cgi.zip to enable all features.
(If you have an old version of the ICSD-for-WWW server, most of these features may already work).

Other Server Software: This may be already present (it is provided in the Windows package). Without these applications, ICSD-for-WWW will be missing some features, but will still work fine. You need gzip to compress files, ghostscript gs to convert postscript files to PDF, vrml1tovrml2 (only available for Windows & SGI) to convert VRML1 to VRML2 structures.

Testing ICSD-for-WWW Point your browser to http://localhost/ or your server. If you obtain an error, check that the httpd server is installed and running Create a file info.php containing just <?php phpinfo(); ?> in your html base directory. Point to http://localhost/info.php (info.php on your server). Your PHP installation should be summarised. Important: Do not install ICSD-for-WWW until PHP is working, and delete file info.php after testing. Under Unix, type "which mysql" in a shell. If mysql is not found, check that MySQL is installed and running. After you have installed ICSD-for-WWW, go to the icsd input form and try to run a query If you get an error such as Access denied, check the MySQL user access permissions

Possible Problems and Solutions (use only if you have a problem :-)

The htdocs/icsd and cgi-bin/icsd directories and all subdirectories should have read permission for all.
Note: If other users can logon to your server, you should restrict read access to the Apache user.
>cd htdocs/icsd
>find . -type d -exec chmod 755 {} \;
>find . -type f -exec chmod 644 {} \;
>cd cgi-bin/icsd
>find . -type d -exec chmod 755 {} \;
>find . -type f -exec chmod 644 {} \;

The htdocs/icsd/tmp directory and files must have read/write permission for all.
>cd htdocs/icsd/tmp
>chmod 777 .

The MySQL data directories and files must by owned by mysql.daemon and have read permission.
>cd /var/lib/mysql
>chown -R mysql.daemon *
>chmod -R a+r *

ICSD Access Permissions (if you have the full database). The server administrator is responsible for ensuring that the full ICSD database cannot be accessed by unlicensed users. (The demo database can be accessed by default). In file icsd/dbconfig.php there are two alternatives to set access permissions. Domain name/IP recognition. Access is provided if part of the IP address or name is found in array $domain. To provide access to all (within a firewall) set $domain=array("."); to deny access to all (forcing password recognition) replace the "." with an long string of random characters. Username/Password recognition. If domain recognition fails, a username/password is checked against an encrypted list (usually in) bin/.passwd. This list, which is compatible with passwords used by the .htaccess system, may be generated by the administrator from the un-encryted list .users by running .passupdate.php Please check access by connecting from a domain outside the domain of your server! If the apache server is configured with "performance cache enabled" (default with Mac OS0X), it may return the Host-IP rather than the Client-IP. The Performance Cache can be disabled in ServerAdmin -> Web ->Settings->Options With old versions of apache (1.3.xx) you need to use an extra module (mod_proxy_add_forward) on the server which runs a proxy, to get the HTTP_X_FORWARED_FOR variable in the http header. With Apache 2.0 mod_proxy this is not anymore necessary, as it is included by default.

Installing Apache+PHP+MySQL on Windows, Linux, SGI, Sun…

LoadModule  php4_module libexec/libphp4.so
AddModule   mod_php4.c
AddType  application/x-httpd-php .php

MySQL User Access Permissions If you get: Access denied for user: 'dba@localhost' (Using password: YES)" then you must add user/password=dba/sql. You can do this using the GUI tool phpMyAdmin or else from the Unix/DOS shell.

Installing phpMyAdmin

Edit the file config.inc.php in your phpMyAdmin directory and set the variable $cfgPmaAbsoluteUri to the full URL of your phpMyAdmin directory eg http://icsd.myserver.net/phpMyAdmin/. You will now get a welcome message in your browser, probably followed by an error message such as
Access denied for user: 'root@localhost' (Using password: NO)
In config.inc.php, set $cfgServers[$i]['password'] to your password, or else change $cfgServers[$i]['auth_type'].

Now you should have a phpMyAdmin GUI-interface that will allow you to add users and generally administer your MySQL databases "icsd" and "icsdd". Click on Users and create a user dba with password sql and No Privileges. You should also have an administrator user with a password and All Privileges. You will be asked to enter that user name/password when you connect to MyAdmin. After making any changes, click Reload MySQL and log-out.

Adding a MySQL user from the unix/DOS shell