Andy's Wiki

via videosift.com

via videosift.com

via videosift.com

via videosift.com

First install UnixODBC as shown in the UnixODBC HOWTO.

Next install libraries used by iHTML:

aptitude install libgd2 libpng3 libfreetype6 libjpeg62

Download the iHTML install from http://www.ihtml.com/download/installer.ihtml.

wget http://ftp.inline.net/public/client/installer/installerlinux.tar.gz

Unzip the files:

mkdir ihtml
mv installerlinux.tar.gz ihtml
cd ihtml
tar zxvf installerlinux.tar.gz

Now move to the installer directory and run setup:

cd /usr/ihtml/installer
./setup

Proceed through the installer, downloading the iHTML package, unzipping and installing.

Check the lines added to /etc/apache2/httpd.conf look something like this:

# iHTML Module
LoadModule ihtml_module /usr/ihtml/ihtml.so

# iHTML module
AddType text/ihtml .ihtml .ihtm .ienc .inc .m2p .m2e .m2m
AddHandler ihtml-handler .ihtml .ihtm .ienc .inc .m2p .m2e .m2m

Alias /ihtml /usr/ihtml/ihtml
<Directory "/usr/ihtml/ihtml">
    AllowOverride None
    Options All
    order allow,deny
    allow from all
</Directory>

Alias /ihtml_config /usr/ihtml/ihtml_config
<Directory "/usr/ihtml/ihtml_config">
    AllowOverride None
    Options All
    order allow,deny
    allow from all
</Directory>

Alias /merchant /usr/ihtml/merchant
<Directory "/usr/ihtml/merchant">
    AllowOverride None
    Options All
    order allow,deny
    allow from all
</Directory>

Move some log files to more appropriate places:

mkdir /var/log/ihtml
cd /usr/ihtml
mv /usr/ihtml/ihtml.log /var/log/ihtml/
mv /usr/ihtml/log/tagerror.log /var/log/ihtml
ln -s /var/log/ihtml/ihtml.log ihtml.log
ln -s /var/log/ihtml/tagerror.log log/tagerror.log
chown -R www-data:www-data /var/log/ihtml
chmod -R 640 /var/log/ihtml

And update the 'registry' settings to use the new paths:

ee /usr/ihtml/registry/hkey_local_machine/software/inline/ihtml/currentversion.nv

diaglogpath     <reg_sz>        /var/log/ihtml/diag.log
ErrorLogPath    <reg_sz>        /var/log/ihtml/tagerror.log
ThreadLogPath   <reg_sz>        /var/log/ihtml/thread.log

Set some more permissions:

chown root:www-data /usr/ihtml/odbc-i01.so
chmod 604 /usr/ihtml/odbc-i01.so

chown root:www-data /usr/ihtml/odbc-i01.config.ini
chmod 604 /usr/ihtml/odbc-i01.config.ini

chown www-data:www-data /usr/ihtml/ihtml.log
chmod 640 /usr/ihtml/ihtml.log

chown www-data:www-data /usr/ihtml/ihtml_config/access.log
chmod 640 /usr/ihtml/ihtml_config/access.log

Restart apache:

/etc/init.d/apache2 restart

To test iHTML you should find a test page here:

http://localhost/ihtml/congrats.ihtml

To test MySQL connections through UnixODBC, create a test database and user and add the following to the above file:

<p>Let's try MySQL:</p>
<table>
<iHTML DBNAME="test" LOGIN="test/test" SQL="SELECT * FROM test" OUTPUT="<tr><td>:1</td></tr>" FAILURE="ERROR: <br>:i_sqlerrortext <p>:i_sqlerrorstmt<br>">
</table>

You can access iHTML config settings here:

http://localhost/ihtml_config

You may need to add your IP address to /usr/ihtml/ihtml_config/hosts.allow as shown below:

'127.0.0.1', '1.2.3.4'