Adding ODBC client will make it easy to do custom apps at the PC with MySQL data on the server.

As the email search features reveal email as soon as it arrives and pop3 collected email is cleared when email client connects, there must be some other database in which email is deposited on arrival. What is it please and is their an ODBC client for it. I need to write a client ODBC app that parses the server email headers for keywords - matching messages are to be further processed into a order processing system. I'll need access to the message body for the latter.

Thanks in advance....

The MySQL server that comes on ClearOS is pretty standard. ODBC access is available and can be accessed on port 3306.

Email is NOT stored in MySQL so you cannot access it there.

You can download an appropriate MyODBC client package from MySQL