Dominic G. Wilson wrote:
> The mysql.user table looks fine but I'm not sure what I'm looking for.
Were there any entries in the table for the root user? How many
characters were in the password hash?
Greig
>
> 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]
>>
|