Introduction
This HOW:TO will show you how to make twiggi’s contacts available to hylafax users who use the WHFC client under windows.
If you need hylafax: Hylafax
If you need WHFC: WHFC
Mysql
- First create a user named hylafax with minimum access rights to twiggi.
[root@server /root]# mysql
(Note: you may need mysql -p mysql and then enter your mysql password)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1023 to server version: 3.23.32
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> grant select on twiggi.* to hylafax identified by 'hyla!fax';
Query OK, 0 rows affected (0.01 sec)
- Next using phpMyAdmin, change the twig_contacts field 'item' to be viewed by WHFC. Start phpMyAdmin, select twiggi > twig_contacts,
find the field item and select change. Set the type from TEXT to VARCHAR and set Length/Set 100.
Windows workstation
Get myODBC
Then go set up the twiggi ODBC connection via:
Control Panel > Administrative Tools > Data Sources (ODBC) > and under the UserDSN tab, select Add:
Then choose mySQL > Finish
Fill in the information below substituting your e-smith server internal IP address.
Password = hyla!fax
OK to save and exit the Control Panel
WHFC:
Start the WHFC and open the Phonebook > add the phonebook named twiggi by typing twiggi in the top left box. Next select ODBC (FaxNo. from the same table). Select Database > Machine Data Source > twiggi > OK
Then Table for Userinformation = twig_contacts and select the fields shown below:
OK to save and now the WHFC will use the twiggi contact list as it's fax address book :-)
Note the field 'item' above is the Nickname field in twiggi contacts so make sure this field is filled in, under twiggi as you want it to appear in the fax address book. For instance the Nickname field should be a filled in with the users full name or a company name.
|
