Crashed Again!
I built a new server at my server farm because the old one was corrupt. I had a hunch it had to do with the new 500 GB hard drive I bought. I told them to check it out. Apparently, they didn't. It zapped my database. I went to deinstall and reinstall mysql from FBSD port, but when I run it I get this very undescriptive error: # Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/server312.web.vi.pid 070309 17:19:12 mysqld ended Helps a lot, doesn't it? Where do I begin with this? TIA, Drew - No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started.
Re: Crashed Again!
Never mind. I forgot this command: /usr/local/bin/mysql_install_db --user=mysql Drew2 Drew Jenkins [EMAIL PROTECTED] wrote: I built a new server at my server farm because the old one was corrupt. I had a hunch it had to do with the new 500 GB hard drive I bought. I told them to check it out. Apparently, they didn't. It zapped my database. I went to deinstall and reinstall mysql from FBSD port, but when I run it I get this very undescriptive error: # Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/server312.web.vi.pid 070309 17:19:12 mysqld ended Helps a lot, doesn't it? Where do I begin with this? TIA, Drew - No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. - Need Mail bonding? Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.
Problems w/ Grant Tables
Hi; I rebuilt mysql and injected the database which had user mysqluser and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: mysql CREATE USER dev IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.04 sec) mysql CREATE USER mysqluser IDENTIFIED BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'mysqluser'@'%' mysql mysql grant all on mrtablecloth.* to dev identified by 'pass'; Query OK, 0 rows affected (0.00 sec) mysql Bye server312# mysql -udev -ppass ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: YES) 2 mysql use authdaemon; Database changed mysql show tables; Empty set (0.02 sec) Is authdaemon the database that has the grant tables? What gives? How do I add users that I can use? TIA, Drew - The fish are biting. Get more visitors on your site using Yahoo! Search Marketing.
Re: Problems w/ Grant Tables
Problem solved: /usr/local/bin/mysql_fix_privilege_tables2 Drew Jenkins [EMAIL PROTECTED] wrote: Hi; I rebuilt mysql and injected the database which had user mysqluser and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: mysql CREATE USER dev IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.04 sec) mysql CREATE USER mysqluser IDENTIFIED BY 'pass'; ERROR 1396 (HY000): Operation CREATE USER failed for 'mysqluser'@'%' mysql mysql grant all on mrtablecloth.* to dev identified by 'pass'; Query OK, 0 rows affected (0.00 sec) mysql Bye server312# mysql -udev -ppass ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: YES) 2 mysql use authdaemon; Database changed mysql show tables; Empty set (0.02 sec) Is authdaemon the database that has the grant tables? What gives? How do I add users that I can use? TIA, Drew - The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. - Don't get soaked. Take a quick peek at the forecast with theYahoo! Search weather shortcut.
Re: Can't Bind to Port
- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 5:00:26 AM Subject: Re: Can't Bind to Port Try the command: find / -name mysql 2/dev/null then you will find out if you have multiple mysql installations on your system, which I consider highly likely. # find / -name mysql 2/dev/null find: 2: unknown option On 3 mar 2007, at 07.42, Drew Jenkins wrote: 26- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port server312# netstat -nlap tcp | grep 3306 tcp4 0 0 *.3306 *.*LISTEN So... mysqld *is* listening on 3306? Why does it complain that the port is being used and that it can't bind to it? server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost -- max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/87 ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy TIA, Drew __ __ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ Kine dies, Kinfolk dies, and thus at last yourself This I know that never dies, how a dead mans deeds are deemed. -- Elder edda Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news
Re: Can't Bind to Port
- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 10:24:54 AM Subject: Re: Can't Bind to Port be root/superuser; try it as find / -name mysql and then, (as in 2nd) send they instances of mysql that you do not want to /dev/null this assumes a *nix not MS WIndows install, I do believe... # find / -name mysql /usr/local/bin/mysql /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /usr/backup/usr/local/include/mysql /var/db/mysql /var/db/mysql/mysql I believe I want all of those ;) TIA, Drew Tommy Nordgren [EMAIL PROTECTED] Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA. http://answers.yahoo.com/dir/?link=listsid=396545367
Re: Can't Bind to Port
26- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 10:53:45 AM Subject: Re: Can't Bind to Port kill off the first instance, the port will/should free up and then you can start your [second] instance. # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- S 0:11.21 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my # kill -9 3986 # kill -9 4034 # ps wax | grep mysqld # netstat -nlap tcp | grep 3306 # /usr/local/bin/mysqld_safe [1] 14836 # Starting mysqld daemon with databases from /var/db/mysql # ps wax|grep mysqld 14836 p1 I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 14887 p1 I 0:00.15 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my # /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M 070303 9:03:10 InnoDB: Started; log sequence number 0 46403 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070303 9:03:10 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070303 9:03:10 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070303 9:03:10 [ERROR] Aborting Am I missing something here? TIA, Drew The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
Re: Can't Bind to Port
- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 11:25:37 AM Subject: Re: Can't Bind to Port I rebooted, then... server312# ps wax|grep mysqld server312# /usr/local/bin/mysqld_safe [1] 801 server312# Starting mysqld daemon with databases from /var/db/mysql server312# ps wax | grep mysqld 801 p0 S 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 849 p0 S 0:00.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M 070303 9:42:18 InnoDB: Started; log sequence number 0 46403 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070303 9:42:18 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070303 9:42:18 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070303 9:42:18 [ERROR] Aborting 070303 9:42:18 InnoDB: Starting shutdown... 070303 9:42:20 InnoDB: Shutdown completed; log sequence number 0 46403 070303 9:42:20 [Note] /usr/local/libexec/mysqld: Shutdown complete I must be the only person in this conversation that remains unconvinced that there are *two* mysql servers running. TIA, Drew Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121
Re: Can't Bind to Port
- Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 12:03:40 PM Subject: Re: Can't Bind to Port At this point, make certain that the mysql instance that you started (pid 801) is shut down properly, then probe at port 3306 to see what's going on. it's possible that you have some other application that's taking over that port. # kill -9 801 [1]Killed/usr/local/bin/mysqld_safe # netstat -nl|grep 3306 # Ed suggests it's a permissions problem. Since I've had a sea of permissions problems to deal with, I bet he's right. What files/ folders should I check for permissions, and what should those permissions be? TIA, Drew Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html
Re: Can't Bind to Port
- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 12:34:37 PM Subject: Re: Can't Bind to Port There is no need to be superuser to run find. But there can be problems if there is another find command earlier in the PATH, than the standard unix find utility. Try running : /usr/bin/find / -name 'mysqld' 2/dev/null # /usr/bin/find / -name 'mysqld' 2/dev/null find: 2: unknown option Again, it just doesn't like the2. As Ed suggested, I really believe it's probably a permissions problem, but I don't know what to look for or what to change it to. TIA, Drew Need Mail bonding? Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=listsid=396546091
Re: Can't Bind to Port
- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:03:30 PM Subject: Re: Can't Bind to Port You are probably using another shell than bash or another sh variant. No, I'm using bash...the standard shell. Didn't do anything fancy when I built out this server. Isn't there some other command(s) I could use to achieve the same effect? TIA, Drew 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news
Re: Can't Bind to Port
- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:06:16 PM Subject: Re: Can't Bind to Port None of those directories existed on my system. So I decided to try and find the ones to which you referred. The matches were inexact. Now, before I go changing permissions and regret a mistake, please advise me according to the following: # find / -name mysqld /usr/local/libexec/mysqld # find / -name mysql /usr/local/bin/mysql /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /var/db/mysql /var/db/mysql/mysql # ls -al /usr/local/libexec/mysqld -r-xr-xr-x 1 root wheel 5035236 Mar 1 06:53 /usr/local/libexec/mysqld # ls -al /usr/local/bin/mysql -r-xr-xr-x 1 root wheel 65644 Mar 1 06:37 /usr/local/bin/mysql # ls -al /usr/local/include/mysql total 348 drwxr-xr-x 2 root wheel 1024 Mar 1 06:37 . drwxr-xr-x 10 root wheel 1536 Mar 1 06:37 .. -r--r--r-- 1 root wheel 3785 Mar 1 06:37 errmsg.h -r--r--r-- 1 root wheel 6778 Mar 1 06:37 keycache.h -r--r--r-- 1 root wheel 20593 Mar 1 06:37 m_ctype.h -r--r--r-- 1 root wheel 7683 Mar 1 06:37 m_string.h -r--r--r-- 1 root wheel 1859 Mar 1 06:37 my_alloc.h -r--r--r-- 1 root wheel 31704 Mar 1 06:37 my_config.h -r--r--r-- 1 root wheel 4496 Mar 1 06:37 my_dbug.h -r--r--r-- 1 root wheel 3509 Mar 1 06:37 my_dir.h -r--r--r-- 1 root wheel 3000 Mar 1 06:37 my_getopt.h -r--r--r-- 1 root wheel 46625 Mar 1 06:37 my_global.h -r--r--r-- 1 root wheel 1515 Mar 1 06:37 my_list.h -r--r--r-- 1 root wheel 3611 Mar 1 06:37 my_net.h -r--r--r-- 1 root wheel 1591 Mar 1 06:37 my_no_pthread.h -r--r--r-- 1 root wheel 23125 Mar 1 06:37 my_pthread.h -r--r--r-- 1 root wheel 1784 Mar 1 06:37 my_semaphore.h -r--r--r-- 1 root wheel 36574 Mar 1 06:37 my_sys.h -r--r--r-- 1 root wheel 2710 Mar 1 06:37 my_xml.h -r--r--r-- 1 root wheel 33180 Mar 1 06:37 mysql.h -r--r--r-- 1 root wheel 17215 Mar 1 06:37 mysql_com.h -r--r--r-- 1 root wheel 1224 Mar 1 06:37 mysql_embed.h -r--r--r-- 1 root wheel 2184 Mar 1 06:37 mysql_time.h -r--r--r-- 1 root wheel800 Mar 1 06:37 mysql_version.h -r--r--r-- 1 root wheel 20111 Mar 1 06:37 mysqld_ername.h -r--r--r-- 1 root wheel 20166 Mar 1 06:37 mysqld_error.h -r--r--r-- 1 root wheel 9766 Mar 1 06:37 plugin.h -r--r--r-- 1 root wheel 1751 Mar 1 06:37 sql_common.h -r--r--r-- 1 root wheel 11049 Mar 1 06:37 sql_state.h -r--r--r-- 1 root wheel 1055 Mar 1 06:37 sslopt-case.h -r--r--r-- 1 root wheel 2212 Mar 1 06:37 sslopt-longopts.h -r--r--r-- 1 root wheel 1156 Mar 1 06:37 sslopt-vars.h -r--r--r-- 1 root wheel 1265 Mar 1 06:37 typelib.h # ls -al /usr/local/lib/mysql total 5770 drwxr-xr-x 2 root wheel 512 Mar 1 06:52 . drwxr-xr-x 12 root wheel 2560 Mar 1 06:37 .. -r--r--r-- 1 root wheel13338 Mar 1 06:52 libdbug.a -r--r--r-- 1 root wheel42044 Mar 1 06:52 libheap.a -r--r--r-- 1 root wheel 320090 Mar 1 06:52 libmyisam.a -r--r--r-- 1 root wheel24866 Mar 1 06:52 libmyisammrg.a -rw-r--r-- 1 root wheel 1331032 Mar 1 06:37 libmysqlclient.a -rwxr-xr-x 1 root wheel 896 Mar 1 06:37 libmysqlclient.la lrwxr-xr-x 1 root wheel 20 Mar 1 06:37 libmysqlclient.so - libmysqlclient.so.15 -rwxr-xr-x 1 root wheel 1030523 Mar 1 06:37 libmysqlclient.so.15 -rw-r--r-- 1 root wheel 1338384 Mar 1 06:37 libmysqlclient_r.a -rwxr-xr-x 1 root wheel 928 Mar 1 06:37 libmysqlclient_r.la lrwxr-xr-x 1 root wheel 22 Mar 1 06:37 libmysqlclient_r.so - libmysqlclient_r.so.15 -rwxr-xr-x 1 root wheel 1036507 Mar 1 06:37 libmysqlclient_r.so.15 -r--r--r-- 1 root wheel 299208 Mar 1 06:52 libmystrings.a -r--r--r-- 1 root wheel 268090 Mar 1 06:52 libmysys.a -r--r--r-- 1 root wheel12290 Mar 1 06:52 libvio.a # ls -al /usr/local/libdata/ldconfig/mysql -rw-r--r-- 1 root wheel 21 Mar 1 06:37 /usr/local/libdata/ldconfig/mysql # ls -al /usr/local/share/mysql total 936 drwxr-xr-x 26 root wheel1024 Mar 1 06:53 . drwxr-xr-x 24 root wheel1024 Mar 1 06:37 .. -r--r--r-- 1 root wheel 801 Mar 1 06:53 binary-configure drwxr-xr-x 2 root wheel1024 Mar 1 06:53 charsets drwxr-xr-x 2 root wheel 512 Mar 1 06:53 czech drwxr-xr-x 2 root wheel 512 Mar 1 06:53 danish drwxr-xr-x 2 root wheel 512 Mar 1 06:53 dutch drwxr-xr-x 2 root wheel 512 Mar 1 06:53 english -r--r--r-- 1 root wheel 356623 Mar 1 06:53 errmsg.txt drwxr-xr-x 2 root wheel 512 Mar 1 06:53 estonian -r--r--r-- 1 root wheel 399219 Mar 1 06:53 fill_help_tables.sql drwxr-xr-x 2 root wheel 512 Mar 1 06:53 french drwxr-xr-x 2 root wheel 512 Mar 1 06:53 german drwxr-xr-x 2 root wheel 512 Mar 1 06:53 greek drwxr-xr-x 2 root wheel 512 Mar 1 06:53 hungarian drwxr
Re: Can't Bind to Port
- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 1:39:14 PM Subject: Re: Can't Bind to Port Well, I don't know what you do with this one, Tommy. I just cut and pasted your command, but when I hit the up arrow to see the command again, there was that darn white space: server312# /usr/bin/find / -name 'mysqld' 2/dev/null find: 2: unknown option server312# /usr/bin/find / -name 'mysqld' 2 /dev/null How do I get around that?? TIA, Drew Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index
Re: Can't Bind to Port
20- Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 12:16:42 PM Subject: Re: Can't Bind to Port I figured it wouldn't hurt anything to change permissions on files, so I went ahead and changed all the permissions everywhere. I even deleted the symlinks and copied over the original files to which they pointed and changed those permissions to mysql:mysql. That didn't work. Again, here are the dirs in which I changed permissions: /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /var/db/mysql /var/db/mysql/mysql (Actually, some of these were already changed.) I changed permissions on this file, tried my command that has kept failing, then changed them back: /usr/local/libexec/mysqld I didn't change permissions for the following: /usr/local/bin/mysql They're still owned by root. Is that correct? Seemed it needed to be owned by root. At any rate, unless I've missed something, I think that settles the issue of this not being a permissions problem...I think! Any other ideas? Tommy, still can't run your command. TIA, Drew Drew Jenkins wrote: - Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 11:25:37 AM Subject: Re: Can't Bind to Port I rebooted, then... server312# ps wax|grep mysqld server312# /usr/local/bin/mysqld_safe [1] 801 server312# Starting mysqld daemon with databases from /var/db/mysql server312# ps wax | grep mysqld 801 p0 S 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 849 p0 S 0:00.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M 070303 9:42:18 InnoDB: Started; log sequence number 0 46403 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070303 9:42:18 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070303 9:42:18 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070303 9:42:18 [ERROR] Aborting 070303 9:42:18 InnoDB: Starting shutdown... 070303 9:42:20 InnoDB: Shutdown completed; log sequence number 0 46403 070303 9:42:20 [Note] /usr/local/libexec/mysqld: Shutdown complete I must be the only person in this conversation that remains unconvinced that there are *two* mysql servers running. TIA, Drew Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
Re: [MySQL] Re: Can't Bind to Port
- Original Message From: Ashley M. Kirchner [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 4:09:41 PM Subject: Re: [MySQL] Re: Can't Bind to Port This indicates that you did indeed start the daemon. So then why are you trying to start it again? Of course it's going to tell you there's a daemon already running. You started it with the mysqld_safe command. Note, mysqld is the daemon, whereas mysql is the client. If all you're trying to do it connect to the daemon, you need to run mysql, NOT mysqld. Your logic is sound. So I tried a number of things that don't need repeating. Then I thought to myself I should check out the page in the online manual that talks about max_allowd_packet: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html I decided after wasting so much time maybe I should read the entire page :) Turns out the manual is poorly written in this instance. The comments at the bottom elucidated what to do: * log onto mysql * enter this command: SET GLOBAL max_allowed_packet=1000; Done! Thanks all! Drew Have a burning question? Go to www.Answers.yahoo.com and get answers from real people who know.
Can't Bind to Port
Hi; I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this error: server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy I presume everything went well here until it went to bind to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise. TIA, Drew Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097
Re: Can't Bind to Port
- Original Message From: Borokov Smith [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 6:21:59 PM Subject: Re: Can't Bind to Port netstat -nlp | grep 3306 Option p requires a protocol. What protocol should I give it? Drew greetz, boro Drew Jenkins wrote: Hi; I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this error: server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy I presume everything went well here until it went to bind to the port. There's no other MySQL running on the server, so why can't it connect to the port? This server isn't yet set up with an URL, so if it's reading from rc.conf or what have you, that could be tripping it up. Please advise. TIA, Drew Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097 Looking for earth-friendly autos? Browse Top Cars by Green Rating at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/
Re: Can't Bind to Port
Oops. Forgot to add I passed it tcp as the protocol and it returned blank: # netstat -nlp tcp| grep 3306 # I presume that means nothing's listening on that port? If so, then why did nmap return mysql on that port? At any rate, what do? TIA, Drew Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097
Re: Can't Bind to Port
26- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port server312# netstat -nlap tcp | grep 3306 tcp4 0 0 *.3306 *.*LISTEN So... mysqld *is* listening on 3306? Why does it complain that the port is being used and that it can't bind to it? server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost --max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/87 ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy TIA, Drew It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/