Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Marcin Haba]

Hi Lorraine,

That's great news. Thanks for letting us know that it started working on
the new vm.

Best regards,
Marcin Haba (gani)

On Thu, 3 Aug 2023 at 07:43, Lorraine 
wrote:

> Hi Marcin, I have ended up blowing away the vm and starting over.  This
> has allowed me to progress with the Install Wizard and I am  no longer
> getting the errors.
>
> Thanks again for all your help.  Not sure where I went wrong but just glad
> that I am able to move past this issue.
>
> Regards
> Lorraine
>
>
> On 3 Aug 2023, at 3:03 pm, Lorraine 
> wrote:
>
> Hi Marcin,  please see below output:
>
> [root@nbipbac12 httpd]# sudo -u apache sudo -l
> Matching Defaults entries for apache on nbipbac12:
> !visiblepw, always_set_home, match_group_by_gid,
> always_query_group_plugin, env_reset, env_keep="COLORS DISPLAY HOSTNAME
> HISTSIZE KDEDIR LS_COLORS", env_keep+="MAIL PS1
> PS2 QTDIR USERNAME LANG LC_ADDRESS LC_CTYPE", env_keep+="LC_COLLATE
> LC_IDENTIFICATION LC_MEASUREMENT LC_MESSAGES", env_keep+="LC_MONETARY
> LC_NAME LC_NUMERIC LC_PAPER
> LC_TELEPHONE", env_keep+="LC_TIME LC_ALL LANGUAGE LINGUAS _XKB_CHARSET
> XAUTHORITY", secure_path=/sbin\:/bin\:/usr/sbin\:/usr/bin, !requiretty
>
> User apache may run the following commands on nbipbac12:
> (root) NOPASSWD: /opt/bacula/bin/bconsole
> (ALL) NOPASSWD: ALL
>
> Also I tried the following without issue:
>
> [root@nbipbac12 httpd]# sudo -u apache sudo /opt/bacula/bin/bconsole
> Connecting to Director nbipbac02.local.netbi.net.au:9101
> 1000 OK: 10002 nbipbac02-dir Version: 13.0.3 (02 May 2023)
> Enter a period to cancel a command.
> *
>
> Regards
> Lorraine
>
>
> On 3 Aug 2023, at 2:01 pm, Marcin Haba  wrote:
>
> sudo -u apache sudo /opt/bacula/bin/bconsole
>
>
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au
> w: http://www.burgess-consulting.com.au
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
>
>
> 
>
>
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au
> w: http://www.burgess-consulting.com.au
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
>
>
>
>

-- 
"Greater love hath no man than this, that a man lay down his life for his
friends." Jesus Christ

"Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za
przyjaciół swoich." Jezus Chrystus
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Lorraine via Bacula-users]

Hi Marcin, I have ended up blowing away the vm and starting over.  This has 
allowed me to progress with the Install Wizard and I am  no longer getting the 
errors.

Thanks again for all your help.  Not sure where I went wrong but just glad that 
I am able to move past this issue.

Regards
Lorraine


> On 3 Aug 2023, at 3:03 pm, Lorraine  
> wrote:
> 
> Hi Marcin,  please see below output:
> 
> [root@nbipbac12 httpd]# sudo -u apache sudo -l
> Matching Defaults entries for apache on nbipbac12:
> !visiblepw, always_set_home, match_group_by_gid, 
> always_query_group_plugin, env_reset, env_keep="COLORS DISPLAY HOSTNAME 
> HISTSIZE KDEDIR LS_COLORS", env_keep+="MAIL PS1
> PS2 QTDIR USERNAME LANG LC_ADDRESS LC_CTYPE", env_keep+="LC_COLLATE 
> LC_IDENTIFICATION LC_MEASUREMENT LC_MESSAGES", env_keep+="LC_MONETARY LC_NAME 
> LC_NUMERIC LC_PAPER
> LC_TELEPHONE", env_keep+="LC_TIME LC_ALL LANGUAGE LINGUAS _XKB_CHARSET 
> XAUTHORITY", secure_path=/sbin\:/bin\:/usr/sbin\:/usr/bin, !requiretty
> 
> User apache may run the following commands on nbipbac12:
> (root) NOPASSWD: /opt/bacula/bin/bconsole
> (ALL) NOPASSWD: ALL
> 
> Also I tried the following without issue:
> 
> [root@nbipbac12 httpd]# sudo -u apache sudo /opt/bacula/bin/bconsole
> Connecting to Director nbipbac02.local.netbi.net.au:9101 
> 
> 1000 OK: 10002 nbipbac02-dir Version: 13.0.3 (02 May 2023)
> Enter a period to cancel a command.
> *
> 
> Regards
> Lorraine
> 
> 
>> On 3 Aug 2023, at 2:01 pm, Marcin Haba > > wrote:
>> 
>> sudo -u apache sudo /opt/bacula/bin/bconsole
> 
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au 
> 
> w: http://www.burgess-consulting.com.au 
> 
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
> 
> 
> 
> 

Burgess Systems Consulting
e: lorra...@burgess-consulting.com.au
w: http://www.burgess-consulting.com.au
m: +64-21-988-950
ddi: +61 2 8077 4296
Suite 802, 210 Clarence St, Sydney 2000, NSW




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Lorraine via Bacula-users]

Hi Marcin,  please see below output:

[root@nbipbac12 httpd]# sudo -u apache sudo -l
Matching Defaults entries for apache on nbipbac12:
!visiblepw, always_set_home, match_group_by_gid, always_query_group_plugin, 
env_reset, env_keep="COLORS DISPLAY HOSTNAME HISTSIZE KDEDIR LS_COLORS", 
env_keep+="MAIL PS1
PS2 QTDIR USERNAME LANG LC_ADDRESS LC_CTYPE", env_keep+="LC_COLLATE 
LC_IDENTIFICATION LC_MEASUREMENT LC_MESSAGES", env_keep+="LC_MONETARY LC_NAME 
LC_NUMERIC LC_PAPER
LC_TELEPHONE", env_keep+="LC_TIME LC_ALL LANGUAGE LINGUAS _XKB_CHARSET 
XAUTHORITY", secure_path=/sbin\:/bin\:/usr/sbin\:/usr/bin, !requiretty

User apache may run the following commands on nbipbac12:
(root) NOPASSWD: /opt/bacula/bin/bconsole
(ALL) NOPASSWD: ALL

Also I tried the following without issue:

[root@nbipbac12 httpd]# sudo -u apache sudo /opt/bacula/bin/bconsole
Connecting to Director nbipbac02.local.netbi.net.au:9101
1000 OK: 10002 nbipbac02-dir Version: 13.0.3 (02 May 2023)
Enter a period to cancel a command.
*

Regards
Lorraine


> On 3 Aug 2023, at 2:01 pm, Marcin Haba  wrote:
> 
> sudo -u apache sudo /opt/bacula/bin/bconsole

Burgess Systems Consulting
e: lorra...@burgess-consulting.com.au
w: http://www.burgess-consulting.com.au
m: +64-21-988-950
ddi: +61 2 8077 4296
Suite 802, 210 Clarence St, Sydney 2000, NSW




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Marcin Haba]

Hello Lorraine,

It is interesting. Thanks for your feedback. Internally to connect to
bconsole Bacularis does the same as this shell command does (adapted to
your problem):

# sudo -u apache sudo /opt/bacula/bin/bconsole

The 'sudo -u apache' switches user to 'apache' user to be the same user as
PHP user. Once we are the 'apache' user then the regular sudo command is
executed 'sudo /opt/bacula/bin/bconsole'.

If the above command will work, then Bacularis will work the same
automatically.

Could you show us the output from this command?

# sudo -u apache sudo -l

It will list allowed commands for the apache user. Thanks.

Good luck.

Best regards,
Marcin Haba (gani)

On Thu, 3 Aug 2023 at 01:47, Lorraine 
wrote:

> Morning Marcin, Thank you for the update.
> I tried the alternate sudo entry but still had no luck.  I also set
> "SELINUX=disabled”  in /etc/selinux/config but nothing seems to get past
> this error.
> I will continue to troubleshoot and let you know if I find anything.
>
> Regards
> Lorraine
>
> On 3 Aug 2023, at 7:59 am, Marcin Haba  wrote:
>
> Hello Lorraine,
>
> In your Bacularis sudoers file you use switching from apache user to
> bacula user. It is correct but unfortunately Bacularis does not support it.
> To work with this setting Bacularis needs to know about bacula user and use
> internally "sudo -u bacula" sudo parameter to let know sudo about target
> user.
>
> If you want you can omit the bacula user in sudo and then will be used the
> default target user which is root.
>
> Defaults:apache !requiretty
> apache ALL = NOPASSWD: /opt/bacula/bin/bconsole
>
> In the future we will add support for -u sudo parameter.
>
> Best regards,
> Marcin Haba (gani)
>
> On Wed, 2 Aug 2023 at 08:43, Lorraine 
> wrote:
>
>> Hi, Yes I installed the following:
>>
>> [root@nbipbac12 bin]# yum list installed | grep bacularis-selinux
>> bacularis-selinux.noarch   2.1.2-1.el8
>>   @bacularis-app
>>
>> Regards
>> Lorraine
>>
>>
>>
>>
>> On 2 Aug 2023, at 6:16 pm, Marcin Haba  wrote:
>>
>> SELinux
>>
>>
>> Burgess Systems Consulting
>> e: lorra...@burgess-consulting.com.au
>> w: http://www.burgess-consulting.com.au
>> m: +64-21-988-950
>> ddi: +61 2 8077 4296
>> Suite 802, 210 Clarence St, Sydney 2000, NSW
>>
>>
>> 
>>
>>
>
> --
> "Greater love hath no man than this, that a man lay down his life for his
> friends." Jesus Christ
>
> "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za
> przyjaciół swoich." Jezus Chrystus
>
>
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au
> w: http://www.burgess-consulting.com.au
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
>
>
>
>

-- 
"Greater love hath no man than this, that a man lay down his life for his
friends." Jesus Christ

"Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za
przyjaciół swoich." Jezus Chrystus
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Lorraine via Bacula-users]

Morning Marcin, Thank you for the update.  
I tried the alternate sudo entry but still had no luck.  I also set 
"SELINUX=disabled”  in /etc/selinux/config but nothing seems to get past this 
error.
I will continue to troubleshoot and let you know if I find anything.

Regards
Lorraine

> On 3 Aug 2023, at 7:59 am, Marcin Haba  wrote:
> 
> Hello Lorraine,
> 
> In your Bacularis sudoers file you use switching from apache user to bacula 
> user. It is correct but unfortunately Bacularis does not support it. To work 
> with this setting Bacularis needs to know about bacula user and use 
> internally "sudo -u bacula" sudo parameter to let know sudo about target user.
> 
> If you want you can omit the bacula user in sudo and then will be used the 
> default target user which is root.
> 
> Defaults:apache !requiretty
> apache ALL = NOPASSWD: /opt/bacula/bin/bconsole
> 
> In the future we will add support for -u sudo parameter.
> 
> Best regards,
> Marcin Haba (gani)
> 
> On Wed, 2 Aug 2023 at 08:43, Lorraine  > wrote:
> Hi, Yes I installed the following:
> 
> [root@nbipbac12 bin]# yum list installed | grep bacularis-selinux
> bacularis-selinux.noarch   2.1.2-1.el8
>  @bacularis-app
> 
> Regards
> Lorraine
> 
> 
> 
> 
>> On 2 Aug 2023, at 6:16 pm, Marcin Haba > > wrote:
>> 
>> SELinux
> 
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au 
> 
> w: http://www.burgess-consulting.com.au 
> 
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
> 
> 
> 
> 
> 
> 
> -- 
> "Greater love hath no man than this, that a man lay down his life for his 
> friends." Jesus Christ
> 
> "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za 
> przyjaciół swoich." Jezus Chrystus

Burgess Systems Consulting
e: lorra...@burgess-consulting.com.au
w: http://www.burgess-consulting.com.au
m: +64-21-988-950
ddi: +61 2 8077 4296
Suite 802, 210 Clarence St, Sydney 2000, NSW




___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Baculum with postgresql-15 SQLSTATE[42804]: Datatype mismatch

[Marcin Haba]

Hello Lorraine,

In your Bacularis sudoers file you use switching from apache user to bacula
user. It is correct but unfortunately Bacularis does not support it. To
work with this setting Bacularis needs to know about bacula user and use
internally "sudo -u bacula" sudo parameter to let know sudo about target
user.

If you want you can omit the bacula user in sudo and then will be used the
default target user which is root.

Defaults:apache !requiretty
apache ALL = NOPASSWD: /opt/bacula/bin/bconsole

In the future we will add support for -u sudo parameter.

Best regards,
Marcin Haba (gani)

On Wed, 2 Aug 2023 at 08:43, Lorraine 
wrote:

> Hi, Yes I installed the following:
>
> [root@nbipbac12 bin]# yum list installed | grep bacularis-selinux
> bacularis-selinux.noarch   2.1.2-1.el8
> @bacularis-app
>
> Regards
> Lorraine
>
>
>
>
> On 2 Aug 2023, at 6:16 pm, Marcin Haba  wrote:
>
> SELinux
>
>
> Burgess Systems Consulting
> e: lorra...@burgess-consulting.com.au
> w: http://www.burgess-consulting.com.au
> m: +64-21-988-950
> ddi: +61 2 8077 4296
> Suite 802, 210 Clarence St, Sydney 2000, NSW
>
>
>
>

-- 
"Greater love hath no man than this, that a man lay down his life for his
friends." Jesus Christ

"Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za
przyjaciół swoich." Jezus Chrystus
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Problem with grant_mysql_privileges

[Phil Stracchino]

On 8/2/23 13:43, Martin Simmons wrote:

It looks like a bug in the script to me (maybe % instead of $):

if $bindir/mysql $* -u root -f <

You are absolutely right, Martin, I totally looked past that.


--
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958



___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Problem with grant_mysql_privileges

[Martin Simmons]

> On Wed, 2 Aug 2023 12:21:49 -0400, Phil Stracchino said:
> 
> On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:
> > Hello
> > 
> > I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I 
> > run
> > grant_mysql_privileges:
> > 
> > ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check 
> > the
> > manual that corresponds to your MariaDB server version for the right syntax 
> > to
> > use near '%{db_user}@"%"' at line 1
> > 
> > Database version 10.6.14-MariaDB
> > 
> > I guess it's complaining about the statement
> > 
> > db_user=${db_user:-bacula}
> > 
> > Can anyone help with this please?
> 
> 
> What does the line 'echo "Created MySQL database user: ${db_user}"' 
> report as the value of ${db_user}?

It looks like a bug in the script to me (maybe % instead of $):

if $bindir/mysql $* -u root -f 

Re: [Bacula-users] Problem with grant_mysql_privileges

[Phil Stracchino]

On 8/2/23 11:12, Graham Dicker via Bacula-users wrote:

Hello

I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I run
grant_mysql_privileges:

ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near '%{db_user}@"%"' at line 1

Database version 10.6.14-MariaDB

I guess it's complaining about the statement

db_user=${db_user:-bacula}

Can anyone help with this please?



What does the line 'echo "Created MySQL database user: ${db_user}"' 
report as the value of ${db_user}?




--
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958



___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Problem with grant_mysql_privileges

[Graham Dicker via Bacula-users]

Hello

I am installing Bacula 13.0.2 on Opensuse 15.5 and get this problem when I run 
grant_mysql_privileges:

ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the 
manual that corresponds to your MariaDB server version for the right syntax to 
use near '%{db_user}@"%"' at line 1

Database version 10.6.14-MariaDB

I guess it's complaining about the statement

db_user=${db_user:-bacula}

Can anyone help with this please?

Graham Dicker


signature.asc
Description: This is a digitally signed message part.
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users