I am having the same issue with Core 2.0.0 on Debian 4.0. I have installed with
and without a root password during the install. I have tried a remote MySQL
server and on a local server and both will create the DB and the zenoss user
but never any tables.
The only thing I can find in the install logs are below:
ERROR 1074 (00000) at line 1: Too big column length for column 'message' (max =
255). Use BLOB instead
loading stored procedures
ERROR 1064 (00000) at line 2: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'PROCEDURE IF EXISTS age_events' at line 1
events database created and loaded
And this info in the Console:
Type: ProgrammingError
Value: (1146, "Table 'events.status' doesn't exist")
Traceback (innermost last):
* Module ZPublisher.Publish, line 114, in publish
* Module ZPublisher.mapply, line 88, in mapply
* Module ZPublisher.Publish, line 40, in call_object
* Module Shared.DC.Scripts.Bindings, line 311, in __call__
* Module Shared.DC.Scripts.Bindings, line 348, in _bindAndExec
* Module Products.CMFCore.FSPageTemplate, line 195, in _exec
* Module Products.CMFCore.FSPageTemplate, line 134, in pt_render
* Module Products.PageTemplates.PageTemplate, line 104, in pt_render
<FSPageTemplate at /zport/editEventManagerFields used for
/zport/dmd/ZenEventManager>
* Module TAL.TALInterpreter, line 206, in __call__
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 711, in do_useMacro
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 711, in do_useMacro
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 734, in do_defineSlot
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 734, in do_defineSlot
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 677, in do_condition
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 711, in do_useMacro
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 734, in do_defineSlot
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 426, in do_optTag_tal
* Module TAL.TALInterpreter, line 411, in do_optTag
* Module TAL.TALInterpreter, line 406, in no_tag
* Module TAL.TALInterpreter, line 250, in interpret
* Module TAL.TALInterpreter, line 651, in do_loop_tal
* Module Products.PageTemplates.TALES, line 206, in setRepeat
* Module Products.PageTemplates.TALES, line 221, in evaluate
URL: file:ZenEvents/skins/zenevents/editEventManagerFields.pt
Line 135, Column 16
Expression: <PythonExpr [x for x in here.getFieldList() if x not in
here.defaultResultFields]>
Names:
{'container': <ZentinelPortal at /zport>,
'context': <MySqlEventManager at /zport/dmd/ZenEventManager>,
'default': <Products.PageTemplates.TALES.Default instance at 0xb74c0fec>,
'here': <MySqlEventManager at /zport/dmd/ZenEventManager>,
'loop': <Products.PageTemplates.TALES.SafeMapping object at 0xb38e41ec>,
'modules': <Products.PageTemplates.ZRPythonExpr._SecureModuleImporter
instance at 0xb74c622c>,
'nothing': None,
'options': {'args': ()},
'repeat': <Products.PageTemplates.TALES.SafeMapping object at
0xb38e41ec>,
'request': <HTTPRequest,
URL=http://192.168.0.4:8080/zport/dmd/ZenEventManager/editEventManagerFields>,
'root': <Application at >,
'template': <FSPageTemplate at /zport/editEventManagerFields used for
/zport/dmd/ZenEventManager>,
'traverse_subpath': [],
'user': admin}
* Module Products.PageTemplates.ZRPythonExpr, line 47, in __call__
__traceback_info__: [x for x in here.getFieldList() if x not in
here.defaultResultFields]
* Module Python expression "[x for x in here.getFieldList() if x not in
here.defaultResultFields]", line 1, in <expression>
* Module Products.ZenEvents.EventManagerBase, line 1082, in getFieldList
* Module Products.ZenEvents.EventManagerBase, line 1193, in loadSchema
* Module MySQLdb.cursors, line 137, in execute
* Module MySQLdb.connections, line 33, in defaulterrorhandler
ProgrammingError: (1146, "Table 'events.status' doesn't exist")
-------------------- m2f --------------------
Read this topic online here:
http://community.zenoss.com/forums/viewtopic.php?p=8219#8219
-------------------- m2f --------------------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
