[vexim] Trouble connecting to db

[Andreas Westvik]

From: odhiambo at gmail.com
Date: Thu, 25 Feb 2010 10:05:57 +0300
To: vexim at silverwraith.com
Subject: Re: [vexim] Trouble connecting to db



On Thu, Feb 25, 2010 at 2:49 AM, Andreas Westvik <andreas_westvik at hotmail.com> wrote:









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.




I don't use phpmyadmin myself. It's something I'd rather setup for ordinary users. My thinking is that you used phpmyadmin, running as www-data (your system is Linux, right?) to create the database, and perhaps even to migrate. I've never done such things with phpmyadmin. On my syste (FreeBSD) all database files are owned by mysql user. We don't have www-data on FreeBSD. It's always www.

Anyway, changing the ownership of the DB files to the user you want will not affect your mail system. What is important is the access privileges to the db.
-- 
Best regards,
Odhiambo WASHINGTON,


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




Anyways, its all working now. Thanks alot again for the help Odhiambo! :D
 		 	   		  
_________________________________________________________________
Windows 7: Se direkte-TV fra den bærbare PCen. Finn ut mer.
http://windows.microsoft.com/windows-7
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://silverwraith.com/pipermail/vexim/attachments/20100225/1b842911/attachment.htm>