| Summary | DB schema is out of date |
| Queue | IMP |
| Queue Version | Git master |
| Type | Bug |
| State | Duplicate |
| Priority | 1. Low |
| Owners | |
| Requester | horde (at) heskia (dot) net |
| Created | 03/24/2011 (5362 days ago) |
| Due | |
| Updated | 09/29/2011 (5173 days ago) |
| Assigned | 03/25/2011 (5361 days ago) |
| Resolved | 04/21/2011 (5334 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
root@vm03:/var/www/horde/scripts/upgrades# php -v
PHP 5.3.3-7+squeeze3 with Suhosin-Patch (cli) (built: Jun 28 2011 13:13:26)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH
root@vm03:/var/www/horde/scripts/upgrades# mysql --version
mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using
readline 6.1
and using mysql or mysqli doesn't solve the problem that the last
login time isn't updated.
the imp_schema_info table, after that I clicked again on the link: DB
Schema is out of date, and after that it said that all db Schema's are
ready...
But I see a new problem: If I use DB storage for session handling,
then the last login time isn't updated between sessions.
I will open a ticket for that.
removed? Is that no longer the case then? What db errors are you
getting now?
when I turn it to "MySQL" only then I got an error stating that the
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
Bug: 9738$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '********';
$conf['sql']['socket'] = '/var/run/mysqld/mysqld.sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'utf-8';
$conf['sql']['splitread'] = false;
$conf['sql']['ssl'] = false;
$conf['sql']['phptype'] = 'mysqli';
I have been able to investigate a bit more in this issue and it
happens only if I set MySQL as the sessionhandler backend. If I let
the PHP default (file) choice then access to the DB is working fine.
Why this was working in H3/IMP4 and no more in H5/IMP4 ?
Version ⇒ Git master
State ⇒ Duplicate
when I turn it to "MySQL" only then I got an error stating that the
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
Bug: 9738that it cannot access the IMAP server...
Please use the mailing list to ask for additional support.
http://www.horde.org/mail/ contains a list of all available mailing lists.
I made several test and now I can confirm that any update on any table
is not working except:
horde_cache
horde_sessionshandlers
It seems that I am facing an issue with some mysql connections.
MySQL is setup to use mysqli in Horde configuration
when I turn it to "MySQL" only then I got an error stating that the
port should not be mention in the conf.php. If I remove the line
$conf['sql']['port'] = 3306;
in my conf.php file then horde is working again but IMP complains that
it cannot access the IMAP server...
I don't understand what happens here...
the Horde3/IMP4 used to work pretty well on this server (until I
upgraded to php 5.3.5)...
New Attachment: conf_log.zip
Also, I have noted lot of PHP ERROR in the log file.
Is Horde compliant with php5.3.5 ?
I am also running MySQL 5.1.51
I have attached a dump of my horde and imp conf.php files in the
ticket. As you can see MySQL is correctly setup (and we can see access
in the log files i have joined to my previous message).
any idea ?
Any errors in the mysql log? Are you 100% sure the database horde is
set to use is the same that you are dumping?
New Attachment: horde.zip
Sorry for this late answer...
So yes the conf.php file is set to use SQL.
In the ZIP attachment there are 2 files
horde.sql: SQL export ==> you will see the export for my
imp_schema_info table has been created but is empty.
horde_updateDBSchema.log: extract of the log file ==> You will see the
following line nr 1689:
2011-03-28T14:44:48+02:00 DEBUG: HORDE [horde] SQL (0,0001s)
UPDATE imp_schema_info SET version = 1 [pid 20838 on line 773 of
"/usr/share/php/Horde/Db/Adapter/Base.php"]
But the database has not been updated !
What happens ?
Thanks for your support,
Antoine.
State ⇒ Feedback
Have you verified that the horde config is still setup to use the sql
prefs backend? Any errors in the log(s)?
I do not know if this is linked to this bug, but since I installed
IMP, the user preferences are no longer stored in the horde_pref table.
for instance, the "last login" entry is no more updated for existing
users nor created for new users !
My environment:
gentoo linux
php 5.3.5
mysql 5.1.51
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ IMP
Summary ⇒ DB schema is out of date
Type ⇒ Bug
The horde DB has been created from the Horde configuration browser window.
I have now installed IMP and configured it.
The configuration window mentions that DB Schema is out of date and so
I have the "Update DB" button.
If I click on it, evreything is going fine (I can see the to imp
tables in my horde DB : imp_schema_info and imp_sentmail), but the
configuration window still complains that the DB schema is out of date.
How to solve this bug ?
Thanks for your support,
Antoine