[vexim] Trouble connecting to db

[Odhiambo Washington]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://silverwraith.com/pipermail/vexim/attachments/20100225/78bd1bd1/attachment.htm>