Hi,

2010/5/18 RYAN vAN GINNEKEN <king AT computerking DOT ca>

./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
radoslaw AT korzeniewski DOT net