#1 Setup_beancounter working. Won't connect to mysqldb.

[David Babcock]

Hello,

Got MySql setup and ran setup_beancounter:
****************
setup_beancounter -m
Now using MySQL

*** Error: No mysql user 'decibels'

We were unable to start mysql as the user 'decibels'
does not exist
You need to create a MySQL user 'decibels' first:

Change to super user (MySQL Admin): $ su -
Start mysql program with mysql db: # mysql mysql
Create the user: grant all privileges on *.*
to decibels@localhost;
Exit from user mysql: > \q
Exit from super user: # exit

and then run this script again.
*****************
1) Showing mysqldb is created ( I was also logged in as
user 'decibels' to mysql when did this):

mysql> show databases\g
+----------+
| Database |
+----------+
| mysql |
| test |
+----------+
2 rows in set (0.00 sec)

2) I also used the password created for decibels as the
MySQL password, so shows I have superuser access.

# mysqlaccess decibels mysql -P
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier@rug.ac.be)
Changes by Steve Harvey (sgh@vex.net)
This software comes with ABSOLUTELY NO WARRANTY.
Password for MySQL superuser :

Access-rights
for USER 'decibels', from HOST 'localhost', to DB 'mysql'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | Shutdown_priv | Y |
| Insert_priv | Y | | Process_priv | Y |
| Update_priv | Y | | File_priv | Y |
| Delete_priv | Y | | Grant_priv | Y |
| Create_priv | Y | | References_priv | Y |
| Drop_priv | Y | | Index_priv | Y |
| Reload_priv | Y | | Alter_priv | Y |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `decibels' :-(

The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in
db-table.'
user :
'localhost','decibels','25c1ad4b2a3d9186','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'

BUGs can be reported by email to bugs@mysql.com

3) I edited the .beancounterrc, and put my password in
there, but seems like the problem is that it isn't
reading it when start setup_beancounter.

I don't know what else the problem could be I have all
the privilages and access, password is in the
.beancounterrc file in ~/ folder.

Any help?

Thanks in advance.

[David Babcock]

Logged In: YES
user_id=464357

Finally got it work, now mozilla is killing the keyboard
only in mozilla, so have had to retype this three times.

Okay, had to make the 'user' entry to MySQL passwordless.
Even though had the the password in ~/.beancounterrc it
wasn't working.
So: # mysqladmin -u david -p password ''
That allowed me to enter it without password.
Ran setup_beancounter again after deleting the beancounter db.
It still failed cause the password was in the .beancounterrc.
So deleted that part and it worked.

Has scrolled past the part but believe it said, now that it
read the
.beancounterrc that the password was '/decibels/' .
That was when the password was still in there and it failed.
I didn't have the slashes in there, maybe that is why it has
failed.
On second thought, maybe I had 'decibels' and that is why it
did it?

I will test that out and post back if that is what happened.

[David Babcock]

Logged In: YES
user_id=464357

Recreated the password and checked to see it took. Okay.
Put it back in .beancounterrc without the ' ' on the ends.
Didn't work, said there wasn't a user by that name.

Took the password back out of MySQL and checked to make
sure. Okay.

Showed password when running setup_beancounter this time as
'decibels' instead of '/decibels/' and ran.

Password in ~/.beancounterrc does not seem to work correctly.

Have to use a passwordless db.

[David Babcock]

Logged In: YES
user_id=464357

Seems like a great program, can't wait to play with it and
see it's potential.

I do have another think on the passwords.
Ran: $ beancounter quotes IBM
It show the contents of .beancounterrc thereby showing the
password on the screen in text.

Also says this:
Database has schema 0.6.2, we require version 0.6.0
Which make me wonder if it will even work correctly, going
to have to see.