Shell Script to parse log and Convert to csv -


i need shell script parse log file , pattern. if paatern found, take key values line , put csv. example: here log file have :

*webauthredirect: mar 24 08:57:50.903: #emweb-6-parse_error: webauth_redirect.c:1034 parser exited. client mac= a0:88:b4:d3:55:8c bytes parsed = 0 , bytes read = 213 *webauthredirect: mar 24 08:57:50.903: #emweb-6-http_req_begin_err: http_parser.c:579 http request should begin character ***ewmwebwebauth1: mar 04 11:33:46.870: #pem-6-guestin: pem_api.c:7851 guest user logged in user account (mrathi_dev) mac address 00:1e:65:39:10:8e, ip address 192.168.133.146.** *ewmwebwebauth1: mar 04 11:33:46.870: #aaa-5-aaa_auth_network_user: aaa.c:2178 authentication succeeded network user 'mrathi_dev' *ewmwebwebauth1: mar 04 11:33:46.858: #apf-6-user_name_created: apf_ms.c:6532 username entry (mrathi_dev) length (10) created mobile 00:1e:65:39:10:8e  *mmlisten: mar 24 08:57:49.030: #apf-6-radius_override_disabled: apf_ms_radius_override.c:1085 radius overrides disabled, ignoring source 4  *webauthredirect: mar 24 08:57:47.008: #emweb-6-parse_error: webauth_redirect.c:1034 parser exited. client mac= 5c:a:5b:60:f1:a7 bytes parsed = 0 , bytes read = 440 *webauthredirect: mar 24 08:57:47.008: #emweb-6-http_req_begin_err: http_parser.c:579 http request should begin character *webauthredirect: mar 24 08:57:45.453: #emweb-6-parse_error: webauth_redirect.c:1034 parser exited. client mac= 5c:a:5b:60:f1:a7 bytes parsed = 0 , bytes read = 440 *webauthredirect: mar 24 08:57:45.453: #emweb-6-http_req_begin_err: http_parser.c:579 http request should begin character

all interested in #pem-6-guestin line. need take user id , mac , ip address line , put in csv. log lines status required.

this first time working shell scripts , appreciated.

i think easier using grep filter + sed groups using regex:

grep "#pem-6-guestin" log.txt | sed -r "s/.*user account \((.*)\).* mac address (.*), ip address (.*)\.\*\*.*/\1,\2,\3/"

and output in csv format:

mrathi_dev,00:1e:65:39:10:8e,192.168.133.146

Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more