TECHZEN Zenoss User Community ARCHIVE  

"Unable to create the initial Zenoss object database" error

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
>