Am 01.05.2013 19:28, schrieb Luigi Noris:
> Hello, I try to use db suite plugin because I need to share the DB of
> greylisting with two server. My intention is to use a remote mysql
> server but I unable to understand where and how specify the server IP
> or name in the db_base config.
>
> Thx in adv,
>
> Gigi Noris
>
Hi Luigi,
the entries in db_base
driver=mysql
database=maildb
are used to build the $data_source for DBI->connect as follows:
'DBI:' . $config->{driver} . ':' . $config->{database};
The above example connects to a local database:
'DBI:mysql:maildb';
DBI allows to specify a remote database:
dbi:DriverName:database_name
dbi:DriverName:database_name@hostname:port
dbi:DriverName:database=database_name;host=hostname;port=port
So try:
driver=mysql
database=mai...@example.com:3306
or:
driver=mysql
database=database=maildb;host=example.com;port=3306
NOT TESTED!
Please notice me, if you get error messages.
See also:
http://dienstleistung-kultur.de/qpsmtpd/db_base.shtml#configuration
http://dienstleistung-kultur.de/qpsmtpd/db_common.shtml#db_connect
http://search.cpan.org/~timb/DBI-1.625/DBI.pm#connect
Regards
Ernesto
