From blclark@gci.net Sun Jul 21 13:01:47 2002 From: blclark@gci.net (Barry) Date: Sun, 21 Jul 2002 04:01:47 -0800 Subject: [sam] PostgreSQL and MySQL Message-ID: <000601c230ae$64147420$6500a8c0@piii866> This is a multi-part message in MIME format. ---------------------- multipart/alternative attachment I have been running horde with MySQL for some time now and all is working great. I thought that I would try out SpamAssasin so I installed and configured it and to my surprise there was not a script for creating a DB for MySQL. I decided to run a separate instance of PostgreSQL and just use that. The DB and Tables created just fine and then I tried to hit it from my webpage and it fails to connect, this is not a user pass error this just won't hit the psql server at all. I can connect fine locally and even run the Module for Webmin so I know the server is running. I have entered 5446 for both tcp and udp in /etc/services and it still won't connect from the web. I have never really used PostgreSQL before so I am stuck at what to do. What I would really like to do is to just make a MySQL DB and just connect to it but I can see that I have to change all kinds of things in the sam module for that and I am just not up to it. Is there anyone out there who has successfully created a MySQL DB for sam? If so, I would really like to know how to do it. Thanks, Barry ---------------------- multipart/alternative attachment

I have been running horde with MySQL for some time now and all is working great.  I thought that I would try out = SpamAssasin so I installed and configured it and = to my surprise there was not a script for creating a DB for MySQL.  I decided to run a separate = instance of PostgreSQL and just use that.  The DB and Tables created just = fine and then I tried to hit it from my webpage and it fails to connect, this is = not a user pass error this just won’t hit the psql server at all.  I can = connect fine locally and even run the Module for Webmin = so I know the server is running.  I = have entered 5446 for both tcp and udp in /etc/services and it still won’t connect from the web.  I have never really used PostgreSQL before so I am stuck at what to = do.  What I would really like to do = is to just make a MySQL DB and just connect to it = but I can see that I have to change all kinds of things in the sam module for that and I am just not up to it.  Is there anyone out there who = has successfully created a MySQL DB for sam?  If so, I would really like to = know how to do it.

 

Thanks,

 

Barry

---------------------- multipart/alternative attachment-- From scrappy@hub.org Sun Jul 21 21:37:07 2002 From: scrappy@hub.org (Marc G. Fournier) Date: Sun, 21 Jul 2002 17:37:07 -0300 (ADT) Subject: [sam] PostgreSQL and MySQL In-Reply-To: <000601c230ae$64147420$6500a8c0@piii866> Message-ID: <20020721173620.L55177-100000@mail1.hub.org> On Sun, 21 Jul 2002, Barry wrote: > I have been running horde with MySQL for some time now and all is > working great. I thought that I would try out SpamAssasin so I > installed and configured it and to my surprise there was not a script > for creating a DB for MySQL. I decided to run a separate instance of > PostgreSQL and just use that. The DB and Tables created just fine and > then I tried to hit it from my webpage and it fails to connect, this is > not a user pass error this just won't hit the psql server at all. I can > connect fine locally and even run the Module for Webmin so I know the > server is running. I have entered 5446 for both tcp and udp in Looks like a 'mis-commit' on Chris' part based on our database layouts ... try changing, in the SAM config file, the port to 5432, instead of 5446 ...