king AT computerking DOT ca wrote:
> Hello all i am having database problems again, have recently updated to 
> Bacula version 3.0.2 (installed from source on ubuntu 8.04). Tried to run 
> /etc/bacula/update_mysql_tables and got this error
>
> This script will update a Bacula MySQL database from version 10 to 11
>  which is needed to convert from Bacula version 2.0.x to 3.0.x or higher
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO)
> Update of Bacula MySQL tables failed.
>
> So then i tried to pass the script to mysql like this still did not work
>
> mysql bacula -ubacula -pbacula < /etc/bacula/update_mysql_tables
> ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the 
> manual that corresponds to your MySQL server version for the right syntax to 
> use near 'echo " "
> echo "This script will update a Bacula MySQL database from version 10 t' at 
> line 1
>
> Can i run the script from within mysql? seem to remember that being an unwise 
> thing to do!  However i do not know how to get bacula's database updated! 
> need pass a username and password to the script somehow? 
>
> Please help
>  
>   
Any arguments you pass to the update script are passed blindly on to 
mysql, so if you use the -u and -p options to log in to mysql, you need 
to use those same arguments for the update script, like so:

/etc/bacula/update_mysql_tables -u bacula -pbacula

- Cedric



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users