A short introduction for me and the background to the problem in the subject line. I am most grateful for any help or direction toward help that those who read this may offer and I can only hope my plight comes across as respectful and worthy of response.

I am a technical editor working with an author on an Applixware book. I am very new to Linux and have to use Applix Data (current) and MySQL (3.22.27). Using other software is not an option. <g> I'm running RH 6.0 on a stand alone Linux only machine. Netscape is functional but I have not configured any mail services yet.

The book covers all aspects of Applix and everything has worked except the connection to MySQL. No matter which instructions I have followed, I receive a variety of 'cannot connect to local server.'

I have followed the directions for installing Applix and MySQL according to the documentation for each package. I have the default mysql database, have created a new database in MySQL, edited the new database and also installed a database created by the author. I can get into, use and get out of mysql. I start and use mysql as root with a password.

I also have printed out all 341 pages of the MySQL documentation which I have been attempting to read and put into practice but I may be waving a running digital chainsaw around my applications and files rather that doing any good for myself.

If I start Applix and Data, Data sees the databases. But when I select Query>>Choose Server, then choose mysql in the Datasource and the List of Database Connections and click OK ,the result is an error:

Error from ODBC gateway S1000::[TCX][MyODBC]Can't connect to local MySQL server.

So I exited to the console and typed

mysqladmin -ppassword version:

Server version is 3.22.27 Protocol version 10 Connection localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock

mysqladmin -ppassword -h `hostname` version variables

mysqladmin: connect to server at 'localhost.localdomain' failed error: 'Can't connect to MySQL server on 'localhost.localdomain' (101)' Check that mysqld is running on localhost.localdomain and that the port is 3306. You can do this by doing 'telnet locahost.localdomain 3306'

running: top

there are three mysql/mysqld user entries at PID 567,569,570

running: telnet localhost.localdomain 3306

Trying 127.0.0.1... telnet: Unable toconnnect to remote host: Network is unreachable.

(I am not on a network though I have a network card in the computer so this may be an understandable error.)

Previously I received the: Error from ODBC Gateway Im003::[iODBC][Driver Manager] Specified Driver could not be loaded.

But we edited the .odbc.ini file to match the file locations on my hd and now I'm getting the S1000 error. (I cannot tell you where the error messages changed we've been working on this for over a week straight and I'm fried.)

Here is my .odbc file

[ODBC Data Sources] mysql=MySQL Database pets=MySQL Database TONTO=MySQL Database

[mysql] Driver=/opt/applix/axdata/axshlib/drivers/libmyodbc_mysql.so Database=test Server=localhost

[pets] Driver=/opt/applix/axdata/axshlib/drivers/libmyodbc_mysql.so Database=pets Server=localhost

[TONTO] Driver=/opt/applix/axdata/axshlib/drivers/libmyodbc_mysql.so Database=TONTO Server=localhost

[ODBC] InstallDir=opt/applix/axdata/axshlib

I have uninstalled and reinstalled MySQL and the MySQL client.

In /etc/services I added the line:

axnet 5492/tcp # Applix Networking

In /opt/applix/axdata/axnet.cnf I removed the # from:

#libFor elfodbc /ax/axexec/axdata/axshlib/lib

and changed it to read:

libFor elfodbc /opt/applix/axdata/axshlib/lib

to match my MySQL installation. I also removed the # from the following line:

#setenvFor elfodbc /ax/asexed/axdata/axshlib

It should be noted that this path does not exist on my hd so when the 'cannot connect' (S1000) error appeared I commented out the line and typed in:

setenvFor elfodbc /opt/applix/axdata/axshlib

I still get the error. I hope someone here can help.