Database Locked when finishing set up

General discussion forum for the Zend Server
Post Reply
Posts: 2
Joined: Thu Jan 12, 2017 1:24 pm

Database Locked when finishing set up

Post by rube3691 » Thu Jan 12, 2017 1:40 pm

I recently installed Zend Server Version: 9.0.1 Build: 108824 on a Linux Virtual machine using Ubuntu 14.04.1 LTS. I am using Apache2, and MySQL. After running the install script successfully, I accessed localhost:10081 (and 82) and followed the instructions on the screen. After pressing launch, it errors with the following message:

Code: Select all

Failed to set user details in bootstrap: Set Profile; Statement could not be executed (HY000 - 5 - database is locked)
I have tried restarting zend server multiple times. I have also attempted to reinstall it, reinstall the web server, rebooting the machine, deleting the zend database files (such as monitor, etc.).

I am at a loss as to how to solve the issue, and have not been capable of finding any information as to what might even be the issue.

User avatar
Zend Global Support
Posts: 997
Joined: Sun Dec 14, 2008 9:48 am

Re: Database Locked when finishing set up

Post by zvika » Sun Jan 15, 2017 12:25 pm

First, try to do this wipe setup:
1. /usr/local/zend/bin/
2. remove /usr/local/zend
3. remove user zend
4. remove Apache if you don't have any important settings, rename / remove /etc/apache2 and any leftover settings
5. apt-get update, apt-get autoremove, apt-get autoclean, apt-get install -f (probably will do nothing)
6. install Zend Server using the linux installer for ZS 9.0.1 (or apt-get install zend-server-php-7.0 for existing repo)
7. check and initialize
8. if something is still not working, you can open a support ticket on, link back to this forum topic, and provide a support tool dump from /usr/local/zend/bin/ with the problem description, so we can assist with some offline facts.
Zvika Dror
Zend Support Team

Posts: 2
Joined: Thu Jan 12, 2017 1:24 pm

Re: Database Locked when finishing set up

Post by rube3691 » Mon Jan 23, 2017 7:04 pm

Thank you for your answer. Luckily, I was capable of solving the issue, though not through the method you described.

For posterity (and google searches): essentially, there was a conflict between my nagios3 install and the zend-server install. My guess is there was a conflict with the PHP version (IIRC nagios3 required php5), though why it manifested that way is beyond me. Regardless, after speaking with some colleagues who had also had the issue and told me this had been it, I was able to complete the set up.

Post Reply