Discover new friends and places around you

Check in at Koprol and have conversations with people in your area. You can also find restaurants & shops nearby and give your own rating. Works on your phone!

Create Your Account
ndra16

ndra16 @ Kampung Beru

dibuat pusing dengan simultaneous use! butuh bantuan segera...

over 1 year ago via web •

16 comments
ndra16
ndra16 hehe..stress jg ya, dah uncomment "simul_count_query" tetep bisa login dobel. @vcool, please help me..

vcool
vcool coba hotfix pakai strtolower() buat login pagenya (kalau pakai php)

vcool
vcool atau http://wiki.freeradius.org/Rlm_radutmp

vcool
vcool atau http://freeradius.org/radiusd/raddb/sql.conf

ndra16
ndra16 login page pake bawaan coova yg di modif css-nya

vcool
vcool sql.conf / dialup.conf nya aja yang dimodif, tambahin Binary di clausa where nya

ndra16
ndra16 sepetinya sql.conf sama, radutmp/sradutmp dah sama persis...

vcool
vcool dialup.conf nya simul_querynya beda

ndra16
ndra16 simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"

vcool
vcool where binary(UserName)

ndra16
ndra16 WHERE username = BINARY '%{SQL-User-Name} <-- gini ya?

ndra16
ndra16 simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE username = BINARY '%{SQL-User-Name}' AND AcctStopTime = 0"

vcool
vcool "SELECT COUNT(*) FROM ${acct_table1} WHERE BINARY(username)= '%{SQL-User-Name}' AND AcctStopTime = 0"

ndra16
ndra16 itu untuk simul_count_query aja ya? ato simul_verify_query juga?

ndra16
ndra16 dah coba, masih tetep bisa multiple login nih...

ndra16
ndra16 dah beres bos.. pokok yg ada where username aku ganti semua :D Problem solved, Tengkyu very much..