Stucked on "Wait, still installing database"

› VitalPBX Community Support › General Discussion › Stucked on "Wait, still installing database"

  • Post
    • November 14, 2018 at 3:28 pm
    pdifeo
    Participant

    Hi,

    I installed a freshen VitalPBX on a computer. When try to access to web admin I receive “Wait, still installing database”. Is more than 1 hour.

    I try also to restart the computer without success. There is a way without reinstalling all.

    Thanks 
    Pasquale

    0
Viewing 15 replies - 1 through 15 (of 23 total)
1 2
  • Replies
    • November 14, 2018 at 4:16 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Execute the following command:

    systemctl start ombutel-dbsetup.service

    Let me know if an error appears or something else

    0
    • November 15, 2018 at 8:16 am
    pdifeo
    Participant
    Up
    0
    Down
    systemctl start ombutel-dbsetup.service
    Job for ombutel-dbsetup.service failed because the control process exited with error code. See "systemctl status ombutel-dbsetup.service" and "journalctl -xe" for details.


    and 

    Nov 15 09:13:00 pbx.es.bclabnet.com polkitd[531]: Registered Authentication Agent for unix-process:25595:6070831 (system bus name :1.71 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8)
    Nov 15 09:13:00 pbx.es.bclabnet.com systemd[1]: Starting Ombutel database setup...
    -- Subject: Unit ombutel-dbsetup.service has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit ombutel-dbsetup.service has begun starting up.
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: Importing 20160330.2.dpma_model_id.sql...
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: PHP Fatal error:  Uncaught exception 'Exception' with message 'ERROR 1025 (HY000) at line 2: Error on rename of './ombutel/dpma_firmwares' to './ombutel/#sql2-60d-2ba' (errno: 152)
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: ' in /usr/share/ombutel/scripts/apply_patches:0
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: Stack trace:
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: #0 /usr/share/ombutel/scripts/apply_patches(0): patcher::shellcmd()
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: #1 /usr/share/ombutel/scripts/apply_patches(0): patcher->shellcmd()
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: #2 /usr/share/ombutel/scripts/apply_patches(0): patcher->import_dbscript()
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: #3 /usr/share/ombutel/scripts/apply_patches(0): patcher->apply()
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: #4 {main}
    Nov 15 09:13:00 pbx.es.bclabnet.com dbupdate[25601]: thrown in /usr/share/ombutel/scripts/apply_patches on line 0
    Nov 15 09:13:00 pbx.es.bclabnet.com systemd[1]: ombutel-dbsetup.service: main process exited, code=exited, status=255/n/a
    Nov 15 09:13:00 pbx.es.bclabnet.com systemd[1]: Failed to start Ombutel database setup.
    -- Subject: Unit ombutel-dbsetup.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit ombutel-dbsetup.service has failed.
    --
    -- The result is failed.
    Nov 15 09:13:00 pbx.es.bclabnet.com systemd[1]: Unit ombutel-dbsetup.service entered failed state.
    Nov 15 09:13:00 pbx.es.bclabnet.com systemd[1]: ombutel-dbsetup.service failed.
    Nov 15 09:13:00 pbx.es.bclabnet.com polkitd[531]: Unregistered Authentication Agent for unix-process:25595:6070831 (system bus name :1.71, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)

    0
    • November 15, 2018 at 8:27 am
    pdifeo
    Participant
    Up
    0
    Down

    My problem is that the computer is in Spain and I’m in Italy and Spanish people don’t have competence to reinstall. 

    Yesterday I was in Spain and I hoped that returning to Italy the db had configured. Something that did not happen.

    Same error if I try to reinstall with yum reinstall vitalpbx-2.1.0-1.x86_64 

    [root@pbx scripts]# yum reinstall vitalpbx-2.1.0-1.x86_64
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    * base: mirror.airenetworks.es
    * epel: mirror.airenetworks.es
    * extras: mirror.airenetworks.es
    * updates: mirror.airenetworks.es
    Resolving Dependencies
    --> Running transaction check
    ---> Package vitalpbx.x86_64 0:2.1.0-1 will be reinstalled
    --> Finished Dependency Resolution

    Dependencies Resolved

    =======================================================================================================================================================================================================================================================================================
    Package Arch Version Repository Size
    =======================================================================================================================================================================================================================================================================================
    Reinstalling:
    vitalpbx x86_64 2.1.0-1 vpbx 9.2 M

    Transaction Summary
    =======================================================================================================================================================================================================================================================================================
    Reinstall 1 Package

    Total download size: 9.2 M
    Installed size: 33 M
    Is this ok [y/d/N]: y
    Downloading packages:
    vitalpbx-2.1.0-1.x86_64.rpm | 9.2 MB 00:00:07
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Installing : vitalpbx-2.1.0-1.x86_64 1/1
    Importing 20160330.2.dpma_model_id.sql...
    PHP Fatal error: Uncaught exception 'Exception' with message 'ERROR 1025 (HY000) at line 2: Error on rename of './ombutel/dpma_firmwares' to './ombutel/#sql2-60d-350' (errno: 152)
    ' in /usr/share/ombutel/scripts/apply_patches:0
    Stack trace:
    #0 /usr/share/ombutel/scripts/apply_patches(0): patcher::shellcmd()
    #1 /usr/share/ombutel/scripts/apply_patches(0): patcher->shellcmd()
    #2 /usr/share/ombutel/scripts/apply_patches(0): patcher->import_dbscript()
    #3 /usr/share/ombutel/scripts/apply_patches(0): patcher->apply()
    #4 {main}
    thrown in /usr/share/ombutel/scripts/apply_patches on line 0
    Verifying : vitalpbx-2.1.0-1.x86_64 1/1

    Installed:
    vitalpbx.x86_64 0:2.1.0-1

    Complete!

     

    0
    • November 15, 2018 at 1:24 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    This a new installation right?

    What are the hardware specifications?

    0
    • November 15, 2018 at 1:58 pm
    pdifeo
    Participant
    Up
    0
    Down

    On the computer before was there installed FreePBX. But the error, I think, is on missing file ./ombutel/dpma_firmwares

    [root@pbx ~]# dmidecode | grep -A3 '^System Information'
    System Information
    Manufacturer: HP
    Product Name: HP 280 G2 MT (Non-Legacy)


    4GB di RAM
    HD 500gb 
    0
    • November 15, 2018 at 2:05 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    I can give you a hand if you give me remote access through AnyDesk, you can send me the any desk ID to my email miguel@aplitel.com

    0
    • November 15, 2018 at 3:06 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Solution:

    • Drop Ombutel & Asterisk database
    • Execute the script to install the databases: php /usr/share/ombutel/scripts/apply_patches
    • Restart dbsetup service: systemctl start ombutel-dbsetup.service

     

    0
    • November 15, 2018 at 3:52 pm
    pdifeo
    Participant
    Up
    0
    Down

    Thanks again for the help

     

    0
    • January 25, 2019 at 1:59 pm
    voiprehberi
    Participant
    Up
    0
    Down

    I am getting 

    PHP Fatal error: Call to undefined method PDO::lastInsertId() in /usr/share/ombutel/scripts/apply_patches on line 0 error when i execute the php /usr/share/ombutel/scripts/apply_patches command.

    please help.

    0
    • January 25, 2019 at 2:31 pm
    voiprehberi
    Participant
    Up
    0
    Down
    Posted by: voiprehberi

    I am getting 

    PHP Fatal error: Call to undefined method PDO::lastInsertId() in /usr/share/ombutel/scripts/apply_patches on line 0 error when i execute the php /usr/share/ombutel/scripts/apply_patches command.

    please help.

     

    I am using vmware on server.

     

    0
    • January 25, 2019 at 3:00 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Is this a new installation?

    0
    • January 25, 2019 at 3:24 pm
    voiprehberi
    Participant
    Up
    0
    Down

    yes.

    0
    • January 25, 2019 at 3:40 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Try the following, go to the linux console and execute the following commands:

    • mysql -uroot
    • drop database asterisk;
    • drop database ombutel;

    Exit from mysql console pressing “CTRL + C”

    The apply the patches

    /usr/share/ombutel/scripts/apply_patches
    0
    • January 25, 2019 at 3:52 pm
    voiprehberi
    Participant
    Up
    0
    Down

    Same error : Importing 20160208.1.init.sql…
    PHP Fatal error: Call to undefined method PDO::lastInsertId() in /usr/share/ombutel/scripts/apply_patches on line 0

    0
    • January 25, 2019 at 4:07 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    How did you install the software?

    0
Viewing 15 replies - 1 through 15 (of 23 total)
1 2
  • The topic ‘Stucked on "Wait, still installing database"’ is closed to new replies.