On 27 April 2011 14:59, Govind Songara <[log in to unmask]> wrote:
> Hi,
>
> I have updated the headnode from DPM 1.7.3 to DPM 1.8.0.1.
> While running yaim it give error for mysql config.
>
> /opt/glite/yaim/bin/yaim -r -d 6 -s site-info.def -n glite-SE_dpm_mysql -f
> config_DPM_upgrade_mysql
>
> INFO: Executing function: config_DPM_upgrade_mysql_check
> DEBUG: Skipping function: config_DPM_upgrade_mysql_setenv because it is
> not defined
> INFO: Executing function: config_DPM_upgrade_mysql
> INFO: Checking for database schema version...
> ERROR: No DPM database schema version information found. Exiting.
> ERROR: Error during the execution of function: config_DPM_upgrade_mysql
> ERROR: Error during the
> configuration.Exiting. [FAILED]
> ERROR: One of the functions returned with error without specifying it's
> nature !
>
...that's exceptionally interesting.
The function that is failing is trying to do this:
mysql --skip-column-names -s -h ${DPM_DB_HOST} -u ${DPM_DB_USER}
--pass="${DPM_DB_PASSWORD}" -e "use ${DPM_DB}; select * from
schema_version_dpm;" 2> /dev/null
and apparently failing. Unfortunately, we don't get any useful
reporting of the error message from the mysql command, so it's hard to
tell which way it is breaking.
So, try running that command on your SE, substituting the values of
the $DPM_DB_HOST, DPM_DB_USER and PASSWORD appropriately and see what
happens.
(Possibilities: your configuration as specified in your yaim config is
wrong, so it can't access the db; there's something wrong with the
schema_version_dpm table in your DPM database; your mysql server isn't
running.)
Sam
> Can you please suggest how to move further from here
>
> Thanks
> Govind
>
|