Re: MySQL refusing to accept passwords
Shawn Green (MySQL) shawn.l.gr...@oracle.com pisze: (...) You can be the correct user, using the correct password but you may not be allowed (by the host pattern) to login from the machine from which you are attempting to login. It could be the case you got your account setup as username@localhost and it works fine, as long as you're using 'localhost' in your Workench connection window. Once changed to an IP address or a host name and from MySQL server perspective - as Shawn said - you're a different user. Regards, m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Free Navicat
Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Free Navicat
Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
Re: Free Navicat
Try using yum to install your rpm, it should search for the dependencies and install them if I'm not mistaken (or just don't use centos for desktop OS and save yourself all kinds of misery altogether :P). cheers, On Tue, Jul 26, 2011 at 14:35, Adarsh Sharma adarsh.sha...@orkash.comwrote: ** Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
RE: Free Navicat
you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Tue, 26 Jul 2011 17:05:58 +0530 From: adarsh.sha...@orkash.com To: li...@olindata.com CC: mysql@lists.mysql.com Subject: Re: Free Navicat Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
Re: Free Navicat
Thanks Walter, but I tried all the hooks crooks, In Ubuntu , following error occurs : root@lin-ws-15:~# apt-get install mysql-workbench Reading package lists... Done Building dependency tree Reading state information... Done E: Couldn't find package mysql-workbench root@lin- I think my own repository doesn't have that package but I put the rpm package in /var/ftp/pub/server follow below steps : createrepo -V server yum clean all yum list [root@ws-test ~]# yum install mysql-workbench Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * epel: mirrors.ustc.edu.cn Setting up Install Process No package mysql-workbench available. Nothing to do Walter Heck - OlinData.com wrote: Try using yum to install your rpm, it should search for the dependencies and install them if I'm not mistaken (or just don't use centos for desktop OS and save yourself all kinds of misery altogether :P). cheers, On Tue, Jul 26, 2011 at 14:35, Adarsh Sharma adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote: Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so http://liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
Re: Free Navicat
there are so many dependencies for mysql-workbench and i find it difficult after this error : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.33b-1el6.x86_64.rpm error: Failed dependencies: libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.33-1el6.x86_64 [root@ws-test Desktop]# Please guide me how to install these dependencies I tried but fails. Martin Gainty wrote: you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1 RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Tue, 26 Jul 2011 17:05:58 +0530 From: adarsh.sha...@orkash.com To: li...@olindata.com CC: mysql@lists.mysql.com Subject: Re: Free Navicat Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have
Chronicle of fixing broken replication, and a question
Yeah it happens to all of us. Some master-slave replication system breaks and goes unnoticed. In my case, I had a monitoring script, but it was being called with a --verbose flag, and internally that verbose was being mapped to debug, and the routine to notify sysadmins of broken replication doesn't fire if debug is set, so warning emails were not being sent out. You might ask, why is this a problem? Just restart replication, skipping problem statements. Well, the big issue was that I have automatic purge of binlogs set. Over the course of a few days, the purging of binlogs surpassed where the replication stopped. Damn... This is a mysql 5.0.77 (CentOS 5.x) installation with maatkit and xtrabackup utilities available. So there's really only one thing to do. xtrabackup to the rescue! 1. I did a full copy of the running master database server using xtrabackup to a backup server via nfs. It took 2 hours, of which the last 15 minutes did a write lock of the entire server as it copied over the *.frm files and the few myisam tables. This was the most troublesome part as it was visible to both users and website owners :-( 2. On the slave, I did the apply-logs step (via nfs to the backup server), taking another 2 hours. 3. I renamed the old directory on the slave server and created a new mysql directory, owned by the correct user. 4. I copied the backup data from the backup server to this new directory. 5. I deleted the iblogfile* files so that mysql would create them on startup based on the sizes set in the my.cnf. 6. I started it up. It still wanted to do a crash recovery since the ibdata and iblog files didn't match, but that was expected. After a few minutes of scanning (we use innodb_table_per_file, so it had a lot of tablespace spread out over lots of files), it started up and was accepting connections. Looking good so far. 7. I did 'cat xtrabackup_slave_info'. For some reason it had this: CHANGE MASTER TO MASTER_LOG_FILE='', MASTER_LOG_POS= *UH OH* *CRAP* *$#^@%!* ** See note below 8. Calm down, think about things a bit. Obviously I didn't compensate for the fact that I was doing the original backup on the master, but the apply-log on the slave (and --slave-info option doesn't have the data available on the 9. I know about what time I started the backup. I know that this is a database server dedicated to ecommerce shopping carts. As a result, there is a steady flow in of data as customers and web_robots access the shopping carts. 10. Knowing the data in #9, I look at the statements being replicated with mysqlbinlog on the master with --start-datetime=2011-07-25 12:00:00. A quick query of the data in that database on the newly-recovered-but-not-yet-replicating slave found me a last timestamp of 13:16.49. 11. I adjust my timestamp and trace data from that point until I find one that didn't get inserted into the database by the replication process (meaning, this was when I started the backup). I determined that the timestamp of data not yet in the database was 13:16:52. 12. Comments in mysqlbinlog output at that timestamp indicated it was at position 487727085. 13. I repeated the mysqlbinlog using --start-position 487727085 and verified that it was the same output as #12. 14. I did a change master statement on the slave, setting the position to 487727085, I started replication, and it caught up after about 20 minutes. 15. If #14 would have had issues, I did have mk-slave-restart available to force it to skip problems and restart replication. So everything is alright. There are no issues. But there is a question. Is there a better way to do this? Is there something automated that will compare THIS binlog to THAT server and tell me where the data was no longer being inserted ? I'm looking to see how others deal with a complete restart of a running system like this. ** It turns out that xtrabackup gave me confidence of the log position I had determined. Running the backup on the master, it also made this file: # cat xtrabackup_binlog_info mysqld-bin.000259 487727085 which of course confirmed the log position I determined in step #12. To be honest, the biggest step in the sequence above is likely #8. The ability to assess a situation without freaking out (for too long) is a big part of a sysadmin job IMHO. Regards... Todd -- If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic diseases. -- Dr. Walter Willett, Harvard School of Public Health -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Chronicle of fixing broken replication, and a question
Am 26.07.2011 16:18, schrieb Todd Lyons: 1. I did a full copy of the running master database server using xtrabackup to a backup server via nfs. It took 2 hours, of which the last 15 minutes did a write lock of the entire server as it copied over the *.frm files and the few myisam tables. This was the most troublesome part as it was visible to both users and website owners :-( why are not using two rsync-runs? the first while mysqld is running the second directly after stop mysqld this way you can be 100% sure that you can start the replication from scratch and your downtime is only a few seconds, best if enough space to have this target on the master-machine because while you take the slow way over the network the master is running with a fresh binlog #!/bin/bash rsync --times --perms --owner --group --recursive --delete-after /mysql_data/ /mysql_backup/ date /sbin/service mysqld stop cd /mysql_data/ rm -f /mysql_data/bin* rsync --times --perms --owner --group --recursive --delete-after /mysql_data/ /mysql_backup/ /sbin/service mysqld start signature.asc Description: OpenPGP digital signature
Re: Chronicle of fixing broken replication, and a question
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald h.rei...@thelounge.net wrote: 1. I did a full copy of the running master database server using xtrabackup to a backup server via nfs. It took 2 hours, of which the last 15 minutes did a write lock of the entire server as it copied over the *.frm files and the few myisam tables. This was the most troublesome part as it was visible to both users and website owners why are not using two rsync-runs? the first while mysqld is running the second directly after stop mysqld this way you can be 100% sure that you can start the replication from scratch and your downtime is only a few seconds, best if 43 GB is more than a few seconds. enough space to have this target on the master-machine because while you take the slow way over the network the master is running with a fresh binlog I tested a slightly modified version of your quickie script, first using the nfs share: Starting first rsync real37m48.201s Stopping MySQL:[ OK ] Starting second rsync real4m24.536s Starting MySQL:[ OK ] Then I ran it using local spindles: Starting first rsync real26m10.747s Stopping MySQL:[ OK ] Starting second rsync real3m11.945s Starting MySQL:[ OK ] So I could have lowerd the amount of time mysql was not available by quite a bit doing it that way. Plus I would have removed the requirement to apply-logs (due to not copying innodb files while they were open). In the end, xtrabackup worked as designed, but the fact that my large number of databases and tables and innodb_file_per_table slows things down tremendously, so it isn't the best fit in this case. ...Todd -- If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic diseases. -- Dr. Walter Willett, Harvard School of Public Health -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Chronicle of fixing broken replication, and a question
Am 26.07.2011 19:13, schrieb Todd Lyons: On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald h.rei...@thelounge.net wrote: 1. I did a full copy of the running master database server using xtrabackup to a backup server via nfs. It took 2 hours, of which the last 15 minutes did a write lock of the entire server as it copied over the *.frm files and the few myisam tables. This was the most troublesome part as it was visible to both users and website owners why are not using two rsync-runs? the first while mysqld is running the second directly after stop mysqld this way you can be 100% sure that you can start the replication from scratch and your downtime is only a few seconds, best if 43 GB is more than a few seconds. well, but it is faster in summary and without any pitfalls enough space to have this target on the master-machine because while you take the slow way over the network the master is running with a fresh binlog I tested a slightly modified version of your quickie script, first using the nfs share: Starting first rsync real 37m48.201s Stopping MySQL:[ OK ] Starting second rsync real 4m24.536s Starting MySQL:[ OK ] this is a good value for remote Then I ran it using local spindles: Starting first rsync real 26m10.747s Stopping MySQL:[ OK ] Starting second rsync real 3m11.945s Starting MySQL:[ OK ] weel, 3 minutes is a acceptable downtime with the benefit that the slave will be binary-identical and all old logs are gone away So I could have lowerd the amount of time mysql was not available by quite a bit doing it that way. Plus I would have removed the requirement to apply-logs (due to not copying innodb files while they were open). In the end, xtrabackup worked as designed, but the fact that my large number of databases and tables and innodb_file_per_table slows things down tremendously, so it isn't the best fit in this case with smaller databases it is the same, our main webserver has only 800 MB database files and here we are speaking really about few seconds for the second rsync and the only thing to do is re-init the replication after that - i find really no case where the rsync will not win at the end :-) i am doing this since years for all sort of backups (as example stopping the slave shortly and make a consistent off-site-backup) because i do not trust any tool which makes a hot-backup and trying a sync with binary logs signature.asc Description: OpenPGP digital signature