Hi, I have two servers A and B configured. I have some doubts: I would like to get to copy accounting data (same set of information) from A to B. I have configured this and works fine (copy-acct-to-home-server & proxy.conf), BUT in radacct table of server B, the records have different acctstartime and different acctstoptime from server A. I know that this happens because server B catchs its time and records it (exists a delay - few seconds). In other post, suggest me modify sql queries to get this (I should catch time of packet that send A - Event-Timestamp, and record it). For do this, I have thought in to check "Packet-Src-IP-Address" and if it is equal to B's address, I have to use my query modified. I have a problem, "Event-Timestamp" has the follows format: "Oct 26 2011 13:03:14 CEST" and I want to get yyyy-mm-dd HH:MM:ss (mysql format and current format of freeradius' dates). Do you know how can I do it? I can't believe that I can't do this more easy... Any suggestions? I have to think that I will get it... Thanks and regards! -- View this message in context: http://freeradius.1045715.n5.nabble.com/Anybody-can-confirm-this-tp4939606p4... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Hi everybody, Anybody can tell me something about this? I can't believe that if in copy-acct-to-home-server file specifies "That way, each server has the same set of information, and can make the same decision about the user", I can't get the same set of accounting information. Or this is wrong or I have a mistake (I have not modified default configuration, only some parameters to specify my lan configuration). I hope your answers and advices. Best regards, -- View this message in context: http://freeradius.1045715.n5.nabble.com/Anybody-can-confirm-this-tp4939606p4... Sent from the FreeRadius - User mailing list archive at Nabble.com.
tonimanel wrote:
Anybody can tell me something about this? I can't believe that if in copy-acct-to-home-server file specifies "That way, each server has the same set of information, and can make the same decision about the user", I can't get the same set of accounting information. Or this is wrong or I have a mistake (I have not modified default configuration, only some parameters to specify my lan configuration).
That's how RADIUS works. Packets may be lost, and information changes over time. radrelay will make the two systems as identical as possible given packet loss, time delay, etc. But *no* synchronization method is perfect. You must live with small differences between the two systems. Alan DeKok.
On Fri, Nov 4, 2011 at 7:50 PM, tonimanel <antoniofernandez@fabergames.com> wrote:
Hi everybody,
Anybody can tell me something about this? I can't believe that if in copy-acct-to-home-server file specifies "That way, each server has the same set of information, and can make the same decision about the user", I can't get the same set of accounting information. Or this is wrong or I have a mistake (I have not modified default configuration, only some parameters to specify my lan configuration).
I hope your answers and advices.
- Have you tried it? What's the result? - Does your NAS sends Event-Timestamp in your test? -- Fajar
Hi, I have not tried it yet (to build my own sql query). Have you got any idea to do this? I think that I should to check source ip address and then execute one or another query. I have checked Event-Timestamp parameter in packet that NAS sends to radius server only. I have a question. I think that there are a lot of companies that are using FreeRADIUS currently. Do you think that they have not thought in replicate the same set of information (same records in more than one database)? Or maybe they have thought in other solutions types? Thanks. I hope your answers and advices. Best regards, -- View this message in context: http://freeradius.1045715.n5.nabble.com/Anybody-can-confirm-this-tp4939606p4... Sent from the FreeRadius - User mailing list archive at Nabble.com.
On 4 Nov 2011, at 16:57, tonimanel wrote:
Hi,
I have not tried it yet (to build my own sql query). Have you got any idea to do this? I think that I should to check source ip address and then execute one or another query.
I have checked Event-Timestamp parameter in packet that NAS sends to radius server only.
I have a question. I think that there are a lot of companies that are using FreeRADIUS currently. Do you think that they have not thought in replicate the same set of information (same records in more than one database)? Or maybe they have thought in other solutions types?
Mmm yes, they use the arguably more sane approach of clustered databases or database replication. -Arran Arran Cudbard-Bell a.cudbardb@freeradius.org Betelwiki, Betelwiki, Betelwiki.... http://wiki.freeradius.org/ !
participants (4)
-
Alan DeKok -
Arran Cudbard-Bell -
Fajar A. Nugraha -
tonimanel