Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th January 2010, 14:58
voltron81 voltron81 is offline
Senior Member
 
Join Date: Sep 2009
Posts: 292
Thanks: 1
Thanked 4 Times in 3 Posts
 
Default How to setup postfix to access to the database with procedures

Hi to everybody.

I've realized a mailserver with postfix, using this how-to: http://www.howtoforge.com/virtual-us...l-debian-lenny

It's working fine, but for the final configuration I need to access to the mysql database via procedures...
So I created the procedures like that:
Code:
DELIMITER $$

DROP PROCEDURE IF EXISTS `get_virtualrelaydomains` $$
CREATE DEFINER=`xxxxxx`@`%` PROCEDURE `get_virtualrelaydomains`(IN domain1 VARCHAR(45))
BEGIN
SELECT domain FROM mail_transport WHERE domain = domain1;
END $$

DELIMITER ;
and the .cf files like this:
Code:
user = xxxxx
password = xxxxxx
dbname = xxxxxx
query = CALL get_virtualrelaydomains('%s')
hosts = 127.0.0.1
but it's not working... it's giving me this kind of problems:
Code:
 postfix/proxymap[9339]: warning: mysql query failed: PROCEDURE xxxx.get_virtualrelaydomains can't return a result set in the given context
etc...

Any idea how to setup postfix in this way?

Thanks
Michele
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Loop To Myself With Postfix, Courier, MySQL Setup asyadiqin Server Operation 13 12th November 2010 05:35
Help configure Postfix to use alt port 465 or 587 BoloMarkIII Installation/Configuration 10 16th March 2009 17:57
i dont recive any mail of any domain chua_jose Installation/Configuration 18 10th November 2008 18:55
How to setup Postfix on SuSE 10.x baldur2630 Server Operation 2 9th October 2008 19:00
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47


All times are GMT +2. The time now is 17:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.