<br><br><div class="gmail_quote">On Thu, Feb 25, 2010 at 2:49 AM, Andreas Westvik <span dir="ltr"><<a href="mailto:andreas_westvik@hotmail.com">andreas_westvik@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<br><br><hr>From: <a href="mailto:odhiambo@gmail.com" target="_blank">odhiambo@gmail.com</a><br>Date: Wed, 24 Feb 2010 08:56:29 +0300<div class="im"><br>To: <a href="mailto:vexim@silverwraith.com" target="_blank">vexim@silverwraith.com</a><br>
Subject: Re: [vexim] Trouble connecting to db<br><br><br><br></div><div><div></div><div class="h5"><div>On Tue, Feb 23, 2010 at 9:52 PM, Andreas Westvik <span dir="ltr"><<a href="mailto:andreas_westvik@hotmail.com" target="_blank">andreas_westvik@hotmail.com</a>></span> wrote:<br>
<blockquote style="border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div>
<br><br><br>Some movement in this case. <br><br>In phpmyadmin I removed the www-data passwd, I then I got in the vexim stuff, everything there is now back to normal.<br>But I used to use the mysql user vexim and not www-data? I really dont understand this.<br>
And I can send mail from my local mail program, but I cannot recieve. <br><br>Any pointers?</div><div><br></div></blockquote><div><br></div><div>Andreas,</div><div><br></div><div>Why you use phpmyadmin for such simple tasks beats me:-)</div>
<div><br></div><div>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.</div><div>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.</div>
<div><br></div><div> </div></div><br>-- <br>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254733744121/+254722743223<br>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ <br>"If you have nothing good to say about someone, just shut up!."<br>
-- Lucky Dube<br><br></div></div>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. <br>And the command system for doing stuff there is very strange:)<br>
<br>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.<br>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.<br>
</div><div><br></div></blockquote><div><br></div><div>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.</div>
<div>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.</div></div><br>-- <br>Best regards,<br>Odhiambo WASHINGTON,<br>
Nairobi,KE<br>+254733744121/+254722743223<br>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ <br>"If you have nothing good to say about someone, just shut up!."<br> -- Lucky Dube<br>