Forums

Resolved
0 votes
Hi,

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=127.0.0.1;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..

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

    Monday, September 13 2010, 03:40 PM - #Permalink
    Resolved
    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