0 votes

I'm trying to access the amavisd mysql database but cannot connect to it from the command line.

/etc/amavisd/api.conf has the following line;

@storage_sql_dsn = ( ['DBI:mysql:database=amavisd;host=;port=3308', 'amavisd', 'raVcq/yBf2Fsv2yQ']);

When I try to connect via mysql command line I cannot see the database?
 mysql -u amavisd
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
| Database |
| information_schema |
| test |
2 rows in set (0.00 sec)

How do I get a connection to the amavisd database?

Thanks in advance..

Monday, September 13 2010, 01:45 PM
Share this post:
Responses (1)
  • Accepted Answer

    Monday, September 13 2010, 03:40 PM - #Permalink
    0 votes
    Hi Matt,

    ClearOS uses it's own MySQL sandbox for internal use (like Amavis). You can find the sandboxed install in /usr/share/system-mysql/. To connect to the database, run:

    /usr/share/system-mysql/usr/bin/mysql ...
    The reply is currently minimized Show
Your Reply