----- "Radosław Korzeniewski" <[email protected]> wrote:
Hi, 2010/5/18 RYAN vAN GINNEKEN < [email protected] > ./bweb-mysql.sql: line 1: --: command not found ./bweb-mysql.sql: line 2: --: command not found ./bweb-mysql.sql: line 3: --: command not found ./bweb-mysql.sql: line 8: syntax error near unexpected token `(' ./bweb-mysql.sql: line 8: `CREATE FUNCTION base64_decode_lstat (field INTEGER, input BLOB)' Pointed above bweb-mysql.sql script is not a regular shell script, so you can't execute it this way. You have to supply it into mysql client program/command. Use man mysql to check what options will be sufficient in your enviroment. Ok Thank you very much for the tip i have made some progress now sort of I logged into mysql as the root user and ran the script like below however it seems all the tables and such are already there so i do not think the database is the problem. However when i turn security on i still get locked out, what is going on????????? how do I create users I do not see any option in the bweb interface??????? mysql> source bweb-mysql.sql Query OK, 0 rows affected (0.16 sec) Query OK, 0 rows affected (0.01 sec) ERROR 1050 (42S01): Table 'brestore_knownjobid' already exists ERROR 1050 (42S01): Table 'brestore_pathhierarchy' already exists ERROR 1061 (42000): Duplicate key name 'brestore_pathhierarchy_ppathid' ERROR 1050 (42S01): Table 'brestore_pathvisibility' already exists ERROR 1061 (42000): Duplicate key name 'brestore_pathvisibility_jobid' ERROR 1050 (42S01): Table 'bweb_user' already exists ERROR 1061 (42000): Duplicate key name 'bweb_user_idx' ERROR 1050 (42S01): Table 'bweb_role' already exists ERROR 1061 (42000): Duplicate key name 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_user_mgnt' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_group_mgnt' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_configure' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_autochanger_mgnt' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_location_mgnt' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_storage_mgnt' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_delete_job' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_prune' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_purge' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_job' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_log' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_stat' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_media' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_group' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_view_running_job' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_run_job' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_cancel_job' for key 'bweb_role_idx' ERROR 1062 (23000): Duplicate entry 'r_client_status' for key 'bweb_role_idx' ERROR 1050 (42S01): Table 'bweb_role_member' already exists ERROR 1050 (42S01): Table 'bweb_client_group_acl' already exists ERROR 1050 (42S01): Table 'client_group' already exists ERROR 1061 (42000): Duplicate key name 'client_group_idx' ERROR 1050 (42S01): Table 'client_group_member' already exists ERROR 1061 (42000): Duplicate key name 'client_group_member_idx' bye -- Radosław Korzeniewski [email protected]
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
