Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Connecting Postfix with SQLGrey

  1. #11
    pepijn's Avatar
    pepijn is offline Active Member
    Join Date
    Jul 2006
    Location
    Novi, MI
    Posts
    27
    Rep Power
    9

    Thumbs up Working fine with ZCS NE 4.0.2/RHEL 4 ES

    I just wanted to add another successful install to the mix. I didn't quite install the required Perl mods and sqlite/sqlgrey the way the wiki prescribes. It seemed all was fine going through CPAN for the Perl mods; I compiled sqlite from source (ommiting TCL bindings at configure time) since the rpm listed on RHN for RHEL4 ES did not want to install. I grabbed sqlgrey from the SF repository and followed the config steps from the wiki to have it use SQLite and insert it into Zimbra's MTA restrictions queue. After that, I was happily greylisting all incoming mail as shown by new sqlgrey entries in /var/log/zimbra.log. Now to properly install sgwi the SQLGrey web interface; a PHP-based tool. Looks like I'll have to get Zimbra's PHP to connect to the SQLite db instead of the mysql/pgsql DBs sgwi is set up to support right now.

    Thanks for the wiki entry, it all worked out well.

    pepijn.

  2. #12
    pepijn's Avatar
    pepijn is offline Active Member
    Join Date
    Jul 2006
    Location
    Novi, MI
    Posts
    27
    Rep Power
    9

    Thumbs up SQLGrey web interface working

    After some tinkering with the different bits and pieces this evening, I was able to get Zimbra's PHP to play nice with sqlgrey's sqlite 3 database. The resulting web interface to sqlgrey is spartan but functional which is mostly because of the web interface being in its early stages. If anyone is interested I can append my findings to the SQLGrey wiki entry.

    pepijn.

  3. #13
    deugenin is offline Project Contributor
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default

    Quote Originally Posted by pepijn
    ...
    If anyone is interested I can append my findings to the SQLGrey wiki entry.
    pepijn.

    Yeah!, any help for SQLGrey Wiki well will be received.

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

  4. #14
    pepijn's Avatar
    pepijn is offline Active Member
    Join Date
    Jul 2006
    Location
    Novi, MI
    Posts
    27
    Rep Power
    9

    Default

    I updated the wiki with my method for getting the web interface to work. Hopefully it'll work for someone else out there, with all the applicable disclaimers about usefulness firmly applied.

    pepijn.

  5. #15
    deugenin is offline Project Contributor
    Join Date
    Jun 2006
    Location
    Santiago - Chile
    Posts
    76
    Rep Power
    9

    Default

    Thank you very much Pepijn!!!

    There is a great contribution!

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

  6. #16
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-03-2007, 10:55 PM
  2. migration from postfix
    By wjlyerly in forum Migration
    Replies: 1
    Last Post: 05-02-2007, 12:02 PM
  3. Cannot send mail.
    By jeremyshoe in forum Installation
    Replies: 7
    Last Post: 10-17-2006, 09:42 PM
  4. unable to restart zimbra after reboot
    By droefs in forum Administrators
    Replies: 28
    Last Post: 04-16-2006, 02: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
  •