Wizard is not working.

[paulol]

Follows the file.

[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:

Code: Select all

service postgresql stop

Change to the postgres account:

Code: Select all

su postgres

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:

Code: Select all

exit
service postgresql start

Then try the wizard again and let us know the results.

[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 ]

[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'\\'.

[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.

[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.

[hsmith]

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.