Tickets :: Comment on [#14648] script webmail-install cause database corruption if runned for the second time

* Your Email Address
* Spam protection	Enter the letters below: .__.. ..__ . .__ [__]\ /[ __\| [__) \| \| \/ [_./\|___\|
Comment	> 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@testcigognolamx.akhela.com' OR perm_creator_2 = 1 OR > perm_default_2 = 1) AND share_owner = > 'postmaster@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 > )
Attachment
Watch this ticket

Saved Queries