[vexim] Trouble connecting to db

[Andreas Westvik]

From: odhiambo at gmail.com
Date: Wed, 24 Feb 2010 08:56:29 +0300
To: vexim at silverwraith.com
Subject: Re: [vexim] Trouble connecting to db



On Tue, Feb 23, 2010 at 9:52 PM, Andreas Westvik <andreas_westvik at hotmail.com> wrote:










Some movement in this case. 

In phpmyadmin I removed the www-data passwd, I then I got in the vexim stuff, everything there is now back to normal.
But I used to use the mysql user vexim and not www-data? I really dont understand this.


And I can send mail from my local mail program, but I cannot recieve. 

Any pointers?

Andreas,
Why you use phpmyadmin for such simple tasks beats me:-)


Anyway, if you run the same SQL syntax I have and replaced www-data with vexim and then reflect the same user in variables.php, you should be fine.The reason you cannot receive mail is perhaps to do with the SQL configuration for your pop3/imap4 daemon, which may not be accessing the database because you have not yet configured correctly the credentials to access the database. I guess you get what I mean. The pop3/imap4 daemon also needs a username and password to access the vexim DB.


 
-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
"If you have nothing good to say about someone, just shut up!."


               -- Lucky Dube

I used cli for the commands you mentioned and such. But the mysql interface in cli can get very unfamiliar for some one like me. 
And the command system for doing stuff there is very strange:)

The mail is now working like before, but the owner of the database still is www-data and not vexim. And I dont like that for one bit.
And I dont know how this is possible, since the variables.php has vexim/vexim as user/database. Very strange if you ask me. Its like apache2 is setup to connect to mysql as www-data no matter what. I think I'm going to post some messages at the official mysql forum to learn more about this.

-Andreas







 		 	   		  
_________________________________________________________________
Få nye Windows Live™ Messenger.
http://download.live.com/messenger
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://silverwraith.com/pipermail/vexim/attachments/20100224/5522e70c/attachment.htm>