#mysql - Tue 3 Apr 2007 between 15:03 and 15:11

NY Lost Funds



snoyesxover: 18446744073709551615
niquiperlmonkey: you want to give all privileges to the user 'admin' who's allowed to connect from anywhere? then use a % for the host part (i.e., 'admin'@'%'). though, are you sure you want to have a user like that out there allowed to connect from anywhere and do anything?
EMPER0Rhey in my freeradius db. have many users connecting from many phones.. how can i select the users where connect for >= 3 phones ?
jan____hey EMPER0R we got your question
perlmonkeyniqui: you have a point, it's so I can connect from my workstation or laptop on the local network? is % too much?
snoyesEMPER0R: so, you have a user's table, and a connections table which contains a radacct field, and is that one row in connections per phone?
EMPER0Ryes
of course
niquiperlmonkey: well, '%' will let the whole internet in if you aren't firewalled, so... :-)
EMPER0Rusername
xoversnoyes: so serial is type bigint
perlmonkeywoah
EMPER0Rand calling station id
cacahuateM_AxL_M, I'm not too sure what you mean with 'lost data'. Are you wanting to group by col1, but see how many of those have col2= '1'?
perlmonkeylocalhost is better?
niquiperlmonkey: if you're only connecting from localhost, yeah, just put localhost in.
snoyesSELECT username, COUNT(*) FROM users JOIN connections ON userId = radacct GROUP BY userId HAVING COUNT(*) >= 3;
perlmonkeybut wont localhost limit to direct connections on actual server?
niquiperlmonkey: you can always allow more than one host if you need to.
snoyesxover: yes, SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
perlmonkeyoh
quinteni'm sorry to ask a basic sql question, but is this possible: select all objects in t1 where a person listed in t3 is a member of a group listed in t2 as having access to t1
snoyeskyle: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
quinten: SELECT objects FROM t1 JOIN t2 USING (objectId) JOIN t3 USING (groupId) WHERE t3.personId = 42;
M_AxL_Mcacahuate: well "lost data" means : exmple : 2 rows with same data except the date data which are different. If I do a "GROUP BY" on the query I could get only one row as a result. So I d have only one date : so I lost data.. Is this clearer ?
snoyesM_AxL_M: So why use the GROUP BY at all then?
xoversnoyes: thanks
EMPER0Rso
?
M_AxL_Msnoyes: Cause I must group some data
EMPER0Ri guees with this but only showme theusers
SELECT distinct UserName FROM radacct where CallingStationId >= 3
snoyesEMPER0R: SELECT username, COUNT(*) FROM users JOIN connections ON userId = radacct GROUP BY userId HAVING COUNT(*) >= 3;
perlmonkeydoes anyone use mysql administrator? im not able to access the control services section :(
EMPER0Ruhm
let me try
XgcM_AxL_M: Maybe you mean to use ORDER BY, not GROUP BY.
snoyesEMPER0R: that might need to be COUNT(DISTINCT CallingStationId) instead of COUNT(*)
M_AxL_MXgc: no .. thanks
EMPER0Rsnoyes: where?

Page: 2 9 16 23 30 37 44 51 58 65 72 

IrcArchive

NY Lost Funds