I've a little article, if you want to connect your Zimbra Postfix with a external greylist like SQLGrey:
Have">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Have fun
Connecting Postfix with SQLGrey
Connecting Postfix with SQLGrey
Thanks deugenin,
That's great!
[quote user="deugenin"]I've a little article, if you want to connect your Zimbra Postfix with a external greylist like SQLGrey:
http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Have fun[/QUOTE]
That's great!
[quote user="deugenin"]I've a little article, if you want to connect your Zimbra Postfix with a external greylist like SQLGrey:
http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Have fun[/QUOTE]
Connecting Postfix with SQLGrey
Hello,
I try to install sqlgrey but when I start sqlgrey I get :
Binding to TCP port 2501 on host localhost
dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
.....
It is not as easy as in the wiki :
I'm">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
I'm using zcs-3.1.4_GA_518.FC4.tgz with no change in any conf file
I try to install sqlgrey but when I start sqlgrey I get :
Binding to TCP port 2501 on host localhost
dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
.....
It is not as easy as in the wiki :
I'm">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
I'm using zcs-3.1.4_GA_518.FC4.tgz with no change in any conf file
Connecting Postfix with SQLGrey
Is SQLgrey to use it's own MySQL server or Zimbra. If it is supposed to use it's own then it's possible MySQL isn't started, which could be because of a port conflict if it is running on the same box as Zimbra. If SQLgrey is to use Zimbra's MySQL server then using that socket will not work the locatation of Zimbra's MySQL socket is /opt/zimbra/db/mysql.sock
-
- Advanced member
- Posts: 155
- Joined: Fri Sep 12, 2014 9:58 pm
Connecting Postfix with SQLGrey
[quote user="Yvonne"]I try to install sqlgrey but when I start sqlgrey I get :
Binding to TCP port 2501 on host localhost
dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
.....
It is not as easy as in the wiki :[/QUOTE]
Howdy,
Well, I guess the article assumes that you have SQL Grey working first... the article is more how to tie in a working SQL Grey into Zimbra.
SQL Grey uses MySQL to work, so you'd need to setup another instance of MySQL on your server, and point SQL Grey at it. But, you can get all that setup using the SQL Grey docs. Once it's setup, then check out the wiki entry :-)
-Eric
Binding to TCP port 2501 on host localhost
dbaccess: can't connect to DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
dbaccess: error: couldn't get now() from DB: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
.....
It is not as easy as in the wiki :[/QUOTE]
Howdy,
Well, I guess the article assumes that you have SQL Grey working first... the article is more how to tie in a working SQL Grey into Zimbra.
SQL Grey uses MySQL to work, so you'd need to setup another instance of MySQL on your server, and point SQL Grey at it. But, you can get all that setup using the SQL Grey docs. Once it's setup, then check out the wiki entry :-)
-Eric
Connecting Postfix with SQLGrey
Hi all, i'm updating the Wiki article, and i use SQLite for SQLGrey.
Regards">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Regards
--
Daniel
Regards">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Regards
--
Daniel
-
- Outstanding Member
- Posts: 367
- Joined: Fri Sep 12, 2014 10:17 pm
Connecting Postfix with SQLGrey
Hi,
I'm wondering if someone can help me solve my problem. I've got Open Source Zimbra installed on a CentOS4 server and wanted to implement the SQLGrey using the wiki article that has been posted.
I've got all the required Perl modules installed, but when I try to...
rpm -ivh sqlgrey-1.6.7-1.noarch.rpm
...I get this error...
error: Failed dependencies:
perl(Net::Server::Multiplex) is needed by sqlgrey-1.6.7-1.noarch
I have checked and this module exists in /usr/lib/perl5/site_perl/5.8.5. I've uninstalled and reinstalled via CPAN. I also downloaded the module source and installed it manually. It seems that no matter what I do the sqlgrey rpm install does not see this module.
Can anyone tell me where I've gone wrong?
Thanks,
Matt
I'm wondering if someone can help me solve my problem. I've got Open Source Zimbra installed on a CentOS4 server and wanted to implement the SQLGrey using the wiki article that has been posted.
I've got all the required Perl modules installed, but when I try to...
rpm -ivh sqlgrey-1.6.7-1.noarch.rpm
...I get this error...
error: Failed dependencies:
perl(Net::Server::Multiplex) is needed by sqlgrey-1.6.7-1.noarch
I have checked and this module exists in /usr/lib/perl5/site_perl/5.8.5. I've uninstalled and reinstalled via CPAN. I also downloaded the module source and installed it manually. It seems that no matter what I do the sqlgrey rpm install does not see this module.
Can anyone tell me where I've gone wrong?
Thanks,
Matt
Connecting Postfix with SQLGrey
I always try to use RPM packages instead CPAN installed modules.
All packages requires by SQLGrey I downloaded from DAG repository:
http://apt.sw.be/redhat/el4/en/i386/RPMS.dag/
>
If you have Red Hat 4 or CentOS 4, you can install them using APT:
rpm -Uvh http://apt.sw.be/redhat/el4/en/i386/RPMS.dag/apt-0.5.15lorg3.2-1.el4.rf.i386.rpm
apt-get update
apt-get install perl-Net-Server perl-IO-Multiplex perl-DBD-SQLite sqlite -y
Note: before using APT, you must install perl-Date-Calc from Red Hat or CentOS CDs.
All packages requires by SQLGrey I downloaded from DAG repository:
http://apt.sw.be/redhat/el4/en/i386/RPMS.dag/
>
If you have Red Hat 4 or CentOS 4, you can install them using APT:
rpm -Uvh http://apt.sw.be/redhat/el4/en/i386/RPMS.dag/apt-0.5.15lorg3.2-1.el4.rf.i386.rpm
apt-get update
apt-get install perl-Net-Server perl-IO-Multiplex perl-DBD-SQLite sqlite -y
Note: before using APT, you must install perl-Date-Calc from Red Hat or CentOS CDs.
-
- Outstanding Member
- Posts: 367
- Joined: Fri Sep 12, 2014 10:17 pm
Connecting Postfix with SQLGrey
Whoohoo!! That worked...
Thanks for the quick response.
Matt
Thanks for the quick response.
Matt
Connecting Postfix with SQLGrey
I'm really happy for you Matt, and I'm updating my wiki article again
Regards">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Regards
Regards">http://wiki.zimbra.com/index.php?title=Connecting_with_SQLGrey
Regards
Who is online
Users browsing this forum: No registered users and 12 guests