Re: Mysql Bug 04/01/11
Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com wrote:
Re: Mysql Bug 04/01/11
Hi, On 2-4-2011 2:18, Thomas Dineen wrote: Can't find file: './mysql/host.frm' (errno: 13) http://tinyurl.com/3sc3ydx -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Bug 04/01/11
Am 02.04.2011 02:18, schrieb Thomas Dineen: Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup because at the end you have something running and understodd nothing! sounds like you never before had used mysql and missing all the basics from the first chapters in the well written documentation - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) you should read the manuals or use a operating system with packages which are idiot-proof, fedora does this for you: if [ ! -d $datadir/mysql ] ; then # First, make sure $datadir is there with correct permissions if [ ! -e $datadir -a ! -h $datadir ] then mkdir -p $datadir || exit 1 fi chown mysql:mysql $datadir chmod 0755 $datadir [ -x /sbin/restorecon ] /sbin/restorecon $datadir # Now create the database action $Initializing MySQL database: /usr/bin/mysql_install_db --datadir=$datadir --user=mysql ret=$? chown -R mysql:mysql $datadir if [ $ret -ne 0 ] ; then return $ret fi fi 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.) they CAN NOT BE FOUND if you have a fresh install and not used mysql_install_db and WHERE they are created depends on your configuration as said yesterday let me guess: you even have not spent any second for your my.cnf? [mysqld] datadir = /where/ever/you/want/your/databases/jesus/christ on my system typing mysql_ followed with 2 x TAB brings a list of commands since you think you must not use a environments package-system why in the world do you not look in your bin-folder at /usr/local/mysql/ and read some docs to understand that the mysql-database is the userdb [root@srv-rhsoft:~]$ mysql_ mysql_client_test mysql_convert_table_format mysql_fix_extensions mysql_secure_installation mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap mysql_configmysql_find_rows mysql_install_db mysql_setpermission mysql_upgrade mysql_waitpid signature.asc Description: OpenPGP digital signature
Re: Mysql Bug 04/01/11
Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. There is always someone that knows more than you but he's not shouting at you everytime you say something wrong. If you think that a question is not worth answering just dont answer, while if you answer do it in a useful way, so that all the community can only improve from it, do you find this useful? *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) *Solution*: RTFM Next time breathe 10 times deep, and reply! This is just my opinion. Sincerely, Claudio 2011/4/2 Reindl Harald h.rei...@thelounge.net Am 02.04.2011 02:18, schrieb Thomas Dineen: Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup because at the end you have something running and understodd nothing! sounds like you never before had used mysql and missing all the basics from the first chapters in the well written documentation - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) you should read the manuals or use a operating system with packages which are idiot-proof, fedora does this for you: if [ ! -d $datadir/mysql ] ; then # First, make sure $datadir is there with correct permissions if [ ! -e $datadir -a ! -h $datadir ] then mkdir -p $datadir || exit 1 fi chown mysql:mysql $datadir chmod 0755 $datadir [ -x /sbin/restorecon ] /sbin/restorecon $datadir # Now create the database action $Initializing MySQL database: /usr/bin/mysql_install_db --datadir=$datadir --user=mysql ret=$? chown -R mysql:mysql $datadir if [ $ret -ne 0 ] ; then return $ret fi fi 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.) they CAN NOT BE FOUND if you have a fresh install and not used mysql_install_db and WHERE they are created depends on your configuration as said yesterday let me guess: you even have not spent any second for your my.cnf? [mysqld] datadir = /where/ever/you/want/your/databases/jesus/christ on my system typing mysql_ followed with 2 x TAB brings a list of commands since you think you must not use a environments package-system why in the world do you not look in your bin-folder at /usr/local/mysql/ and read some docs to understand that the mysql-database is the userdb [root@srv-rhsoft:~]$ mysql_ mysql_client_test mysql_convert_table_format mysql_fix_extensionsmysql_secure_installation mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap mysql_configmysql_find_rows mysql_install_db mysql_setpermission mysql_upgrade mysql_waitpid -- Claudio
Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
Am 02.04.2011 02:18, schrieb Thomas Dineen: The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) BTW: you know google? Can't find file: './mysql/host.frm' (errno: 13) http://bugs.mysql.com/bug.php?id=1279 so this is a permissions-problem i guess there is a data-dir in the tar.gz you installed as root and you did not change its permissions Keep in mind that I have tried several dozen experiments over many late hours with a version host.frm from a older version of mysql with NO success! I have tried putting it in every possible location. Using 777 file permissions. you should not blind copy files without any idea what you are doing root@Sun# pwd /usr/local/mysql root@Sun# ls bin infoman mysql-test var host.frmlib my.cnf share include libexec mysql sql-bench delete the host.from from here and everywhere you placed it and please open your eyes if you too lazy read documentations you see the folder var? _ RTFM (google: mysql /usr/local default datadir): http://dev.mysql.com/doc/refman/5.0/en/starting-server.html If you get Errcode 13 (which means Permission denied) when starting mysqld, this means that the privileges of the data directory or its contents do not permit server access. In this case, you change the permissions for the involved files and directories so that the server has the right to use them. You can also start the server as root, but this raises security issues and should be avoided. On Unix, change location into the data directory and check the ownership of the data directory and its contents to make sure the server has access. For example, if the data directory is /usr/local/mysql/var, use this command: shell ls -la /usr/local/mysql/var If the data directory or its files or subdirectories are not owned by the login account that you use for running the server, change their ownership to that account. If the account is named mysql, use these commands: shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql/var signature.asc Description: OpenPGP digital signature
Re: Mysql Bug 04/01/11
Am 02.04.2011 13:11, schrieb Claudio Nanni: Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) *Solution*: RTFM Next time breathe 10 times deep, and reply! WTF? Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! and not look ONE TIME in the basic-manual in this 50 hours is the wrong way, everytime, everywhere and with every software peopole spent many hours to writing documentation! this is the start BEFORE mailing-list: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html yes, is something unclear after that there is a starting-point for questions but not i do not read docs, say me exactly where the problem is signature.asc Description: OpenPGP digital signature
Can't connect to MySQL server on '127.0.0.1' (111)
I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Am 02.04.2011 17:10, schrieb xPol: I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
I think you'll need to give us a bit more to go on. I presume this is a web based app? What have you changed? Has the MySQL daemon stopped? What have you changed? On Sat, Apr 2, 2011 at 4:10 PM, xPol xtek...@gmail.com wrote: I have been using my local dictionary for years, accessing from web browser, pointing to http://localhost:9000/ Probably my fault, since i have been tinkering a little with my settings. As i try to connect, i get Can't connect to MySQL server on '127.0.0.1' (111) Any ideas, what to check? I am using linux/opensuse 11.4 Thank you p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
SPAM: please remove gregario.es from the list
Can anybody remove this (i think spanish) autoreply-spammer from the list nbecause the only thing i understand is some price in € and that our spm-firewall is tagging it Original-Nachricht Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1' (111) Datum: 2 Apr 2011 17:17:20 +0200 Von:no-re...@gregario.es An: h.rei...@thelounge.net Estimad@, le informamos que su mensaje de correo electrónico _*no ha sido entregado al destinatario*_ ya que no existe el buzón de correo en el dominio Un saludo. Consigue gratis tu bono de 30 € para utilizar con Google Adwords http://www.googld.es/ Te regalamos una camiseta personalizada con tu foto http://clk.tradedoubler.com/click?p(22814)a(1548325)g(1076669)url(http://www.vistaprint.es/male-female-tshirts.aspx) signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Andrew Moore wrote: I think you'll need to give us a bit more to go on. I presume this is a web based app? yes What have you changed? Has the MySQL daemon stopped? What have you changed? from 'ps' i get 3545 0.0 0.1 194816 3292 ?Sl 13:58 0:08 /usr/sbin/mysqld -- defaults-file=/home/xpol/.local/share/akonadi//mysql.conf -- datadir=/home/xpol/.local/share/akonadi/db_data/ -- socket=/home/xpol/.local/share/akonadi/socket-ambi.site/mysql.socket So the demon appears to be running I do not think mysql conf files have been changed by me thank you --p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Reindl Harald wrote: Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Here incluede thank you p -- (xpol) % netstat --numeric-hosts --notrim --programs -u -t ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
please do not only post outputs, read them and try to understand before press send - not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all. in the ouptput says that all afterwards is useless netstat --numeric-hosts --notrim --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc i would assume something like skip-networking in your config if connection fails anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql Am 02.04.2011 17:36, schrieb xPol: Reindl Harald wrote: Did you make any change in the my.cnf? What does netstat --numeric-hosts --notrim --programs -u -t say? What is the content of your my.cnf? Here incluede thank you p -- (xpol) % netstat --numeric-hosts --notrim --programs -u -t ~ (17:32-Sat 2) (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:3831574.125.77.109:smtp TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:5392474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5392574.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5389474.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35673209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35672209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:48554209.85.149.105:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:35666209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:35667209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5392674.125.232.152:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:5432480.91.229.10:nntp ESTABLISHED 11402/knodeo10783.s --- (xpol) % cat /mnt/etc/my.cnf | grep -v ^# ~ (17:34-Sat 2) [client] port= 3306 socket = /var/run/mysql/mysql.sock [mysqld] port= 3306 socket = /var/run/mysql/mysql.sock datadir = /var/lib/mysql skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1 [safe_mysqld] log-error = /var/log/mysql/mysqld.log socket = /var/run/mysql/mysql.sock !include_dir /etc/mysql [mysqldump] socket = /var/run/mysql/mysql.sock quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin log= /var/log/mysqld_multi.log - -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ signature.asc Description: OpenPGP digital signature
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Reindl Harald wrote: please do not only post outputs, read them and try to understand before press send - not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all. in the ouptput says that all afterwards is useless netstat --numeric-hosts --notrim --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 sorry, i have re-enterd the command as root - here incuded /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that file system to compare with /etc/my.cnf They are the same, however. Here included also /etc/mysqlaccess.conf i would assume something like skip-networking in your config if connection fails it is there, but commented out: /etc/my.cnf:#skip-networking anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql / That dir contains: /etc/mysql/default_plugins.cnf its contents is here included thank you p 1- % ° netstat --numeric-hosts --notrim --programs -u -t ~ (18:09-Sat 2) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:6057774.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5420774.125.232.114:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:4954585.86.166.196:7168 TIME_WAIT - tcp0 0 10.121.243.241:5317374.125.232.150:https TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:39556209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:6057674.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:39551209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t TIME_WAIT - tcp0 0 10.121.243.241:39550209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5275883.51.48.124:44909 TIME_WAIT - tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:39555209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:3536582.56.169.37:19907 TIME_WAIT - tcp0 0 10.121.243.241:5728380.91.229.10:nntp ESTABLISHED 12106/knodec10783.s tcp0 0 10.121.243.241:4455274.125.232.150:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug 2 (xpol) % ° cat /etc/mysqlaccess.conf | grep -v ^# ~ (18:20-Sat 2) #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'}= 0; if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'table'} = 1; } 1; #to make require happy 3-- (xpol) % ° cat /etc/mysql/default_plugins.cnf ~ (18:20-Sat 2) [server] plugin-load=blackhole=ha_blackhole.so plugin-load=federated=ha_federated.so plugin-load=archive=ha_archive.so - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Please netstat --numeric-hosts --notrim --programs -u -t -l In my first answer i forgot the -l Without we get active connections, but we want the listening tcp-services where somewhere must by mysqld the easiest test is however [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. 5.5.10-log�K]qC7,t'��a4~Agb949^QXmysql_native_password if there is no connection we should find out why debug simply the web-app user on a local terminal to get error messages with more details as failed [harry@srv-rhsoft:~]$ mysql -h 127.0.0.1 -u myuser -p Enter password: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: NO) this example says more as failed bceause we see that connection is possible but authentication fails Am 02.04.2011 18:21, schrieb xPol: Reindl Harald wrote: please do not only post outputs, read them and try to understand before press send - not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all. in the ouptput says that all afterwards is useless netstat --numeric-hosts --notrim --programs -u -t -l as ROOT on the machine where mysql is running! alterante: telnet 127.0.0.1 3306 sorry, i have re-enterd the command as root - here incuded /mnt/etc/my.cnf is really your active mysql-config? normally /etc/my.cnf is used, even if /etc/ is a own disk/partition you should never mount it as /mnt/etc/ and managing with symlinks - mount it directly to /etc you're right, /mnt/etc/my.cnf is not my ususm cnf file I hd mounnted that file system to compare with /etc/my.cnf They are the same, however. Here included also /etc/mysqlaccess.conf i would assume something like skip-networking in your config if connection fails it is there, but commented out: /etc/my.cnf:#skip-networking anyways this mysql-config ma contain some includes because the line !include_dir /etc/mysql / That dir contains: /etc/mysql/default_plugins.cnf its contents is here included thank you p 1- % ° netstat --numeric-hosts --notrim --programs -u -t ~ (18:09-Sat 2) Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 10.121.243.241:6057774.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:5420774.125.232.114:www-http ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:4954585.86.166.196:7168 TIME_WAIT - tcp0 0 10.121.243.241:5317374.125.232.150:https TIME_WAIT - tcp0 0 127.0.0.1:50793 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:57336 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 10.121.243.241:39556209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:6057674.125.232.149:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:39551209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:4108983.233.30.55:ipsec-nat-t TIME_WAIT - tcp0 0 10.121.243.241:39550209.85.227.189:https TIME_WAIT - tcp0 0 10.121.243.241:5275883.51.48.124:44909 TIME_WAIT - tcp0 0 127.0.0.1:52722 127.0.0.1:48856 ESTABLISHED 6752/npviewer.bin tcp0 0 127.0.0.1:48856 127.0.0.1:52722 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 10.121.243.241:39555209.85.227.189:https ESTABLISHED 6252/firefox tcp0 0 10.121.243.241:3536582.56.169.37:19907 TIME_WAIT - tcp0 0 10.121.243.241:5728380.91.229.10:nntp ESTABLISHED 12106/knodec10783.s tcp0 0 10.121.243.241:4455274.125.232.150:https ESTABLISHED 6252/firefox tcp0 0 127.0.0.1:48856 127.0.0.1:50793 ESTABLISHED 6767/GoogleTalkPlug tcp0 0 127.0.0.1:48856 127.0.0.1:57336 ESTABLISHED 6767/GoogleTalkPlug 2 (xpol) % ° cat /etc/mysqlaccess.conf | grep -v ^# ~ (18:20-Sat 2) #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'}= 0; if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = '';
Re: Can't connect to MySQL server on '127.0.0.1' (111)
Reindl Harald wrote: Please netstat --numeric-hosts --notrim --programs -u -t -l In my first answer i forgot the -l i will check according to your suggstions If i find still in troubles, i will let you know thank you ---p -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Got It; Thank You; Re: Mysql Bug 04/01/11
Got It; Thank You, Thank You, Thank You On 4/1/2011 11:28 PM, Claudio Nanni wrote: Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com mailto:tdin...@ix.netcom.com wrote:
Re: map polygon data for popular us cities
you might be interested in this: http://simplegeo.ksikes.net https://github.com/alexksikes/simplegeo On Mon, Feb 7, 2011 at 7:29 AM, Sander de Bruijne san...@debruijne.eu wrote: http://www.geonames.org/ http://download.geonames.org/export/dump/?C=S;O=D On 02/02/2011 11:30 AM, viraj wrote: dear list, where can i find a list of map polygons for united states cities? any open database? or tool to obtain correct coordinates? i googled but couldn't find anything useful.. may be the terms i use are not the correct keywords :( any help or advice would be really appreciated. ~viraj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=alex.ksi...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org