Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Connecting Postfix with SQLGrey

  1. #1
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default Connecting Postfix with SQLGrey

    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?tit...g_with_SQLGrey

    Have fun

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Thanks deugenin,
    That's great!

    Quote Originally Posted by 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?tit...g_with_SQLGrey

    Have fun

  3. #3
    Join Date
    Sep 2005
    Location
    Toulouse (France)
    Posts
    8
    Rep Power
    10

    Default some help please : mysql dont work

    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 : http://wiki.zimbra.com/index.php?tit...g_with_SQLGrey

    I'm using zcs-3.1.4_GA_518.FC4.tgz with no change in any conf file

  4. #4
    Join Date
    Nov 2005
    Location
    London, ON
    Posts
    255
    Rep Power
    10

    Default

    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

  5. #5
    Join Date
    Oct 2005
    Location
    Harrisburg, Pennsylvania
    Posts
    155
    Rep Power
    10

    Default

    Quote Originally Posted by 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 :
    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

  6. #6
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default Wiki actualization

    Hi all, i'm updating the Wiki article, and i use SQLite for SQLGrey.

    http://wiki.zimbra.com/index.php?tit...g_with_SQLGrey

    Regards
    --
    Daniel
    Daniel Eugenin
    http://www.it-linux.cl

  7. #7
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    9

    Default Having trouble with this...

    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

  8. #8
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default

    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/...l4.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.
    Daniel Eugenin
    http://www.it-linux.cl

  9. #9
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    9

    Default

    Whoohoo!! That worked...

    Thanks for the quick response.

    Matt

  10. #10
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default

    I'm really happy for you Matt, and I'm updating my wiki article again

    http://wiki.zimbra.com/index.php?tit...g_with_SQLGrey

    Regards
    Daniel Eugenin
    http://www.it-linux.cl

Similar Threads

  1. Replies: 3
    Last Post: 11-03-2007, 11:55 PM
  2. migration from postfix
    By wjlyerly in forum Migration
    Replies: 1
    Last Post: 05-02-2007, 01:02 PM
  3. Cannot send mail.
    By jeremyshoe in forum Installation
    Replies: 7
    Last Post: 10-17-2006, 10:42 PM
  4. unable to restart zimbra after reboot
    By droefs in forum Administrators
    Replies: 28
    Last Post: 04-16-2006, 03:33 PM
  5. Is it started or not
    By kwelipatton in forum Installation
    Replies: 10
    Last Post: 03-28-2006, 11:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •