Page 2 of 2
Re: Wizard is not working.
Posted: Wed Aug 19, 2015 9:28 am
by paulol
Follows the file.
Re: Wizard is not working.
Posted: Wed Aug 19, 2015 1:17 pm
by ssax
Looks like your postgresql DB is having issues, did you guys do any customization to the postgresql settings?
Try running a repair on it.
As root run the following:
Change to the postgres account:
Run these commands to single user fix the psql databases:
Code: Select all
postgres --single -D /var/lib/pgsql/data/ nagiosxi
backend> vacuum full
PRESS CTRL-D TO BREAK
postgres --single -D /var/lib/pgsql/data/ postgres
backend> vacuum full
PRESS CTRL-D TO BREAK
Then run these commands:
Then try the wizard again and let us know the results.
Re: Wizard is not working.
Posted: Wed Aug 19, 2015 1:55 pm
by paulol
No, I didnt.
I did everything you told me to do and the problem was not solved.
[root@DOUAI var]# service postgresql stop
Stopping postgresql service: [ OK ]
[root@DOUAI var]# su postgres
bash-4.1$ postgres --single -D /var/lib/pgsql/data/ nagiosxi
PostgreSQL stand-alone backend 8.4.20
backend> vacuum full
bash-4.1$ postgres --single -D /var/lib/pgsql/data/ postgres
PostgreSQL stand-alone backend 8.4.20
backend> vacuum full
[root@DOUAI var]# service postgresql start
Starting postgresql service: [ OK ]
Re: Wizard is not working.
Posted: Wed Aug 19, 2015 4:40 pm
by paulol
I enabled the parameter standard_conforming_strings on file postgresql.conf to ON and the following error stopped, but the wizards still doesn't work:
WARNING: nonstandard use of \\ in a string literal at character 98
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Re: Wizard is not working.
Posted: Thu Aug 20, 2015 9:08 am
by ssax
I think at this point we should move this into a ticket so that we can setup a remote session.
Please send an email to
[email protected] with a descriptive subject and the body detailing this issue with a link back to this thread.
Re: Wizard is not working.
Posted: Wed Aug 26, 2015 3:37 pm
by paulol
Sean you can close this thread the problem was already solved.
I found a file in /usr/my.cnf that was set this parameter.
[mysqld]
sql-mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
and i changed to :
[mysqld]
sql-mode = NO_ENGINE_SUBSTITUTION
Thx.
Re: Wizard is not working.
Posted: Wed Aug 26, 2015 3:44 pm
by hsmith
paulol wrote:Sean you can close this thread the problem was already solved.
I found a file in /usr/my.cnf that was set this parameter.
[mysqld]
sql-mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
and i changed to :
[mysqld]
sql-mode = NO_ENGINE_SUBSTITUTION
Thx.
Thank you for posting the resolution - we always appreciate the feedback.
Closing this one.