The "111" is the error code that MySQL generates. Check if your computer has a firewall, and make sure to enable port 3306 from external IPs
e.g. on redhat using ipchains-based firewall, add: -A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT to your /etc/sysconfig/ipchains file (or however the box is configured for the firewall). You'll also want to replace "-s 0/0" with something a little more restrictive. cheers.. Dan On Thu, 2 Jan 2003, Peter Lovatt wrote: > Hi > > Is '111' the IP it is trying to connect on? > > If so it is an invalid IP. > > If the IP is valid how are you trying to connect? > > Peter > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > Birmingham > UK > www.sunmaia.net > tel. 0121-242-1473 > International +44-121-242-1473 > ----------------------------------------------- > > -----Original Message----- > From: mnbv [mailto:[EMAIL PROTECTED]] > Sent: 02 January 2003 00:23 > To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users > Subject: RE: FAQ hosting site (was "Re: An Idea") > > > I really need your help, I installed MySQL and I can > connect to it through localhost but when trying to > access it from outside I get: > > ERROR 2003: Can't connect to MySQL server on 'IP' > (111) > > Any suggestions? > > Someone suggested that the problem is because the > server has 2 nics (2 ips set up). > > Does anyone know a solution for this? > > > --- Peter Lovatt <[EMAIL PROTECTED]> wrote: > > Hi > > > > Like the look of the way its taking shape. > > > > I am not sure if there is existing faq software > > (I've checked sourceforge > > and freshmeat without much luck) we could use, or if > > someone can do a better > > job :) but I have a content management system > > written, together with a lot > > of the search functionality needed for the faq. It > > can mix database stored > > content with static content, so it would probably do > > the job with a little > > work. It also does the membership > > authorisation/management. > > > > I'd be happy to build the software, if that helps. > > > > Let me know > > > > Peter > > > > ----------------------------------------------- > > Excellence in internet and open source software > > ----------------------------------------------- > > Sunmaia > > Birmingham > > UK > > www.sunmaia.net > > tel. 0121-242-1473 > > International +44-121-242-1473 > > ----------------------------------------------- > > > > -----Original Message----- > > From: Stefan Hinz, iConnect (Berlin) > > [mailto:[EMAIL PROTECTED]] > > Sent: 01 January 2003 21:26 > > To: David T-G; mysql users > > Subject: Re: FAQ hosting site (was "Re: An Idea") > > > > > > David, > > > > > Sure; it's the least I can do. Look for > > mysql.justpickone.org to be > > in > > > the DNS tables by tomorrow. By then the > > [EMAIL PROTECTED] > > > mailing list will be ready for subscriptions, too. > > > > Fine. http://mysql.justpickone.org/ works :) > > > > > Now, what do we need to do to be able to update > > this FAQ? I can't > > create > > > ssh accounts for everyone, but we might arrange > > ftp > > > > Let's set up a PHP thing with MySQL. That's quite > > fast and easy to do. I > > could contribute some code. > > > > My suggestions (database design): > > > > 1. We need an authors table, and everyone who wants > > to be an author > > (contributor) can mail you, and you will set up > > accounts for these > > persons. The authors table will, of course, be used > > for database > > authentification / to update the admin pages. > > > > 2. For the actual content, we will need only one > > table, with question > > (varchar), answer (text), timestamp and a couple of > > id's that refer to > > other tables. > > > > 3. For the beginning, I would suggest we only have > > two more tables: > > category (installation, privilege system, ..., > > generally speaking, the > > main chapters of the manual) and difficulty > > (beginner, advanced, > > expert). _Not_ to be edited by the authors, to keep > > the FAQ smooth and > > simple. > > > > - We can make this more complex when necessity > > comes, with ratings, > > automated checks for double entries etc. > > > > My suggestions (frontend): > > > > 1. For end users, a very simple search. As Jim > > (JamesD) pointed out, > > Alkaline could do the job. Then again, Alkaline will > > search (and before, > > index) documents, and not databases. For the > > beginning, I would prefer > > just a simple input box for the search. > > > > 2. Output preferably as html files, i.e. nothing > > like > > > "index.php?cat=installation&difficulty=beginner&searchterm=windows", > > but > > rather something like > > "/installation/beginner/windows/1.html". IMHO, > > this is easier to refer to in a mailing list, and > > easier to click. Maybe > > we can set up Alkaline on those html files, as an > > alternative search for > > the database search. > > > > 3. Authors should be instructed to first search via > > the end user > > interface before inserting a new entry. If they do > > want to insert > > something new, they should simply select category, > > difficulty, paste the > > question, type (or paste) the answer. > > > > 4. The author login should be extremely convenient, > > with a persistent > > cookie, so an author will not actually have to login > > more than once > > (from the same browser/machine). > > > > 5. An author should be able to insert new content > > and to update his / > > her own content, nothing else. > > > > - What I said about database design applies to the > > frontend, too. We can > > make it more complex later on, when the need arises. > > We can have user > > contributed notes, fine grained search criteria, > > etc. In the beginning, > > I would suggest to follow the KISS principle (keep > > it simple & stupid). > > > > I send this to the list, because > > > > a) maybe someone has written exactly what we want, > > or can give a URL to > > where to find it, > > > > b) maybe someone has better ideas or comments on > > this. > > > > > By then the [EMAIL PROTECTED] > > > mailing list will be ready for subscriptions, too. > > > > Great. We should discuss everything else via this > > list, then. > > > > Regards, > > -- > > Stefan Hinz <[EMAIL PROTECTED]> > > Geschäftsführer / CEO iConnect GmbH > > <http://iConnect.de> > > Heesestr. 6, 12169 Berlin (Germany) > > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > > > ----- Original Message ----- > > From: "David T-G" <[EMAIL PROTECTED]> > > To: "mysql users" <[EMAIL PROTECTED]> > > Cc: "Stefan Hinz, iConnect (Berlin)" > > <[EMAIL PROTECTED]> > > Sent: Wednesday, January 01, 2003 4:12 PM > > Subject: Re: FAQ hosting site (was "Re: An Idea") > > > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > Hash: SHA1 > > > > > > Stefan, et al -- > > > > > > ...and then Stefan Hinz, iConnect (Berlin) said... > > > % > > > % David, > > > % > > > % > see it dropped if they don't jump on it at the > > start. > > > % > > > % I agree. Will you set it up at > > http://justpickone.org/? (BTW, I like > > > > > > Sure; it's the least I can do. Look for > > mysql.justpickone.org to be > > in > > > the DNS tables by tomorrow. By then the > > [EMAIL PROTECTED] > > > mailing list will be ready for subscriptions, too. > > > > > > Now, what do we need to do to be able to update > > this FAQ? I can't > > create > > > ssh accounts for everyone, but we might arrange > > ftp (I wish we could > > > === message truncated === > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Regards, Dan Goodes PlanetMirror Admin http://planetmirror.com/ [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
