how to connect to database

[ljl]

hello everyone
there is some questions ,I need you help

How can I use JSP page to connect to mysql database of zimbra.

Could anybody help me about this please?

Thanks a lot for your kindly help.

best regards

[Klug]

Please stop crossposting in all subforums.

Could you please explain a bit more what you want to do ?
Do you "just" need to access mysql database ?
Or do you want to develop some JSP pages ?

[ljl]

hi

Originally Posted by Klug

Please stop crossposting in all subforums.

Could you please explain a bit more what you want to do ?
Do you "just" need to access mysql database ?
Or do you want to develop some JSP pages ?

This question is very argent,so I put this message every where.

I am so sorry to do that , I just need your help.

My question is :

I need to connect to Zimbra's Mysql database use Java language.

In my opinion ,Zimbra's database is database pool ,the port is 7306, but I can not get this connection, is anyone could tell me about this ?

by the way , I am from China , my English is very poor ,so if I say some wrong words ,please fogive me.

best regrads

[cvidal]

Originally Posted by ljl

...
I need to connect to Zimbra's Mysql database use Java language.

In my opinion ,Zimbra's database is database pool ,the port is 7306, but I can not get this connection, is anyone could tell me about this ?

You probably need the correct MySQL password. The following script will give you MySQL access and at the same time will show you the database root password:

#!/bin/bash
#

source ~zimbra/bin/zmshutil || exit 1
zmsetvars zimbra_home mysql_directory mysql_socket mysql_root_password

echo ${mysql_root_password}

${mysql_directory}/bin/mysql -h localhost -P 7306 --protocol=tcp \
        --user=root --password=${mysql_root_password} $*

From Java you can use the same user, password, host and port.

I hope it helps :-)

Carlos

[Artturi]

Hello,

There may also be some version problems since zimbra uses mysql 5 and there has been changes regarding password storage or authentication between mysql 4 & 5.

So it may be worth checking your client libraries if it doesn't work.

Regards,

[mrojek]

In defuals you cann't connect to zimbra Mysql server from remonte host. It is blocked you must chnage it in mysql config file. Of course if you have god user and password for user. In defaults are 2 user zimbra and if I good remamber admin

[moiseev.igor]

For one how ends-up on the page searching for the solution, it seems there is one appropriate command to perform the task

zimbra@zimbra:/opt/zimbra$ zmmypasswd
Usage: $ zmmypasswd [ --root ] newpassword

By default, this script changes zimbra_myql_password. If the --root
option is specified, then mysql_root_passwd is changed. In both cases,
MySQL is updated with the new passwords. This script can not bail you
out of a situation where you have lost your mysql root password -
consult MySQL documentation to see how you can start the server
temporarily to skip grant tables, so you can override the root
password.