Password is contained in /opt/lcg/etc/DPMCONFIG .
Which version of the MySQL client and server are you using?
Once you log into the database, check the contents of the mysql.user table.
Greig
Dominic G. Wilson wrote:
> Hi all
>
> I sent this yesterday but the original seem to upset the list server so
> I have had to resend it today.
>
> I tried to upgrade our DPM today following Graeme on the storage blog.
> Yet thing seem to have gone wrong when I run the following I get
>
> /opt/glite/yaim/scripts/configure_node site-info.def SE_dpm_mysql
>
> INFO: Setting mysql password on lcgse1.shef.ac.uk.
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> Can not access MySQL DB, check password.
> ERROR: Error during the execution of config_DPM_mysql
>
> The problem is I can not work out where is is getting the username and
> password from. I did look at running the update script manually and all
> I get is
>
> ./dpm_support_srmv2.2 --db-vendor MySQL --db localhost --user dpm
> --pwd-file /tmp/pwd --dpns-db cns_db --dpm-db dpm_db --verbose
>
> failed to query and/or update the DPNS/DPM databases : DBI
> connect('cns_db:localhost','dpm',...) failed: Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client at Common.pm line 39
>
> I have tried looking round the wikies for help and I now completely
> lost. Can any one advise me please.
>
> Dominic
>
> --
> Corporate Information & Computing Services, University of Sheffield
> 285 Glossop Road, Sheffield, United Kingdom S10 2HB
> Voice: +44 114 22 23049 E-Mail: [log in to unmask]
|