![]() |
![]() |
Subject: | "Unable to create the initial Zenoss object database" error |
Author: | [Not Specified] |
Posted: | 2015-02-24 10:08 |
Okay, I just beat my head against a rock for many hours getting past the infamous root/mysql permissions issues with the zenoss 4.2.5 during the installation process on a CentOS 6.3 host. Now I am getting a "Unable to create the initial Zenoss object database" error when attempting to start the servive (See output below).
So, traversing through the zenoss scripts, I ran the following command using "bash -x":
[root@Zenoss bin]# bash -x ./zenoss_init_pre
Which ultimately produced this error:
ERROR 1045 (28000): Access denied for user 'zenoss'@'localhost' (using password: YES)
ERROR:zen.zendb:Error executing command: ['mysql', '--batch', '--skip-column-names', '--user=zenoss', '--host=localhost', '--port=3306', '--database=zodb']
Can anyone tell me what the zenoss user's mysql password is set to initially, or how to circumvent this error
[root@Zenoss bin]# service zenoss start
Zenoss not initialized. Performing first-boot initialization...
Fresh install pre steps
Checking RRDtool version >= 1.4.7: [ OK ] 1.4.7
Dropping database: zodb_session
Creating database: zodb_session
Applying schema version: 1
Applying schema version: 2
Applying schema version: 3
Dropping database: zodb
Creating database: zodb
Applying schema version: 1
Applying schema version: 2
Applying schema version: 3
Creating database: zenoss_zep
make zope instance.
Loading initial Zenoss objects into the Zeo database
(this can take a few minutes)
Unable to create the initial Zenoss object database
Subject: | why not just use the |
Author: | Andrew Kirch |
Posted: | 2015-02-26 11:41 |
why not just use the automatic install script http://wiki.zenoss.org/Install_Zenoss#auto-deploy_Installation
Andrew Kirch
akirch@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
Subject: | Hi. I use the auto script |
Author: | [Not Specified] |
Posted: | 2016-03-28 04:31 |
Hi. I use the auto script install and I have access denied for root @ local host ..but when I put mysql -u root I can connect without any problem ....
Any suggestion Ty
Subject: | start with a clean mysql? |
Author: | Andrew Kirch |
Posted: | 2016-03-28 20:31 |
start with a clean mysql The script installs a clean mysql with no passwords. Then you configure the passwords and secure mysql in the script.
Andrew Kirch
akirch@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
Subject: | OK my problem was tha I was |
Author: | [Not Specified] |
Posted: | 2016-04-04 06:49 |
OK my problem was tha I was over a mount point thas is the reason why I have acceses denied, I just move the auto scripts to /tmp. So now I have another problem:
service zenoss start
Zenoss not initialized. Performing first-boot initialization...
Fresh install pre steps
Checking RRDtool version >= 1.4.7: [ OK ] 1.4.7
Dropping database: zodb_session
Creating database: zodb_session
Applying schema version: 1
Applying schema version: 2
Applying schema version: 3
Dropping database: zodb
Creating database: zodb
Applying schema version: 1
Applying schema version: 2
Applying schema version: 3
Creating database: zenoss_zep
make zope instance.
Loading initial Zenoss objects into the Zeo database
(this can take a few minutes)
Unable to create the initial Zenoss object database
This is my rabbit Status:
rabbitmqctl status
Status of node rabbit@zenoss4prd ...
[{pid,1588},
{running_applications,[{rabbit,"RabbitMQ","2.8.7"},
{mnesia,"MNESIA CXC 138 12","4.5"},
{os_mon,"CPO CXC 138 46","2.2.7"},
{sasl,"SASL CXC 138 11","2.1.10"},
{stdlib,"ERTS CXC 138 10","1.17.5"},
{kernel,"ERTS CXC 138 10","2.14.5"}]},
{os,{unix,linux}},
{erlang_version,"Erlang R14B04 (erts-5.8.5) [source] [64-bit] [smp:8:8] [rq:8] [async-threads:30] [kernel-poll:true]\n"},
{memory,[{total,25872208},
{processes,10242528},
{processes_used,10227656},
{system,15629680},
{atom,1172681},
{atom_used,1139646},
{binary,79496},
{code,11368014},
{ets,774984}]},
{vm_memory_high_watermark,0.4},
{vm_memory_limit,6689524940},
{disk_free_limit,1000000000},
{disk_free,1431531520},
{file_descriptors,[{total_limit,924},
{total_used,3},
{sockets_limit,829},
{sockets_used,1}]},
{processes,[{limit,1048576},{used,124}]},
{run_queue,0},
{uptime,230627}]
...done.
rabbitmqctl -p /zenoss list_queues
Listing queues ...
...done.
Any suggestion Ty
Subject: | Acondori, |
Author: | [Not Specified] |
Posted: | 2016-04-21 02:35 |
Acondori,
I'd check a few things.
Is noexecute set on /tmp
Are you using MySQL 5.5 or something else (like mariadb)
From the ssh console are you able to mysql -u zenoss -p --host=localhost successfully *Supply the password if it asks
If the Zenoss user doesn't work, can you get in with root If so can you select * from mysql.user; and paste that (Strip the hashed passwords out)
ZenMaster Shane William Scott (Hackman238)
CTO
GoVanguard Inc.
sscott@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
< |
Previous RESOLVED: UI throws ZODB.POSException.POSKeyError while findposkeyerror comes u ... |
Next Failed to create ZODB session database error |
> |