Yes, you need to specify the IP address that you plan on using for this process instead of the computer name.
If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2" You setup a DSN-less connection to your db. Case #2 has actually worked much faster for me. You can just put the IP in your connection code and off you go. Either way, you need to do this because the OS cannot resolve how you want it done. Just to make sure it is two NIC's that is causing your problem, disable one in the IP configuration area and give it a try. If you still cannot connect to your db, then something else may also be wrong. Bruce ----- Original Message ----- From: "Peter Lovatt" <[EMAIL PROTECTED]> To: "mnbv" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 6:25 PM Subject: RE: FAQ hosting site (was "Re: An Idea") > 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 > > --------------------------------------------------------------------- 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
