Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 71289 - mambo fails to set up mysql correctly
Summary: mambo fails to set up mysql correctly
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: x86 Linux
: High normal (vote)
Assignee: Gentoo Web Application Packages Maintainers
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-11-15 08:21 UTC by Robert "Baer" Heine
Modified: 2005-07-03 11:11 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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: 'mambo@asgard.heim10.tu-clausthal.de' (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) gentoo-dev 2005-07-03 11:11:40 UTC
Fixed in CVS, please test and reopen the bug if the problem persists.