Vqadmin Database error

[PJM]

I installed Vpopmail with Mysql integration with no problems. I can add domains and users with the vadddomain and vadduser. Then I setup Vqadmin and I can see the domains and users that I created, but when I want to add a new Domain using Vqadmin a get following error:

Database error
display_add_domain: Access denied for user 'my_user'@'localhost' (using password: YES)

I know that it has to do with Mysql, but I don't know where I have to go to change these settings.

PJM

[utsab]

Hi,
I am alsi getting the same error like

Database error
display_add_domain: Access denied for user 'my_user'@'localhost' (using password: YES)

So if you find the solution please let me know

Best regards
utsab

[PJM]

To figure out the problem, I made a fresh installation of Qmailrocks, this time I didn't use the --enable-mysql=y while compiling Vqadmin. I hope this will help you. I also used htpasswd2 instead of htpasswd since I am using apache2 webserver ( I don’t think it has something to do with Database error, but is good to know).

PJM

[ciberpiano]

I had same problemmmm, but as all of us, it was all our fault.. what it happens, is that, when we compile VQADMIN, if we use the --enable-mysql=y FLAG, we need to configure the file db_owner.c before doing any compilation, in that file, you should put, mysql rigth access, such as User, Password, Database etc. Also is needed to create a TABLE
CREATE TABLE domain_owner (
domain CHAR(64) NOT NULL,
owner CHAR(32) NOT NULL,
PRIMARY KEY(domain, owner)
);
READ the README.SQL at your VQADMIN directory.

Hope this helps somebody, because, i lost lot of my time finding out this.

Note: I dont speak english, so please forgive my incorrectness. jaja.
Arriba Mexico