I do not know much about MySql databases. How do I remove the password? And is that safe?


----Original Message Follows----
From: Jeremy Enos <[EMAIL PROTECTED]>
To: "Christopher Oubre" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: [Oscar-users] failed to create database for user Oscar (Problems installing OSCAR 3.0)
Date: Tue, 20 Apr 2004 14:50:03 -0500


Interesting... on an existing cluster where I used a blank password and everything worked...

I tried entering a password when prompted. It bombed. I expected this, because my password to the DB should be blank, as it was when I started.

So I ran the wizard again, and this time used a blank password as I had originally. Here's what I didn't expect. It bombed... w/o even making it to the password prompt.
Neil-
any idea here?


Jeremy

At 03:52 PM 4/19/2004, Christopher Oubre wrote:
I have tried a fresh install from Red Hat 9.0 cds and unfortunately I get the exact same error. Can some one please help. I'll restart the problem

1) I install stock Red Hat 9.0 from CDs
2) I configure both NICs
3) I copied all of the rpms to /tftpboot/rpm
4) I unzip / untar oscar 3.0
5) I run ./configure
6) I run make install
7) I cd to /opt/oscar and type ./install_cluster eth0
8) It asked me for a mysql password, I entered one
9) It bombs. here is the end of the output
...
--> Initializing ODA database from package config.xml files
Starting the mysql database server ...
LC_ALL=EN;/etc/init.d/mysqld start
Starting MySQL: [ OK ]
Making sure that the mysql database server starts on subsequent boots ...
LC_ALL=EN;chkconfig mysqld on
[EMAIL PROTECTED] oscar]# Creating the OSCAR database ...
/opt/oscar/scripts/package_config_xmls_to_database: failed to create database for user oscar:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /opt/oscar/scripts/package_config_xmls_to_database line 232.
/opt/oscar/scripts/package_config_xmls_to_database: cannot create the OSCAR database at /opt/oscar/scripts/package_config_xmls_to_database line 233.
Couldn't set up oda database at ./wizard_prep line 172
Oscar Wizard preparation script failed to complete at ./install_cluster line 124.



What do I try next?


----Original Message Follows----
From: "Bernard Li" <[EMAIL PROTECTED]>
To: "Chris Oubre" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: RE: [Oscar-users] failed to create database for user Oscar (Problems installing OSCAR 3.0)
Date: Thu, 1 Apr 2004 15:56:59 -0800


Hi Chris:

I am cc: ing oscar-users so that other users can also 'learn' from this
experience.

You seem to be using a newer mysql version than the stock one which
comes from RH9.0 (3.23.54)- I would really recommend you try to install
OSCAR on a stock RH9.0 install before trying anything else to weed out
any strange errors you might be encountering.

Cheers,

Bernard

> -----Original Message-----
> From: Chris Oubre [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 01, 2004 15:53
> To: Bernard Li
> Subject: RE: [Oscar-users] failed to create database for user
> Oscar (Problems installing OSCAR 3.0)
>
> This works
> mysql -u oscar -pPASSWORD
>
> [EMAIL PROTECTED] oscar]# mysql -u root
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 40 to server version: 3.23.58
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use mysql;
> Reading table information for completion of table and column
> names You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql>  select * from user where user="oscar";
> +-----------+-------+------------------+-------------+--------
> -----+----
> +-----------+-------+------------------+-------------+--------
> -----+----
> -----+-------------+-------------+-----------+-------------+--
> -------------+
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> -------+
> | Host      | User  | Password         | Select_priv | Insert_priv |
> Update_priv | Delete_priv | Create_priv | Drop_priv |
> Reload_priv | Shutdown_priv | Process_priv | File_priv |
> Grant_priv | References_priv | Index_priv | Alter_priv |
> +-----------+-------+------------------+-------------+--------
> -----+----
> +-----------+-------+------------------+-------------+--------
> -----+----
> -----+-------------+-------------+-----------+-------------+--
> -------------+
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> -------+
> | localhost | oscar | 721df6c33224a300 | N           | N           | N
> | N           | N           | N         | N           | N
>         | N
> | N         | N          | N               | N          | N          |
> +-----------+-------+------------------+-------------+--------
> -----+----
> +-----------+-------+------------------+-------------+--------
> -----+----
> -----+-------------+-------------+-----------+-------------+--
> -------------+
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> --------------+-----------+------------+-----------------+----
> --------+-
> -------+
> 1 row in set (0.00 sec)
>
>
>
> I am not familur with mysql so I do not know if anything is
> funny here.  I will try the uninstall method next.
> -----Original Message-----
> From: Bernard Li [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 01, 2004 5:36 PM
> To: Chris Oubre
> Cc: [EMAIL PROTECTED]
> Subject: RE: [Oscar-users] failed to create database for user
> Oscar (Problems installing OSCAR 3.0)
>
>
> Hey Chris:
>
> This seems strange...
>
> How about if you do:
>
> % mysql -u oscar -pPASSWORD ?
>
> I have a few recommendations as to what you can try out, as
> this obviously
> seems like a MySQL problem:
>
> 1) log in as root and check the users table in mysql db:
>
> mysql> use mysql;
> mysql> select * from user where user="oscar";
>
> To see if any thing is funny...
>
> 2) un-install the mysqldb RPM and re-run the install_cluster
> script (it
> should re-install the mysql rpm if it is not already installed)
>
> 3) run scripts/start_over and try to install the cluster again
>
> Good luck,
>
> Bernard
>
>

_________________________________________________________________
From must-see cities to the best beaches, plan a getaway with the Spring Travel Guide! http://special.msn.com/local/springtravel.armx




-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Oscar-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/oscar-users

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.com/go/onm00200415ave/direct/01/




-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Oscar-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/oscar-users

Reply via email to