{"id":192,"date":"2009-03-13T16:43:48","date_gmt":"2009-03-13T09:43:48","guid":{"rendered":"http:\/\/adityo.blog.binusian.org\/?p=192"},"modified":"2009-04-02T10:55:28","modified_gmt":"2009-04-02T03:55:28","slug":"how-to-create-mysql-tunneling-on-zimbra-using-putty","status":"publish","type":"post","link":"https:\/\/adityo.blog.binusian.org\/?p=192","title":{"rendered":"How to create mysql tunneling on Zimbra using putty"},"content":{"rendered":"

What is Tunneling ?<\/strong><\/p>\n

Tunneling, also known as “port forwarding,” is the transmission of data intended for use only within a private, usually corporate network through a public network in such a way that the routing<\/a> node<\/a>s in the public network are unaware that the transmission is part of a private network<\/p>\n

Okay the main reason why i want to do a mysql tunneling from zimbra is simply because i want to remotely access the mysql db on zimbra mail server, first i try to search how to install phpmyadmin on zimbra but it seems that we need to set virtual domain\u00a0 on \/opt\/zimbra\/httpd-2.2.8\/conf\/httpd.conf\u00a0 then upload the phpmyadmin on the virtual domain docoment root and set the port . it seems a long way for me :).\u00a0 So i tried to find another way i have heard about mysql tunneling before but how it is implemented i really don’t know so here is the step to create an msyql tunneling on your zimbra sevrer to your local PC<\/p>\n

Requirement:<\/p>\n

– Zimbra<\/a> server<\/p>\n

– Putty<\/a><\/p>\n

– HeidiSQL <\/a><\/p>\n

Setup<\/strong><\/p>\n

You need to have putty first you can download it here<\/a><\/p>\n

Then start use your putty, click your server session that already saved or type it on the Hostname pick SSH connection<\/p>\n

\"putty1\"<\/p>\n

Then load your saved session<\/p>\n

\"putty2\"<\/p>\n

Now we need to set the tunneling you can go to Connection -> SSH -> Tunnels<\/p>\n

\"putty3\"<\/p>\n

Now we need to insert the Source port and Destination ,<\/p>\n

Source port is the local port that we will use to connect our mysql admin agent int his tutorial i use HeidiSQL <\/a>on this tutorial i will use port 9998<\/p>\n

The “Desitination” is the address and port of your actual MySQL Server. But since your SSH connection will be considered “local” to your MySQL Server, you should use either “127.0.0.1” or “localhost” depending on what works best. Zimbra mysql use port 7306, localhost:7306<\/p>\n

you can checked it on your zimbra by entering zmlocalconfig -s | grep mysql | grep password<\/p>\n

zimbra@mail:\/root$ zmlocalconfig -s | grep mysql | grep port
\nlogger_mysql_port = 7307
\nmysql_port = 7306<\/p>\n

\"putty4\"<\/p>\n

Don’t forget to click Add button<\/p>\n

\"putty5\"<\/p>\n

\"putty6\"<\/p>\n

Go back to Session and save because your setting will be lost if you did not save anything<\/p>\n

\"putty7\"<\/p>\n

Then you just need to login as usual by clickin Open button, then login usin zimbra username and password<\/p>\n

\"putty8\"<\/p>\n

Now you need to test your localhost port 9998 connection on your pc, using telnet localhost 9998 on your command prompt it should show this<\/p>\n

\"putty9\"<\/p>\n

\n

Now you just need to configure your HeidiSQL or another mysql client software to connect to localhost port 9998<\/p>\n

\"putty101\"enter your zimbra mysql password, you can search it on your zimbra server by using this command zmlocalconfig -s | grep mysql | grep password<\/p>\n

zimbra@mail:\/root$ zmlocalconfig -s | grep mysql | grep password
\nmysql_logger_root_password = ****************
\nmysql_root_password = ******************
\nzimbra_logger_mysql_password = **********************
\nzimbra_mysql_password = **************<\/p>\n

then click connect, it will show your zimbra database<\/p>\n

\"putty11\"<\/p>\n","protected":false},"excerpt":{"rendered":"

What is Tunneling ? Tunneling, also known as “port forwarding,” is the transmission of data intended for use only within a private, usually corporate network through a public network in such a way that the routing nodes in the public network are unaware that the transmission is part of a private network Okay the main […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[495],"tags":[898],"class_list":["post-192","post","type-post","status-publish","format-standard","hentry","category-zimbra","tag-mysql-tunneling-on-zimbra"],"_links":{"self":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=192"}],"version-history":[{"count":7,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/192\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/192\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}