[horde] Error using sql driver for storing preferences!

Bill Graham grahamcw at hurleybulldogs.com
Sun Jun 4 18:10:33 PDT 2006


You didin't give permission to horde'@'192.168.1.2
the default install script only adds permissions to horde at localhost

Bill


Quoting Javier Carlos Viegas <javiercviegas at yahoo.com.ar>:

> Hi, im having this error every time i setup horde to
> use sql driver to store user preferences, i don`t know
> why, i have connecction with mysql server, but the
> error seems to be a connecction problem what can i do?
>
> This is the error that i get:
>
> A fatal error has occurred
> DB Error: connect failed
>
> [line 388 of /var/www/horde/lib/Horde/Prefs/sql.php]
> Details (also in Horde's logfile):
>
> object(db_error)(8) {
>  ["error_message_prefix"]=>
>  string(0) ""
>  ["mode"]=>
>  int(1)
>  ["level"]=>
>  int(1024)
>  ["code"]=>
>  int(-24)
>  ["message"]=>
>  string(24) "DB Error: connect failed"
>  ["userinfo"]=>
>  string(89) " [nativecode=Access denied for user
> 'horde'@'192.168.1.2' (using password: YES)] ** Array"
>  ["backtrace"]=>
>  array(11) {
>    [0]=>
>    array(6) {
>      ["file"]=>
>      string(21) "/usr/share/php/DB.php"
>      ["line"]=>
>      int(888)
>      ["function"]=>
>      string(10) "pear_error"
>      ["class"]=>
>      string(8) "db_error"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(5) {
>        [0]=>
>        string(24) "DB Error: connect failed"
>        [1]=>
>        int(-24)
>        [2]=>
>        int(1)
>        [3]=>
>        int(1024)
>        [4]=>
>        string(80) " [nativecode=Access denied for
> user 'horde'@'192.168.1.2' (using password: YES)]"
>      }
>    }
>    [1]=>
>    array(6) {
>      ["file"]=>
>      string(23) "/usr/share/php/PEAR.php"
>      ["line"]=>
>      int(536)
>      ["function"]=>
>      string(8) "db_error"
>      ["class"]=>
>      string(8) "db_error"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(4) {
>        [0]=>
>        int(-24)
>        [1]=>
>        int(1)
>        [2]=>
>        int(1024)
>        [3]=>
>        string(80) " [nativecode=Access denied for
> user 'horde'@'192.168.1.2' (using password: YES)]"
>      }
>    }
>    [2]=>
>    array(6) {
>      ["file"]=>
>      string(28) "/usr/share/php/DB/common.php"
>      ["line"]=>
>      int(1849)
>      ["function"]=>
>      string(10) "raiseerror"
>      ["class"]=>
>      string(4) "pear"
>      ["type"]=>
>      string(2) "::"
>      ["args"]=>
>      array(7) {
>        [0]=>
>        NULL
>        [1]=>
>        int(-24)
>        [2]=>
>        NULL
>        [3]=>
>        NULL
>        [4]=>
>        string(80) " [nativecode=Access denied for
> user 'horde'@'192.168.1.2' (using password: YES)]"
>        [5]=>
>        string(8) "DB_Error"
>        [6]=>
>        bool(true)
>      }
>    }
>    [3]=>
>    array(6) {
>      ["file"]=>
>      string(27) "/usr/share/php/DB/mysql.php"
>      ["line"]=>
>      int(249)
>      ["function"]=>
>      string(10) "raiseerror"
>      ["class"]=>
>      string(8) "db_mysql"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(5) {
>        [0]=>
>        int(-24)
>        [1]=>
>        NULL
>        [2]=>
>        NULL
>        [3]=>
>        NULL
>        [4]=>
>        string(66) "Access denied for user
> 'horde'@'192.168.1.2' (using password: YES)"
>      }
>    }
>    [4]=>
>    array(6) {
>      ["file"]=>
>      string(21) "/usr/share/php/DB.php"
>      ["line"]=>
>      int(556)
>      ["function"]=>
>      string(7) "connect"
>      ["class"]=>
>      string(8) "db_mysql"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(2) {
>        [0]=>
>        array(13) {
>          ["phptype"]=>
>          string(5) "mysql"
>          ["dbsyntax"]=>
>          string(5) "mysql"
>          ["username"]=>
>          string(5) "horde"
>          ["password"]=>
>          string(17) "hordemiel4tarjeta"
>          ["protocol"]=>
>          string(3) "tcp"
>          ["hostspec"]=>
>          string(11) "192.168.1.4"
>          ["port"]=>
>          int(3306)
>          ["socket"]=>
>          string(27) "/var/run/mysqld/mysqld.sock"
>          ["database"]=>
>          string(5) "horde"
>          ["persistent"]=>
>          bool(false)
>          ["charset"]=>
>          string(10) "iso-8859-1"
>          ["table"]=>
>          string(11) "horde_prefs"
>          ["driverconfig"]=>
>          string(6) "custom"
>        }
>        [1]=>
>        bool(false)
>      }
>    }
>    [5]=>
>    array(6) {
>      ["file"]=>
>      string(38)
> "/var/www/horde/lib/Horde/Prefs/sql.php"
>      ["line"]=>
>      int(386)
>      ["function"]=>
>      string(7) "connect"
>      ["class"]=>
>      string(2) "db"
>      ["type"]=>
>      string(2) "::"
>      ["args"]=>
>      array(2) {
>        [0]=>
>        array(12) {
>          ["persistent"]=>
>          bool(false)
>          ["hostspec"]=>
>          string(11) "192.168.1.4"
>          ["username"]=>
>          string(5) "horde"
>          ["password"]=>
>          string(17) "hordemiel4tarjeta"
>          ["socket"]=>
>          string(27) "/var/run/mysqld/mysqld.sock"
>          ["protocol"]=>
>          string(3) "tcp"
>          ["database"]=>
>          string(5) "horde"
>          ["charset"]=>
>          string(10) "iso-8859-1"
>          ["phptype"]=>
>          string(5) "mysql"
>          ["port"]=>
>          int(3306)
>          ["table"]=>
>          string(11) "horde_prefs"
>          ["driverconfig"]=>
>          string(6) "custom"
>        }
>        [1]=>
>        array(1) {
>          ["persistent"]=>
>          bool(false)
>        }
>      }
>    }
>    [6]=>
>    array(6) {
>      ["file"]=>
>      string(38)
> "/var/www/horde/lib/Horde/Prefs/sql.php"
>      ["line"]=>
>      int(121)
>      ["function"]=>
>      string(8) "_connect"
>      ["class"]=>
>      string(9) "prefs_sql"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(0) {
>      }
>    }
>    [7]=>
>    array(6) {
>      ["file"]=>
>      string(37)
> "/var/www/horde/lib/Horde/Registry.php"
>      ["line"]=>
>      int(960)
>      ["function"]=>
>      string(8) "retrieve"
>      ["class"]=>
>      string(9) "prefs_sql"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(0) {
>      }
>    }
>    [8]=>
>    array(6) {
>      ["file"]=>
>      string(37)
> "/var/www/horde/lib/Horde/Registry.php"
>      ["line"]=>
>      int(785)
>      ["function"]=>
>      string(9) "loadprefs"
>      ["class"]=>
>      string(8) "registry"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(1) {
>        [0]=>
>        &string(5) "horde"
>      }
>    }
>    [9]=>
>    array(6) {
>      ["file"]=>
>      string(27) "/var/www/horde/lib/base.php"
>      ["line"]=>
>      int(39)
>      ["function"]=>
>      string(7) "pushapp"
>      ["class"]=>
>      string(8) "registry"
>      ["type"]=>
>      string(2) "->"
>      ["args"]=>
>      array(2) {
>        [0]=>
>        &string(5) "horde"
>        [1]=>
>        &bool(true)
>      }
>    }
>    [10]=>
>    array(4) {
>      ["file"]=>
>      string(36)
> "/var/www/horde/admin/setup/index.php"
>      ["line"]=>
>      int(13)
>      ["args"]=>
>      array(1) {
>        [0]=>
>        string(27) "/var/www/horde/lib/base.php"
>      }
>      ["function"]=>
>      string(12) "require_once"
>    }
>  }
>  ["callback"]=>
>  NULL
> }
>
>
> Thanks.
> Javier
>
> __________________________________________________
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
> ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



-- 

Bill Graham
Systems Administrator
Hurley Public Schools
Hurley,SD 57036
USA
grahamcw at hurleybulldogs.com


----------------------------------------------------------------
This electronic  mail sent from Hurley Public Schools - Hurley, South Dakota
http://www.hurleybulldogs.com

NOTICE: This E-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is 
confidential and may be legally privileged. If you are not the intended 
recipient, you are hereby notified that any retention, dissemination, 
distribution, or copying of this communication is strictly prohibited. 
Please reply to the sender that you have received the message in error, 
then delete it. Thank you.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1375 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/horde/attachments/20060604/b438cd85/attachment.bin


More information about the horde mailing list