Koozali.org: home of the SME Server

Horde database configuation is missing.

Offline zeeclor

  • 16
  • +0/-0
Horde database configuation is missing.
« on: April 17, 2021, 04:26:01 AM »
I have done a fresh install of SME10rc1 and cannot access horde.
# cat /var/log/horde/horde.log
2021-04-16T15:45:02+00:00 ERR: HORDE The database configuration is missing. [pid 749 on line 161 of "/usr/share/pear/Horde/Core/Factory/Db.php"]

I can add this to the bug tracker (I think) if this is not a known issue. I cannot see it listed anywhere however.

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Horde database configuation is missing.
« Reply #1 on: April 17, 2021, 05:26:54 AM »
Some more info will help, like was a backup restored, VM, barmetal..

Over a number of sme10 installs beta and RC have not seen that error, there are errors in the error.log howebver webmail is still working, Kronolith is not being nice..there is an update pending
--
qui scribit bis legit

Online Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Horde database configuation is missing.
« Reply #2 on: April 17, 2021, 06:03:17 AM »
just fresh install ? any restore ?


what gives
Code: [Select]
ll /etc/e-smith/sql/init/

and
Code: [Select]
systemctl status -l mysql.init.service
and

Code: [Select]
systemctl status -l mariadb.service

Offline zeeclor

  • 16
  • +0/-0
Re: Horde database configuation is missing.
« Reply #3 on: April 17, 2021, 07:15:32 AM »
just fresh install ? any restore ?
Fresh install on KVM with iscsi thin LUNs. I restore via affa but this is a plain install straight out of the box.


what gives
Code: [Select]
ll /etc/e-smith/sql/init/
Code: [Select]
[root@sme10rc1bck ~]# ll /etc/e-smith/sql/init/
total 0

and
Code: [Select]
systemctl status -l mysql.init.service
Code: [Select]
[root@sme10rc1bck ~]# systemctl status -l mysql.init.service
 mysql.init.service - Koozali SME Server mysql DB injector for mariadb
   Loaded: loaded (/etc/rc.d/init.d/mysql.init; enabled; vendor preset: enabled)
   Active: active (exited) since Sat 2021-04-17 05:00:43 AEST; 8min ago
  Process: 2676 ExecStart=/etc/rc.d/init.d/mysql.init start (code=exited, status=0/SUCCESS)
 Main PID: 2676 (code=exited, status=0/SUCCESS)
   Memory: 0B
   CGroup: /system.slice/mysql.init.service

Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading horde_mysql_create_tables into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading turba_mysql_create_objects into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading kronolith_db_upgrade into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading kronolith_utc_upgrade into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading Ingo_Datatree_to_SQL into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading Kronolith_Datatree_to_SQL into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading Mnemo_Datatree_to_SQL into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading Nag_Datatree_to_SQL into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au mysql.init[2676]: Loading Turba_Datatree_to_SQL into mysql [  OK  ]
Apr 17 05:00:43 sme10rc1bck.zeeclor.com.au systemd[1]: Started Koozali SME Server mysql DB injector for mariadb.

and

Code: [Select]
systemctl status -l mariadb.service
Code: [Select]
[root@sme10rc1bck ~]# systemctl status -l mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /usr/lib/systemd/system/mariadb.service.d
           └─50koozali.conf
   Active: active (running) since Sat 2021-04-17 05:00:41 AEST; 8min ago
  Process: 2986 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 2954 ExecStartPre=/sbin/e-smith/systemd/mariadb-initialize (code=exited, status=0/SUCCESS)
  Process: 2952 ExecStartPre=/sbin/e-smith/expand-template /etc/my.cnf (code=exited, status=0/SUCCESS)
  Process: 2949 ExecStartPre=/sbin/e-smith/expand-template /root/.my.cnf (code=exited, status=0/SUCCESS)
  Process: 2946 ExecStartPre=/sbin/e-smith/expand-template /var/lib/mysql/set.password (code=exited, status=0/SUCCESS)
  Process: 2939 ExecStartPre=/sbin/e-smith/service-status mariadb (code=exited, status=0/SUCCESS)
 Main PID: 2985 (mysqld)
   Memory: 106.9M
   CGroup: /system.slice/mariadb.service
           └─2985 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mariadb/mariadb.pid

Apr 17 05:00:34 sme10rc1bck.zeeclor.com.au systemd[1]: Starting MariaDB database server...
Apr 17 05:00:34 sme10rc1bck.zeeclor.com.au mariadb-initialize[2954]: 210417  5:00:34 [Note] /usr/libexec/mysqld (mysqld 5.5.68-MariaDB) starting as process 2956 ...
Apr 17 05:00:39 sme10rc1bck.zeeclor.com.au mysqld[2985]: 210417  5:00:39 [Note] /usr/libexec/mysqld (mysqld 5.5.68-MariaDB) starting as process 2985 ...
Apr 17 05:00:41 sme10rc1bck.zeeclor.com.au systemd[1]: Started MariaDB database server.

The main issue seems to be a Mysqli.php issue.
Code: [Select]
[root@sme10rc1bck horde]# cat error.log
Apr 17 04:49:09 sme10rc1bck HORDE: SQL QUERY FAILED: Table 'horde.horde_perms' doesn't exist    SELECT COUNT(*) FROM horde_perms WHERE perm_name = 'horde' [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:09 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'imp_sentmail_seq'    DROP TABLE `imp_sentmail_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:10 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'ingo_rules_seq'    DROP TABLE `ingo_rules_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:10 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'ingo_shares_seq'    DROP TABLE `ingo_shares_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:13 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'kronolith_shares_seq'    DROP TABLE `kronolith_shares_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:13 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'kronolith_resources_seq'    DROP TABLE `kronolith_resources_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:14 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Table 'horde.rampage_types' doesn't exist    SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN   ('calendar','event') [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:14 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'turba_shares_seq'    DROP TABLE `turba_shares_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:15 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Table 'horde.rampage_types' doesn't exist    SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN   ('contact') [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:16 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'nag_shares_seq'    DROP TABLE `nag_shares_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:16 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Table 'horde.rampage_types' doesn't exist    SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN   ('task') [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:17 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'mnemo_shares_seq'    DROP TABLE `mnemo_shares_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:17 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Table 'horde.rampage_types' doesn't exist    SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN   ('note') [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:19 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'horde_groups_seq'    DROP TABLE `horde_groups_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:19 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'horde_histories_seq'    DROP TABLE `horde_histories_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:20 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'horde_perms_seq'    DROP TABLE `horde_perms_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:20 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'horde_vfs_seq'    DROP TABLE `horde_vfs_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
Apr 17 04:49:20 sme10rc1bck HORDE: [horde] SQL QUERY FAILED: Unknown table 'horde_muvfs_seq'    DROP TABLE `horde_muvfs_seq` [pid 3380 on line 323 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]

and all the tables do exist in MariaDB


edit:added the quote tags at the right place for easier reading
« Last Edit: April 17, 2021, 04:24:10 PM by Jean-Philippe Pialasse »

Online Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Horde database configuation is missing.
« Reply #4 on: April 17, 2021, 03:29:48 PM »
the last log you pasted is not a bug this is just log noise of horde trying to migrate what was already migrated, by trying to drop tables that have been already dropped.

Online Jean-Philippe Pialasse

  • *
  • 2,747
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Horde database configuation is missing.
« Reply #5 on: April 17, 2021, 04:28:42 PM »
Fresh install on KVM with iscsi thin LUNs. I restore via affa but this is a plain install straight out of the box.

just need some clarifications here.

1- Have you already restored something with affa on it before the message appear?

2- Affa is not and has never been designed to restore from a different version.
This is not a supported nor encouraged way to do, you will break things.
Affa is for high availability and fast recovering from disaster from one server to another with the same version.

Offline zeeclor

  • 16
  • +0/-0
Re: Horde database configuation is missing.
« Reply #6 on: April 18, 2021, 08:25:15 AM »
just need some clarifications here.

1- Have you already restored something with affa on it before the message appear?
No. This is the first boot after install.

Quote
2- Affa is not and has never been designed to restore from a different version.
This is not a supported nor encouraged way to do, you will break things.
Affa is for high availability and fast recovering from disaster from one server to another with the same version.
OK.

Thanks for the heads up on the horde database recreation, Jean-Phillippe. It sounds like horde itself is OK.

How can one fix the missing database configuration (as per horde.log above)?

David

I should add there is no entry point for horde.

"The requested URL /horde was not found on this server."
« Last Edit: April 18, 2021, 10:35:41 PM by zeeclor »

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Horde database configuation is missing.
« Reply #7 on: April 19, 2021, 01:56:18 AM »
No. This is the first boot after install.

Then it would be simpler and faster to simpley do a clean install again..you are indicating that this is just that a clean install.


--
qui scribit bis legit

Offline zeeclor

  • 16
  • +0/-0
Re: Horde database configuation is missing.
« Reply #8 on: April 19, 2021, 05:46:43 AM »
Then it would be simpler and faster to simpley do a clean install again..you are indicating that this is just that a clean install.
Yes. It's a clean install and reinstalling gives the same error.log but no horde.log at first boot. It is a consistent result across two installations with essentially the same configuration.

Bugs that are not reproducible are the most insidious.  :-(

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Horde database configuation is missing.
« Reply #9 on: April 19, 2021, 12:33:17 PM »
Your right there, yet to experience it from alpha to the RC..damn..this will take a bit of detective work..

So, I see from one of your posts "install on KVM with iscsi thin LUNs" can you give us a rundown on hardware and hypervisor...just plucking straws
--
qui scribit bis legit

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Horde database configuation is missing.
« Reply #10 on: April 19, 2021, 12:44:45 PM »
Yes we'll need to do this in little steps so we can see exactly where this occurs.

Can you do a completely clean install and reboot prior to any attempt at restore and let us know what you see.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline zeeclor

  • 16
  • +0/-0
Re: Horde database configuation is missing.
« Reply #11 on: April 20, 2021, 11:01:21 PM »
Correction: I misinformed the forum. It works out of the box. I apologise for the miscommunication at our end that led to this.

We will continue to investigate our possible affa --rise issue but I suspect it too may be a luser error.

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Horde database configuation is missing.
« Reply #12 on: April 20, 2021, 11:10:17 PM »
Great to hear, affa may not be the best, how big is a standard backup, it is proving to be workable..

Added: one of the contribs that has been ported over and is looking very rpomising is https://wiki.koozali.org/Rsync-backup2disk#Configuration

Might be worth a look
« Last Edit: April 20, 2021, 11:16:40 PM by TerryF »
--
qui scribit bis legit

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Horde database configuation is missing.
« Reply #13 on: April 21, 2021, 10:45:12 AM »
We will continue to investigate our possible affa --rise issue but I suspect it too may be a luser error.

As per JPs comment above please be EXTREMELY careful with affa.

It absolutely is not designed to restore between versions and there is every chance things will break.

(There are quite a few things in affa in general which I have in hand to fix but just not had the time them finish them yet - systemd awareness being one :-( )

There are recognised methods for the upgrade and you really ought to try and stick to them to save hassle.

If you DO use affa make sure you specify that if you have any issues.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline zeeclor

  • 16
  • +0/-0
Re: Horde database configuation is missing.
« Reply #14 on: April 25, 2021, 10:54:41 PM »
As per JPs comment above please be EXTREMELY careful with affa.

It absolutely is not designed to restore between versions and there is every chance things will break.

(There are quite a few things in affa in general which I have in hand to fix but just not had the time them finish them yet - systemd awareness being one :-( )

There are recognised methods for the upgrade and you really ought to try and stick to them to save hassle.

If you DO use affa make sure you specify that if you have any issues.
OK.

Having noted the above I can say an affa --rise worked well on Sunday for our 450 gig of data on 10rc1 for both the source and destination VMs.

I also note the warning that "Your server has too much data for a reliable backup to desktop" for the standard backup mechanism.
« Last Edit: April 25, 2021, 10:58:55 PM by zeeclor »