[horde] Installing Horde Groupware Webmail Edition 4.0 without asking password

[Spyros Tsiolis]

--- On Mon, 4/7/11, Tommy <hkendusers at yahoo.com.hk> wrote:

> From: Tommy <hkendusers at yahoo.com.hk>
> Subject: [horde] Installing Horde Groupware Webmail Edition 4.0 without asking password
> To: horde at lists.horde.org
> Date: Monday, 4 July, 2011, 20:37
> Hi all,
> 
> I am trying Horde Groupware Webmail Edition 4.0
> installation, until "install
> horde/webmail-beta" I am still lucky without big problem,
> but while I run
> webmail-install, it does not ask me for MySQL password so
> that it failed to
> connect MySQL.
> 
> Can some one tell me why it does not ask me for MySQL
> password? Million thanks
> 
> ##################
> PHP 5.2.13
> CentOS 5.5
> ##################
> PHP_PEAR_SYSCONF_DIR=/var/www/webmail
> /usr/local/php/bin/php -d
> include_path=/var/www/webmail/pear/php
> /var/www/webmail/pear/webmail-install
> 
> Installing Horde Groupware Webmail Edition
> 
> Configuring database settings
> 
> What database backend should we use? 
>     (false) [None]
>     (mysql) MySQL / PDO
>     (mysqli) MySQL (mysqli)
>     (pgsql) PostgreSQL
>     (sqlite) SQLite
> 
> Type your choice []: mysql
> Request persistent connections? 
>     (1) Yes
>     (0) No
> 
> Type your choice [0]: 0
> 
> Username to connect to the database as* [] newhorde
> How should we connect to the database? 
>     (unix) UNIX Sockets
>     (tcp) TCP/IP
> 
> Type your choice [unix]: unix
> 
> Location of UNIX socket [] /tmp/mysql.sock
> 
> Database name to use* [] newhorde
> 
> Internally used charset* [utf-8] utf-8
> Use SSL to connect to the server? 
>     (1) Yes
>     (0) No
> 
> Type your choice [0]: 0
> 
> Certification Authority to use for SSL connections [] 
> Split reads to a different server? 
>     (false) Disabled
>     (true) Enabled
> 
> Type your choice [false]: false
> 
> Writing main configuration file... done.
> 
> Creating database tables...
> ====================
> 
> Fatal Error:
> Connect failed: mysql_connect(): Access denied for user
> 'newhorde'@'localhost'
> (using password: NO)
> 
>  1. Horde_Core_Bundle->migrateDb()
> /var/www/webmail/pear/webmail-install:32
>  2. Horde_Core_Db_Migration->getMigrator()
> /var/www/webmail/pear/php/Horde/Core/Bundle.php:94
>  3. Horde_Injector->getInstance()
> /var/www/webmail/pear/php/Horde/Core/Db/Migration.php:87
>  4. Horde_Injector->createInstance()
> /var/www/webmail/pear/php/Horde/Injector.php:248
>  5. Horde_Injector_Binder_Factory->create()
> /var/www/webmail/pear/php/Horde/Injector.php:213
>  6. Horde_Core_Factory_DbBase->create()
> /var/www/webmail/pear/php/Horde/Injector/Binder/Factory.php:111
>  7. Horde_Core_Factory_Db->create()
> /var/www/webmail/pear/php/Horde/Core/Factory/DbBase.php:17
>  8. Horde_Core_Factory_Db->createDb()
> /var/www/webmail/pear/php/Horde/Core/Factory/Db.php:95
>  9. Horde_Db_Adapter_Base->__construct()
> /var/www/webmail/pear/php/Horde/Core/Factory/Db.php:158
> 10. Horde_Db_Adapter_Mysql->connect()
> /var/www/webmail/pear/php/Horde/Db/Adapter/Base.php:143
> 
> ====================
> # 
> 
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>

Hi Tommy,

I also run CentOS (mainly 5.6 these days).

Two things I can think of :

1. Mysql : have you ran "/usr/bin/mysql_secure_installation" ?
2. Have you granted access rights to "root" or "admin" or whatever
  the mysql super-users' name is for your machine (mainly localhost) ? :

  	[root at localhost ~]# mysql –uroot –p<password> <ENTER>
	mysql> use webmail; <ENTER>
        mysql> grant all on webmail.* 
        -> to horde at localhost; <ENTER>
	
In the same fashion, for any user :

        mysql> grant all on webmail.* 
        -> to horde@<servername>; <ENTER>

For foreign machines on the Lan or outside it (e.g. through VPNs), we have to let the webmail database know there not any restrictions :

        mysql> grant all on webmail.* 
        -> to horde at 192.168.22.21; <ENTER>

Naturally this is a chicket and egg situation, since from what I understand, you cannot access the horde database from withing mysql
command-line. Try the Mysql site for help too. Never helped me in such
situations but you never know.

3. Also make sure the mysql super-user password is not two complicated.
I've found out that on MySQL, if the admin enters complicated passwords
like "!@#$344Fljjki*#", MySQL gets stuck (mainly) on the symbols.
So I enter passwords with numbers and latin characters (lower-upper) 
ONLY.

HTH,

spyros


----
"I merely function as a channel that filters 
music through the chaos of noise"
 - Vangelis