Thanks Mark - I missed this message the first time around, glad I came across it as that saves a step for sure!
-Chris ----- Original Message ----- From: "Mark V" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 11:37 AM Subject: Re: Getting remote connected machine as value in a select. > FYI, > If you only want the hostname, and not the user, > combine the USER() with a SUBSTRING_INDEX(): > > SUBSTRING_INDEX(USER(),'@',-1) --> returns host only > SUBSTRING_INDEX(USER(),'@',1) --> returns username > only > > USER(), SESSION_USER(), and SYSTEM_USER() are all > synonymous > > CURRENT_USER() however is different in that it returns > the username and hostname that the current session was > authenticated as. > > I too am unaware of how to prevent the truncation of > string. If anyone knows, I myself would be very > interested. > > Thanks, > -Mark > > --- Chris Faust <[EMAIL PROTECTED]> wrote: > > That is good to know Emery.. > > > > I think I'll be ok in that respects, I did the > > permissions so the granted > > host is by IP (ex 192.168.0.%), so I'm getting IP > > back and I'm using the > > same username for all and its not truncated - so I > > think I'm good to go!! > > > > I just my first test on my dev server and everything > > worked exactly as I > > hoped! > > > > Thanks > > -Chris > > > > ----- Original Message ----- > > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > To: "Chris Faust" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Monday, October 20, 2003 9:48 AM > > Subject: Re: Getting remote connected machine as > > value in a select. > > > > > > > You are welcome. > > > But remember that sometimes it truncates the name. > > > For example I sometimes connect from my laptop > > using nzeyimana as username > > > and it just returns [EMAIL PROTECTED] instead of > > returning > > > [EMAIL PROTECTED] > > > (it just removes the last P). > > > > > > I don't know why. Maybe someone on the list may > > help on this issue. > > > Also as I told you, I don't know the difference > > between USER() and > > > SESSION_USER() > > > > > > > > > Thanks > > > Emery > > > ----- Original Message ----- > > > From: "Chris Faust" <[EMAIL PROTECTED]> > > > To: "Director General: NEFACOMP" > > <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > > Sent: Monday, October 20, 2003 15:27 > > > Subject: Re: Getting remote connected machine as > > value in a select. > > > > > > > > > > Thanks Emery, > > > > > > > > That is exactly what I needed, it gives me back > > the IP of the machine > > I'm > > > > connecting from. > > > > This is going to allow me to remove so much > > machine specific code that > > we > > > > could put up a new server within mins if needed. > > > > > > > > Thanks Again > > > > -Chris > > > > > > > > ----- Original Message ----- > > > > From: "Director General: NEFACOMP" > > <[EMAIL PROTECTED]> > > > > To: "Chris Faust" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > > > Sent: Monday, October 20, 2003 4:38 AM > > > > Subject: Re: Getting remote connected machine as > > value in a select. > > > > > > > > > > > > > I don't know I well understand your problem. > > > > > There is a function SESSION_USER() in MySQL > > that returns the currently > > > > > connected user. The user string also returns > > the host from which he > > > > > connected in the form [EMAIL PROTECTED] > > > > > > > > > > So, by issuing the query: > > > > > SELECT SESSION_USER(), Table.* from Table > > > > > you will get the needed data. > > > > > > > > > > But the problem is that you will need to get > > the host name from that > > > > > username. Also it truncates the string when it > > is long > > > > > There is also USER() that returns the same > > [EMAIL PROTECTED] . I really don't > > > know > > > > > the real difference between the two functions. > > > > > > > > > > > > > > > Hope this helps > > > > > > > > > > > > > > > Thanks > > > > > Emery > > > > > ----- Original Message ----- > > > > > From: "Chris Faust" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]> > > > > > Sent: Sunday, October 19, 2003 23:55 > > > > > Subject: Getting remote connected machine as > > value in a select. > > > > > > > > > > > > > > > Hello, > > > > > > > > > > I'm curious as to if something is possible - I > > don't know if its > > > possible > > > > to > > > > > explain it right. > > > > > > > > > > I have a table which contains a bunch machine > > specific information, > > file > > > > > paths, names etc. > > > > > > > > > > What I would like to try and accomplish is > > when I query this table for > > > the > > > > > information I need, I also receive back a > > value (that I can define) > > that > > > > is > > > > > determined by the identity of the machine > > making the query - either by > > > IP > > > > > address or whatever. > > > > > > > > > > For an example say I have 3 machines total. > > > > > 1 mySQL DB Server > > > > > 2 web servers > > > > > > > > > > When I connect to mySQL from either of the 2 > > web servers and say > > > something > > > > > like "Select * from table", one of the values > > returned would be > > > something > > > > > like "web1" as that is what I defined to be > > the value for when machine > > > > > 192.168.0.4 connected to it. > > > > > It doesn't have to be IP, I'm just using that > > for a example. > > > > > > > > > > Any ideas on how to accomplish something like > > this? > > > > > mySql 4.0 > > > > > RH 9 > > > > > > > > > > Thanks > > > > > -Chris > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __________________________________ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
