Zimbra database and phpMyAdmin

[padial]

i have this 2 config files

/etc/php5/apache2/php.ini

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =/opt/zimbra/db/mysql.sock

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =localhost:7306

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

/etc/phpmyadmin/config.inc.php

//                                                    // and "mysql/db" tables).
//                                                    // The controluser is also
//                                                    // used for all relational
//                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = '123456';          // MySQL password (only needed
//                                                    // with 'config' auth_type)
//$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
//                                                    // this db is displayed in left frame
//                                                    // It may also be an array of db-names, where sorting order is relevant.

[padial]

Originally Posted by Nurlan

Could you show log?

which specific log do you want??

thanks

[Nurlan]

are you shure that ZIMBRA MYSQL PASSWORD is '123456' ??
you could check it typing this:
su - zimbra
zmlocalconfig -s | grep mysql | grep zimbra_mysql_password

[ghero]

Hello to all!

Here is little how to phpmyadmin with zimbra ...

First of ...
download phpmyadmin
change port on apache to 82
remove my.cnf and php.ini from /etc
make symlink from /opt/zimbra/conf/php.ini to /etc
and make symlink from /opt/zimbra/conf/my.cnf to /etc

php.ini
extension=/usr/lib64/php/modules/mcrypt.so
extension=/usr/lib64/php/modules/mbstring.so
extension=/usr/lib64/php/modules/mysql.so
mysql.default_socket =/opt/zimbra/db/mysql.sock
mysql.default_host =localhost:7306

my.cnf
first do: su - zimbra
then: zmlocalconfig -s
there you'll find mysql root password
After that add this lines:
user:"root"
pass:"password"

phpmyadmin
go to /usr/share/phpmyadmin/
and edit config.inc.php

$cfg['blowfish_secret'] = 'mysql_root_password'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

THE END

hope you find this useful.

[GKaz]

ghero, this didn't work for me. not sure what i'm doing wrong.

[ghero]

Hi GKaz,

Could you tell me what system you use, and what error you get?