List:General Discussion« Previous MessageNext Message »
From:walt Date:October 22 2002 9:10pm
Subject:Re: lost connection inquery : ODBC
View as plain text  
Petre Agenbag wrote:

> That works fine, I can log in as my root user and the perms look fine, I
> also use phpmyadmin, and looks fine too, can access all my db's that
> way, just the odbc that seems to be bitchin.
> It's not a train smash, I exported it to my older rh7.0 server over the
> net, but I'd still like to know for future what causes this, as I'm to
> decide soon what to upgrade to, 7.3 or 8.0, at this point, I'm leaning
> heavily towards 7.3 as my gutt tells me this might be some kind of a
> bug.
>
> Thanks for the help so far.
>
> On Tue, 2002-10-22 at 22:07, walt wrote:
> > On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote:
> > > Hi Walt
> > > Thanks for the quick reply.
> > >
> > > Answer to both questions is yes.
> > > As a matter of interest,
> > > What I usually do is to create a "myodbc" db with a "myodbc" user and
> > > password "myodbc"
> > > I create this db and user with the mysql_setpermission util, and I use
> > > "%" for the host name.
> > > YET, when I try to connect from the localhost, it denies permission,
> > > only accepts connections from remote location ( not ODBC though, I used
> > > a php script on another host to test connection)
> > >
> > > Any ideas?
> > >
> > > Thanks
> > >
> > > On Tue, 2002-10-22 at 21:37, walt wrote:
> > > > Petre Agenbag wrote:
> > > > > query , sql
> > > > >
> > > > > Hi
> > > > > Any known issues with RH8.0 and ODBC?
> > > > > I keep getting lost connection messages when trying to connect
> from a
> > > > > windows box to mysql, it worked 100% on a 7.3RH box.
> > > > > There is no firewall.
> > > > > Any workarounds?
> > > > >
> > > > >
> ---------------------------------------------------------------------
> > > > > 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
> <mysql-thread122934@stripped>
> > > > > To unsubscribe, e-mail
> > > > > <mysql-unsubscribe-kernel=nea-fast.com@stripped>
> Trouble
> > > > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > > >
> > <snip>
> >
> > Petre,
> > I've never used  the mysql_setpermission util before so I'm really not sure.
> > Have you tried logging in on the server using the OS mysql user?
> > To clarify -
> > su - mysql
> > /usr/bin/mysql
> >
> > If you can get in that way, you can look at the different user permissions and
> > possibly see what's wrong
> >
> >
> > --
> > Walter Anthony
> > System Administrator
> > National Electronic Attachment
> > Atlanta, Georgia
> > 1-800-782-5150 ext. 1608
> >  "If it's not broke....tweak it"
>
> ---------------------------------------------------------------------
> 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 <mysql-thread122953@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-kernel=nea-fast.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

IMHO  stick with 7.3
Both use 2.4.18-x kernels so you're really not getting anything out of 8.0 but gcc3
and some lost functionality from
kde. Be careful upgrading glib packages on 7.3 as there some issues with client
breakage due to one of the updates
(check the mysql archives).
We're using  2.4.18-SGI_XFS_1.1enterprise from SGI and have been thrilled with it.
The journaling is a must since we
have 300+ GB of data on the server which takes about an hour to fsck. We've been
running SGI kernels
for several years without any problems (knock on wook!).
http://oss.sgi.com/projects/xfs/

walt

Thread
lost connection inquery : ODBCPetre Agenbag22 Oct
  • Re: lost connection inquery : ODBCwalt22 Oct
    • Re: lost connection inquery : ODBCPetre Agenbag22 Oct
      • Re: lost connection inquery : ODBCwalt23 Oct
        • Re: lost connection inquery : ODBCPetre Agenbag23 Oct
        • Re: lost connection inquery : ODBCPetre Agenbag23 Oct
  • Re: lost connection inquery : ODBCwalt23 Oct
  • re: lost connection inquery : ODBCEgor Egorov23 Oct