DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: https://bugs.horde.org/ticket/14647
------------------------------------------------------------------------------
Ticket | 14647
Updated 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:48) wrote:
same ticket has been open on correct queue 'horde groupware webmail
edition 5.2.20
> 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
> )
>
>