Parsing Logs

How to customize and extend your OpenVPN installation.

Moderators: TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech, TinCanTech

Post Reply
rain
OpenVpn Newbie
Posts: 1
Joined: Tue Nov 01, 2016 5:02 am

Parsing Logs

Post by rain » Tue Nov 01, 2016 5:05 am

So i created a disconnect script to parse per user logs, but Real Address and Connected Time don't show or inserted to the database.

Here's my code:
INSERT INTO user_logs (username, address, received, sent, since) VALUES ('$common_name', '$real_address', '$bytes_received', '$bytes_sent', '$connected_since'
Output:

Code: Select all

username
address
received
sent
since

princedastan79
(no inserted real address)
1525
4334
0000-00-00 00:00:00
Thank you guys.

Post Reply