Bug 71289 – mambo fails to set up mysql correctly

• Product: Gentoo Linux
• Status: RESOLVED FIXED

[Description Robert "Baer" Heine 2004-11-15 08:21:33 UTC]

Programs that use mysqladmin to configure a mysql-db do not seem to be able to connect

<snip>
asgard:/usr/portage/www-apps/mambo # ebuild /var/db/pkg/www-apps/mambo-4.5/mambo-4.5.ebuild config
 * Starting mysqld...                                                             [ ok ]
mysql db name [mambo]:
mysql db host [localhost]: asgard
mysql dbuser name [mambo]:
mysql dbuser password: ********
Please enter login info for user who has grant privileges on asgard [root]:
Client address (at db side) [asgard.heim10.tu-clausthal.de]:
Enter password:
mysqladmin: connect to server at 'asgard' failed
error: 'Access denied for user: '[e-mail]' (Using password: YES)'

!!! ERROR: www-apps/mambo-4.5 failed.
!!! Function pkg_config, Line 83, Exitcode 1
!!! Error creating database
!!! If you need support, post the topmost build error, NOT this status message.
</snip>

...but seems to work with other backends like "mysql" or "webmin"

<snip>
baer@asgard:~ $ mysql -h asgard -u mambo --password=mambo mambo
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
</snip>

If you need further information, please inform me.

Regs
  Rob

Reproducible: Always
Steps to Reproduce:
1. # emerge mambo
2. # ebuild /var/db/pkg/www-apps/mambo-4.5/mambo-4.5.ebuild config
3. Fill in the values for the mysqldb

Actual Results:  
see the details sections

Expected Results:  
install mambo

[Comment 1 Alex Chapman 2004-11-19 21:50:25 UTC]

I got this problem too. You can fix it by changing line 83 of the ebuild, which reads:

mysqladmin -u ${MY_USER} ${host:+-h ${host}} -p create ${MY_DB} || die "Error creating database"

You need to change ${MY_USER} to ${adminuser}

[Comment 2 David D. Huff Jr. 2005-05-16 19:31:47 UTC]

Two new versions have been released with since the solution was provided below,
hopefully it will be corrected in the future.

Here's the solution agian:
"got this problem too. You can fix it by changing line 83 of the ebuild, which
reads:

mysqladmin -u ${MY_USER} ${host:+-h ${host}} -p create ${MY_DB} || die "Error
creating database"

You need to change ${MY_USER} to ${adminuser}"

BTW -- It still blows up if you have a hyphen in the domain name...

[Comment 3 Renat Lumpau (RETIRED) 2005-07-03 11:11:40 UTC]

Fixed in CVS, please test and reopen the bug if the problem persists.