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

2023-08-02 Thread 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 Instal

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

2023-08-02 Thread 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

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

2023-08-02 Thread 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

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

2023-08-02 Thread 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 P

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

2023-08-02 Thread 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 2

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

2023-08-02 Thread 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 a

Re: [Bacula-users] Problem with grant_mysql_privileges

2023-08-02 Thread 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 L

Re: [Bacula-users] Problem with grant_mysql_privileges

2023-08-02 Thread 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 ha

Re: [Bacula-users] Problem with grant_mysql_privileges

2023-08-02 Thread 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 versio

[Bacula-users] Problem with grant_mysql_privileges

2023-08-02 Thread 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