I am trying to get the mysql-administrator scheduled backups to work under Fedora core 3 and am having a problem. The message that comes from cron is:
(mysql-administrator-bin:7760): Gtk-WARNING **: cannot open display:
When I try to run the command by hand It opens a dialog asking to login.
The lines added to cron are:
#--------------------------------------------------------------------------------
#MySQL Administrator Backup [profile] (do not change this line)
0 16 * * * /usr/bin/mysql-administrator -bpprofile -bt/misc/MySql-Backups -bxeventum_ -cfrodo-root
I have updated the pereferences in mysql-administrator to save passwords. I have tried to set it to store the passwords as obscured but every time I enter the dialog it appears to be reset back to "plain-text". I don't know how it is really set. Here is the xml file with the configuration:
<?xml version="1.0"?>
<application_options>
<group name="general">
<property name="connections_filename" value="mysqlx_user_connections.xml"/>
<property name="password_storage_type" value="3"/>
</group>
<group name="administrator">
<property name="show_user_global_privileges" value="yes"/>
<property name="show_user_table_column_privileges" value="no"/>
<property name="last_backup_directory" value="/root"/>
<property name="disable_backup_timestamps" value="no"/>
</group>
</application_options>
Any assistance would be appreciated.