Can not logon to Zenoss

[slingeland]

slingeland [http://community.zenoss.org/people/slingeland] created the discussion

"Can not logon to Zenoss"

To view the discussion, visit: http://community.zenoss.org/message/73920#73920

--------------------------------------------------------------
Hi,

I have a problem that i cant solve and really hope to get some help. I have spent a few days to add devices and configure events and after a reboot i can not longer logon to the system.

OS: CentOS release 6.4 (Final)
Zenoss: 4.2.3 scripted installation

When i try to logon i get the following error message:
*Type: <class 'zenoss.protocols.services.ServiceResponseError'>*
*Value: Service Unavailable*
Traceback (most recent call last): File "/opt/zenoss/lib/python/ZPublisher/Publish.py", line 126, in publish request, bind=1)


After some digging in the forum i was pointed to the log file zeneventserver.log where i found the following error

[main] ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE event_time PARTITION BY RANGE(processed) (PARTITION p20130711_130000 VALUES LESS THAN(1373547600000),PARTITION p20130711_140000 VALUES LESS THAN(1373551200000))]; SQL state [HY000]; error code [1017]; Can't find file: 'event_time' (errno: 2); nested exception is java.sql.SQLException: Can't find file: 'event_time' (errno: 2)

How can i solve this problem??

Thanks
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73920#73920]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[slingeland]

slingeland [http://community.zenoss.org/people/slingeland] created the discussion

"Re: Can not logon to Zenoss"

To view the discussion, visit: http://community.zenoss.org/message/73926#73926

--------------------------------------------------------------
It is finally up and running :^0
Not sure if this is the right way to do it, but i droped the table event_time and recreated it from an old backup.
Seams to work fine now
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73926#73926]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]