server version: 4.1.11-standard
mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i686)
The mysql.user table looks fine but I'm not sure what I'm looking for.
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]
Quoting Greig Alan Cowan <[log in to unmask]>:
> 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]
>
