DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: https://bugs.horde.org/ticket/14647
------------------------------------------------------------------------------
Ticket | 14647
Created By | Johnnycage at mailinator.com
Summary | script webmail-install cause database corruption if
| runned for the second time
Queue | Horde Base
Version | 5.2.15
Type | Bug
State | Unconfirmed
Priority | 1. Low
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
Johnnycage at mailinator.com (2017-05-19 11:39) wrote:
The software version that seems affected by this bug, is hore
groupware 5.2.20 (I'm sorry but I didn't found queue name that match it)
If script webmail-install is runned for the second time, a corruption
of database will occur
my horde installation was on centos 7 and run with the following commands:
pear config-create /var/www/horde /var/www/horde/pear.conf
pear -c /var/www/horde/pear.conf install pear-1.9.4
pear -c /var/www/horde/pear.conf install pear/Net_Socket-1.0.14
/var/www/horde/pear/pear -c /var/www/horde/pear.conf
channel-discover pear.horde.org
/var/www/horde/pear/pear -c /var/www/horde/pear.conf install horde/horde_role
echo /var/www/horde | /var/www/horde/pear/pear -c
/var/www/horde/pear.conf run-scripts horde/horde_role
/var/www/horde/pear/pear -c /var/www/horde/pear.conf install -a -B
horde/webmail
/var/www/horde/pear/pear -c /var/www/horde/pear.conf install -a -B
horde/passwd
PHP_PEAR_SYSCONF_DIR=/var/www/horde php -d
include_path=/var/www/horde/pear/php /var/www/horde/pear/webmail-install
this error is shown on horde after webmail-install is run for the second time:
A fatal error has occurred
Missing required connection parameter(s).
in /var/www/horde/mnemo/lib/Driver/Sql.php:56
1. Horde_Core_Block_Layout_View->toHtml()
/var/www/horde/services/portal/index.php:35
2. Horde_Core_Block->getContent()
/var/www/horde/pear/php/Horde/Core/Block/Layout/View.php:98
3. Horde_Core_Block->_call() /var/www/horde/pear/php/Horde/Core/Block.php:175
4. Mnemo_Block_Summary->_content()
/var/www/horde/pear/php/Horde/Core/Block.php:278
5. Mnemo::listMemos() /var/www/horde/mnemo/lib/Block/Summary.php:59
6. Mnemo_Factory_Driver->create() /var/www/horde/mnemo/lib/Mnemo.php:80
7. Mnemo_Driver_Sql->__construct()
/var/www/horde/mnemo/lib/Factory/Driver.php:73
Details
The full error message is logged in Horde's log file, and is shown
below only to administrators. Non-administrative users will not see
error details.
InvalidArgumentException Object
(
[message:protected] => Missing required connection parameter(s).
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/horde/mnemo/lib/Driver/Sql.php
[line:protected] => 56
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/horde/mnemo/lib/Factory/Driver.php
[line] => 73
[function] => __construct
[class] => Mnemo_Driver_Sql
[type] => ->
[args] => Array
(
[0] => xZiLQ3wpzBQgIads3t8fGSe
[1] => Array
(
[username] => xxxxxx
[password] => xxxxxx
[socket] => /var/lib/mysql/mysql.sock
[protocol] => unix
[database] => xxxxxxx
[charset] => utf-8
[ssl] =>
[splitread] =>
[logqueries] => 1
[phptype] => mysql
[driverconfig] => horde
[umask] => 63
[db] => Horde_Db_Adapter_Pdo_Mysql Object
(
[_schemaClass:protected]
=> Horde_Db_Adapter_Mysql_Schema
[_config:protected] => Array
(
[charset] => utf-8
[database] => xxxxxx
[password] => xxxxxx
[phptype] => mysql
[protocol] => unix
[splitread] =>
[ssl] =>
[username] => xxxxxxx
[adapter] => mysql
[unix_socket] =>
/var/lib/mysql/mysql.sock
)
[_connection:protected]
=> PDO Object
(
)
[_transactionStarted:protected] => 0
[_lastQuery:protected] =>
SELECT DISTINCT s.share_id, s.share_name, s.share_owner,
s.share_flags, s.perm_creator_2, s.perm_creator_4, s.perm_creator_8,
s.perm_creator_16, s.perm_default_2, s.perm_default_4,
s.perm_default_8, s.perm_default_16, s.perm_guest_2, s.perm_guest_4,
s.perm_guest_8, s.perm_guest_16, s.attribute_name, s.attribute_desc,
s.share_parents FROM mnemo_sharesng s WHERE (share_owner =
'postmaster at testcigognolamx.akhela.com' OR perm_creator_2 = 1 OR
perm_default_2 = 1) AND share_owner =
'postmaster at testcigognolamx.akhela.com' ORDER BY attribute_name ASC
[_rowCount:protected] => 1
[_runtime:protected] => 0
[_active:protected] => 1
[_cache:protected] =>
Horde_Cache Object
(
[_params:protected] => Array
(
[compress] => 1
[lifetime] => 86400
)
[_logger:protected] => Horde_Core_Log_Wrapper Object
(
)
[_storage:protected] => Horde_Cache_Storage_File Object
(
[_file:protected] => Array
(
[Horde_Db_Adapter_Pdo_Mysql56ff7492tables/columns/nag_sharesng] =>
/tmp/cache_dfcea7cb7de9f7d3c24925147bd6c46b
[Horde_Db_Adapter_Pdo_Mysql56ff7492tables/columns/kronolith_sharesng]
=> /tmp/cache_f04570edd35f72dc50cf520b00fc44e3
[Horde_Db_Adapter_Pdo_Mysql56ff7492tables/columns/kronolith_events] =>
/tmp/cache_b495aef1159e1c9a13f794c3c54e216c
[Horde_Db_Adapter_Pdo_Mysql56ff7492tables/columns/ingo_rules] =>
/tmp/cache_1966813c1fd181949a9c85dfeef1b9c5
[Horde_Db_Adapter_Pdo_Mysql56ff7492tables/columns/mnemo_sharesng] =>
/tmp/cache_964d5ea5cbf1857ba1ffaea599822992
)
[_logger:protected] => Horde_Core_Log_Wrapper Object
(
)
[_params:protected] => Array
(
[prefix] => cache_
[sub] => 0
[umask] => 63
[dir] => /tmp
)
)
)
[_cachePrefix:protected]
=> Horde_Db_Adapter_Pdo_Mysql56ff7492
[_logger:protected] =>
Horde_Core_Log_Logger Object
(
[_levels:protected] => Array
(
[EMERG] => 0
[EMERGENCY] => 0
[ALERT] => 1
[CRIT] => 2
[CRITICAL] => 2
[ERR] => 3
[ERROR] => 3
[WARN] => 4
[WARNING] => 4
[NOTICE] => 5
[INFO] => 6
[INFORMATION] => 6
[INFORMATIONAL] => 6
[DEBUG] => 7
)
[_handlers:protected] => Array
(
[0] =>
Horde_Log_Handler_Syslog Object
(
[_options:protected] => Array
(
[defaultPriority] => 3
[facility] => 8
[ident] => HORDE
[openlogOptions] =>
)
[_lastIdent:protected] => HORDE
[_lastFacility:protected] => 8
[_priorities:protected] => Array
(
[0] => 0
[1] => 1
[2] => 2
[3] => 3
[4] => 4
[5] => 5
[6] => 6
[7] => 7
)
[_filters:protected] => Array
(
[0] => Horde_Log_Filter_Level Object
(
[_level:protected] => 6
)
)
)
)
[_filters:protected] => Array
(
)
)
[_schema:protected] =>
Horde_Db_Adapter_Mysql_Schema Object
(
[_adapter:protected] => Horde_Db_Adapter_Pdo_Mysql Object
*RECURSION*
[_adapterMethods:protected] => Array
(
[adapterName] => 0
[supportsMigrations] => 1
[connect] => 2
[isActive] => 3
[select] => 4
[selectAll] => 5
[selectOne] => 6
[selectValue] => 7
[selectValues] => 8
[selectAssoc] => 9
[execute] => 10
[insertBlob] => 11
[updateBlob] => 12
[insert] => 13
[beginDbTransaction] => 14
[commitDbTransaction] => 15
[rollbackDbTransaction] => 16
[quoteString] => 17
[__construct] => 18
[__destruct] => 19
[__sleep] => 20
[__wakeup] => 21
[getOption] => 22
[setCache] => 23
[getCache] => 24
[setLogger] => 25
[getLogger] => 26
[__call] => 27
[supportsCountDistinct] => 28
[supportsInterval] => 29
[prefetchPrimaryKey] => 30
[getLastQuery] => 31
[resetRuntime] => 32
[cacheWrite] => 33
[cacheRead] => 34
[reconnect] => 35
[disconnect] => 36
[rawConnection] => 37
[update] => 38
[delete] => 39
[transactionStarted] => 40
[addLimitOffset] => 41
[sanitizeLimit] => 42
[addLock] => 43
[insertFixture] => 44
[emptyInsertStatement] => 45
)
)
[_schemaMethods:protected] => Array
(
[makeColumn] => 0
[quoteColumnName] => 1
[quoteTableName] => 2
[nativeDatabaseTypes] => 3
[tables] => 4
[primaryKey] => 5
[indexes] => 6
[columns] => 7
[endTable] => 8
[renameTable] => 9
[changeColumn] => 10
[changeColumnDefault] => 11
[renameColumn] => 12
[removePrimaryKey] => 13
[indexName] => 14
[createDatabase] => 15
[dropDatabase] => 16
[currentDatabase] => 17
[typeToSql] => 18
[addColumnOptions] => 19
[buildClause] => 20
[getCharset] => 21
[setCharset] => 22
[_mysqlCharsetName] => 23
[getCollation] => 24
[showVariable] => 25
[caseSensitiveEqualityOperator] => 26
[limitedUpdateConditions] => 27
[__construct] => 28
[setAdapter] => 29
[makeColumnDefinition] => 30
[makeIndex] => 31
[makeTable] => 32
[makeTableDefinition] => 33
[__call] => 34
[__get] => 35
[quote] => 36
[quoteString] => 37
[quoteTrue] => 38
[quoteFalse] => 39
[quoteDate] => 40
[quoteBinary] => 41
[tableAliasLength] => 42
[tableAliasFor] => 43
[table] => 44
[column] => 45
[createTable] => 46
[dropTable] => 47
[addColumn] => 48
[removeColumn] => 49
[addPrimaryKey] => 50
[addIndex] => 51
[removeIndex] => 52
[recreateDatabase] => 53
[distinct] => 54
[addOrderByForAssocLimiting] => 55
[interval] => 56
[modifyDate] => 57
)
[_logQueries:protected] => 1
)
)
)
)
[1] => Array
(
[file] => /var/www/horde/mnemo/lib/Mnemo.php
[line] => 80
[function] => create
[class] => Mnemo_Factory_Driver
[type] => ->
[args] => Array
(
[0] => xZiLQ3wpzBQgIads3t8fGSe
)
)
[2] => Array
(
[file] => /var/www/horde/mnemo/lib/Block/Summary.php
[line] => 59
[function] => listMemos
[class] => Mnemo
[type] => ::
[args] => Array
(
[0] => 0
[1] => 0
)
)
[3] => Array
(
[file] => /var/www/horde/pear/php/Horde/Core/Block.php
[line] => 278
[function] => _content
[class] => Mnemo_Block_Summary
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/www/horde/pear/php/Horde/Core/Block.php
[line] => 175
[function] => _call
[class] => Horde_Core_Block
[type] => ->
[args] => Array
(
[0] => _content
[1] =>
)
)
[5] => Array
(
[file] =>
/var/www/horde/pear/php/Horde/Core/Block/Layout/View.php
[line] => 98
[function] => getContent
[class] => Horde_Core_Block
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /var/www/horde/services/portal/index.php
[line] => 35
[function] => toHtml
[class] => Horde_Core_Block_Layout_View
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[logged] => 1
)