Bacula-users

Re: [Bacula-users] Bweb access levels for different users

2009-03-27 11:26:47
Subject: Re: [Bacula-users] Bweb access levels for different users
From: Alex F <alexxzell AT yahoo DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 27 Mar 2009 08:18:17 -0700 (PDT)
Hello again,
I feel that I should rephrase the problem and give more details.
First of all, I made a mistake:
to activate the security feature, you must modify /etc/bacula/bweb.conf (given a default installation) and then change "'enable_security' => 0," to "'enable_security' => 1,".

To log into bweb I use a .htaccess and .htpasswd. Bweb recognizes with what user I log in because it says  "Logged as user1" in the top right corner. If I change enable_security to 1, it will give me: "user1 sorry, but this action (r_view_running_job) is not permited. Check security with your administrator", with the following message in /var/log/httpd/error_log:
"[error] DBD::mysql::db selectall_arrayref failed: Table 'bacula.bweb_user' doesn't exist at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bweb.pm line 1100., referer: xxx."

Note that in the following few examples, enable_security is set to 0.

While browsing through Bweb.pm I found the following lines:
} elsif ($action eq 'user_del') {
    $bweb->users_del();

} elsif ($action eq 'user_add') {
    $bweb->users_add();

} elsif ($action eq 'user_edit') {
    $bweb->display_user();

} elsif ($action eq 'user_save') {
    $bweb->users_add();

} elsif ($action eq 'users') {
    $bweb->display_users();

..so I thought I'd check them. http://xxxx/cgi-bin/bweb/bweb.pl?action="" gives me a nice interface from where I could add users. I complete the form, and after I hit Save, it tells me: "An error has occurred: Can't use users with bweb, read INSTALL to enable them". Well, bad move Eric[1], because there is no reference to this in the INSTALL.

Furthermore, in the error_log i get:
*DBD::mysql::db selectall_hashref failed: Table 'bacula.client_group' doesn't exist at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bweb.pm line 1135.
*DBD::mysql::db selectall_hashref failed: Table 'bacula.bweb_user' doesn't exist at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bweb.pm line 1135.
*DBD::mysql::db selectall_hashref failed: Table 'bacula.bweb_role' doesn't exist at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bweb.pm line 1135.

*DBD::mysql::db do failed: Table 'bacula.bweb_user' doesn't exist at .../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *DBD::mysql::db do failed: Table 'bacula.bweb_user' doesn't exist at.../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *Table 'bacula.bweb_role_member' doesn't exist at .../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *DBD::mysql::db do failed: Table 'bacula.bweb_client_group_acl' doesn't exist at .../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *Use of uninitialized value in concatenation (.) or string at .../Bweb.pm line 2826., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *DBD::mysql::db do failed: 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 '), referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *AND username IN ('test1')' at line 3 at .../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *Use of uninitialized value in concatenation (.) or string at .../Bweb.pm line 2941., referer: http://xxx/cgi-bin/bweb/bweb.pl?action="">
*DBD::mysql::db do failed: 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 '), referer: http://xxx/cgi-bin/bweb/bweb.pl?action="">    AND username = 'test1'' at line 4 at .../Bweb.pm line 1126., referer: http://xxx/cgi-bin/bweb/bweb.pl?action=""> *DBD::mysql::db selectall_hashref failed: Table 'bacula.bweb_user' doesn't exist at .../Bweb.pm line 1135., referer: http://xxx/cgi-bin/bweb/bweb.pl?action="">
I also attached some screenshots.. maybe you want to take a look.

Please help.
Thanks.










--- On Thu, 3/26/09, Alex F wrote:

In the configuration menu of BWEB I enabled the security feature because I want different users to have different levels of access to the bweb interface. But now I get: "test" sorry, but this action (r_configure) is not permited. Check security with your administrator.
BTW, "test" is the user with which I login.
Now, in the error log i get:
[error] DBD::mysql::db selectall_arrayref failed: Table 'bacula.bweb_user' doesn't exist at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bweb.pm line 1100., referer: xxx. I understand that I need to create the  bacula.bweb_user table, but I do not know what it should contain. And how do I select what kind of access a user has to bweb?


Attachment: user_add.JPG
Description: JPEG image

Attachment: users.JPG
Description: JPEG image

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>