General :: Parsing A File Into Database?
Jul 14, 2010parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle database.
View 3 Replies
ADVERTISEMENT
General :: Parsing File Dates - Get The Date Of The Last Time A File Was Modified ?
Jan 11, 2010I need to get the modified date on a file in linux to use in a script.I tried using 'ls -l' on the file, but this caused problems when the date turned from a single digit into a double. The reason for the problem was because I was parsing the result string on spaces.How can I get the date of the last time a file was modified so I can use it in a script? For example, if a file was modified on 1/11/2010, I need the 11.
View 2 Replies View RelatedGeneral :: Parsing A Binary File?
Mar 17, 2011Is it possible to parse through a binary file using a script using either Korn shell or Bash
View 3 Replies View RelatedGeneral :: Parsing File With Multiple Delimiters?
Jun 21, 2011I am using nessus to scan systems, and it generates the report file without any specific delimiter. Shown below is how a typical line in the file reads (It might show up as a very long line.
Code:
xx.xx.xx.xx|cpq-wbem (2301/tcp)|49272|REPORT|Synopsis :;;The remote web server is affected by multiple vulnerabilities.;;Description :;;According to its self-reported version number, the HP System;Management Homepage install on the remote host is earlier than 6.2. ;Such versions are reportedly affected by the following ;vulnerabilities :;; - Session renegotiations are not handled properly, which; could be exploited to insert
[code]....
The field of interest (for me) are IP ADDRESS, Synopsys, Description, Solution and Risk Factor. I tried the following command to parse this:
Code:
sed s/:;;/|/g report.nsr | grep Risk Factor |High | awk 'BEGIN {FS = "[:][;][;]"} {printf("%s|%s|%s|%s",$1, $6, $7, $10)}'
But this would not give desired results as ':;;' is not a standard delimiter and hence gives incorrect results. how to grab everything that occurs between the strings 'Synopsys', 'Description', 'Solution' & 'Risk factor' in the above example? In other words i may be asking to use multiple delimiters.. in the order of occurance.. is there a tool that supports multiple delimiters?
General :: Parsing Output - End Of File Option ?
Feb 23, 2011I'm working on a alias/script that will make it easier to look at my environment via the set command.
On my ubunto when running set it also displays some 10 pages of code pertaining to something called "imagemagik". at the end of the output. This code begins with the { character.
This is annoying if I want to look at my environment when working on scripts. How could I use something like grep, awk, sed, or whatever to ignore everything after the "{" character.
That seems to be the simplest way as long as there are no leading brackets in my environment. (And if you're thinking I should just remove {imagemagik}, I might just do that. But I still would like to know how to do this).
General :: Parsing Delimited File And Variable Scripting?
Sep 23, 2010I did some searches and after a few hours was able to get what I needed. What I didn't find was a fully encompased means of what I'm used to in the windows world in working with delimted files. Hopefully this is helpful to others and if there is something better or leaner way, even better.We have an issue where managing printers, just viewing on RHEL w/ sys-conf-prtr we lose any number of, up to ~30 printers from lpadmin. Rather than stare and compare to find the missing ones, I wanted to make an intuitive script. This is what I came up with.
Code:
#!/bin/sh
while IFS="," read Prntr IP; do
[code]...
General :: Parsing Through A Nagios Config File To Extract Info W/ Sed - Awk - Vi
Oct 13, 2010I have a config file called hosts.cfg.
It contains entries like this:
Quote:
There are many more of these entries in the file, over 500, all in this same format: each host has a "define host" followed by 18 directives contained in squiggly brackets.
If I want to know all the hosts that are in the hostgroup called SERVER_GRP, I suppose I would need to read every hostgroups line (8th directive in squiggly brackets) that contains SERVER_GRP and output the corresponding host_name line (1st directive in squiggly brackets) from that entry.
Programming :: Parsing Xml File Using Shell Script And Generate Report In A PDF File?
Jul 9, 2009parsing xml file using shell script and generate report in a PDF file
Xml file input:
<report>
<student name="x" father name="x1" class="first" Address="xyz">
<property name="sports" value="yes"/>
<property name="drawing" value="no"/>
[code]....
General :: Where To Find Network Database File
Jun 26, 2011i want to write a program that need to know how much data has transmitted in network usage _how much send and how much received_which file , record or structure in which library i have to follow ?
View 2 Replies View RelatedProgramming :: Parsing Log File With Awk?
Aug 31, 2009I have logs files from freeradius that have looks as follows:
$ grep "Login incorrect (rlm_ldap: User not found" /var/log/radius/radiusd-inner-tunnel-20090831.log
Mon Aug 31 09:25:27 2009 : Auth: Login incorrect (rlm_ldap: User not found): [John Doe] (from client oficina port 0 via TLS tunnel)
[code]....
I use the following line to get the amount of users that don't exist on ldap:
Code:
grep "Login incorrect (rlm_ldap: User not found" /var/log/radius/radiusd-inner-tunnel-20090831.log | awk '{print $14}' | sort -fu | wc -l
Now, awk on line one for example parses [John Doe] and [Joon Williams] as "[John" and that it's not what I'd want. I mean how could I do for awk looks username field as closed between squared brackets?
General :: Safest Place To Put Database Connection File?
Dec 8, 2010When connecting to a database in a php script, where would be the safest place to store the connect.php file. I am thinking it should not be in public_html, but is it safe in sub folders or is there a method people generally use to keep such files secure and inaccessible.
The file I mean is one including the database name, user and password etc.
Programming :: Parsing Xml File From A C Program?
Mar 14, 2009i wanted to know how can I pars a xml file (read data from xml file) and from C program.is there any function to do this for me in C.
View 1 Replies View RelatedProgramming :: Perl: Parsing A Log File?
Nov 9, 2010I have a log file (test.log) starting & ending within dash (--) as below. I am looking to write a parser for test.log. This test.log file currently has single value for one Job ID but I wish to parse for repeated N values of different Job ID - Job, User, Queue, Dispatched Date, Dispatched Time, Completed Date, Completed Time, Hosts/Processor, CPU_T and TURNAROUND. I can either output this 10 values in another .log file or dump into cgi.
The selected parameters from test.log for parsing with above 10 attributes are -
--
Job <345010>
User <xyz>
Queue <gaussian>
[code]....
CentOS 5 Server :: VPS Is Not Parsing/loading PHP File?
Jun 9, 2011I managed to successfully install LAMP on my VPS and proceeded to install Wordpress only to run into an odd error.When I click on index.php, it starts to load but nothing happens.
The details:
LAMP = CentOS5.5, Apache 2.2.18(compiled from source), MySQL 5.1.57(compiled from source), PHP 5.3.6(from source too) My site: ottomatic.org as you can see in the index of files index.php is what I'm trying to load and if you check phpinfo.php you can see that PHP was installed correctly too. I added an .htaccess file with 644 permissions to my web root directory and that only seemed to produce an error, this is what I put in the .htaccess:
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
[Code]...
General :: Monitor Database IO And Available Database Threads?
Mar 7, 2011am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedFedora Security :: Error Parsing Semanage Configuration File?
Aug 5, 2011I need to autorise sendmail to send mail, but SeLinux blocks this action. But when I use this command:
Code:
setsebool -P httpd_can_sendmail=1
I receive an error
[code]...
Ubuntu :: Error: Parsing File '/var/lib/dpkg/available' Near Line 7175
Jul 21, 2011I tried to upgrade ubuntu , downloaded everything that was needed but I am not able to install anything.
It gives an error
Code:
Do you want to continue [Y/n]? y
Extracting templates from packages: 100%
Preconfiguring packages ...
dpkg: warning: parsing file '/var/lib/dpkg/available' near line 7174 package 'python-egenix-mxdatetime':
missing description
dpkg: error: parsing file '/var/lib/dpkg/available' near line 7175:
field name `Package(' must be followed by colon
E: Sub-process /usr/bin/dpkg returned an error code (2) since then I am not able to install anything on my aptdaemon fails for anything that I try to install How to deal with it
Software :: Parsing A Text File To Display Certain Data On Website In Php?
Dec 26, 2009Im trying to figure out how to display parts of a .db file created by the scorch2000 server to display a player name, games played, score and maybe more...
here is the text file format example:
playername1 password email #ofgames score setting1 setting2 setting3
playername2 password email #ofgames score setting1 setting2 setting3
playername3 password email #ofgames score setting1 setting2 setting3
playername4 password email #ofgames score setting1 setting2 setting3
playername5 password email #ofgames score setting1 setting2 setting3
I dont want to display everything, of course ^^, but how do i get the player name, the number of games he played and his score to display it in a webpage in this fasion:
Name Games Played Score
joe blow1 25 9876890
joe blow2 31 8989767
joe blow2 26 7989767
joe blow2 17 5989767
joe blow2 13 4989767
and by highest score because the log doesin't put them in in score order....
please help, i asked the maker because he has one runing already but no answer back, well the game is pretty old so i didn't really expect an answer anyways and tryed to figure it out but i dont know functions in php, this is to include in a php-nuke block (this i know how to do
here is an example of a working page at the developper website:url
Programming :: Bash Scripting - Parsing Text File By Character
Aug 11, 2009Is there a way to process individual characters one-by-one from a text file in Bash, or is that hoping for a little too much from this lovable old clunker?
View 13 Replies View RelatedGeneral :: Application Running As User Foo Log Onto Database As (database) User Foobar?
Jan 5, 2011I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedGeneral :: The Script To Parsing The Log Message?
Apr 6, 2010I am working on the script to parsing the log message . the followings are my task:1. Read the multiple log files, such as N1-2009-10-01, N2-2009-10-2, N3-2010-01-02....2. Parse the specific message, such as "aaaa"3. If found the "aaaa" message in the log file and export to excel file PS. i use zgrep:zgrep -a --text "aaaa" * > /home/TTS/myfileand inside file looks like:
N3.2009-11-26-03-05-02.console.log.tar.gz:2009-11-25 20:12:57,429 - aaaa
N4.2009-11-29-00-25-03.console.log.tar.gz:2009-11-28 10:42:18,209 - aaaa
N6.2009-12-01-10-05-02.console.log.tar.gz:2009-12-01 10:00:24,902 - aaaa
[code]....
General :: Firefox XMl Parsing Errors
Jun 30, 2011I keep getting Firefox XMl Parsing Errors(64 bit firefox). It's driving me crazy. Even in safe mode this happens.
View 1 Replies View RelatedGeneral :: Parsing Strings Containing Bash Scripts?
Jan 15, 2010fakeFile's contents :
Code:
blah $(date +%F) blah
fakeScript's contents :
Code:
while read line; do
echo $line
done < "fakeFile"
so here's the problem : is there any way to evaluate the fakeFile's contents (in the fakeScript), so that the term "$(date +%F)" (or any other bash script) in a string , translates to it's corresponding value ? (in this example , we want to have "blah current date" instead of " blah $(bash script) blah " )
General :: Capturing And Parsing Xterm Cut Buffer In EMacs
Jan 17, 2010I'd like to make an indirect control for Emacs (in Ubuntu Linux) so that I can swipe some text in an xterm with the cursor, cutting it into the X cut buffer, then run a macro in Emacs to parse the cut buffer text to look for text saying "line XXXX" where X is all digits, then go to that line in the current Emacs buffer. I think this is possible by using emacsclient to get emacs to run a macro, then the macro parsing the cut buffer, then issuing a goto-line command to the number that's been parsed. My problem is I don't know how to write the emacs script to read the X cut buffer and parse it.. I've been going through cookbook examples but none seem to fit.
My goal is to ease development. When I have an error/information/status message printed in an xterm, I want to swipe the error message which says something like "syntax error on line 2776" then press a keyboard shortcut which Ubuntu will interpret to launch emacsclient, which causes my already-open Emacs to grab that text, parse it, and go to the line number I just swiped. Only this last step of parsing is the hard part. (Yes, I know you can run a shell INSIDE of emacs, but this is doesn't fit my workflow). How would I make emacs look at that X cut buffer and parse out the line number and issue the "goto-line" command to the current buffer?
General :: Parsing Columns In Bash / Extract The First Set Of Numbers And Get Them To Appear Only Once?
Sep 28, 2009as a result of a find command, i have
852065 72: /bin/gunzip
852065 72: /bin/gzip
852065 72: /bin/zcat
(the first column is inode number and the second is size if you're curious)
I want to be able to format it in a way such that:
852065 72:
/bin/gunzip
/bin/gzip
/bin/zcat
I know I can get the bottom half using awk- but I can't figure out how to extract the first set of numbers and get them to appear only once
General :: Bash And Php Parsing / Not Getting The Data To Output Correctly Into The Rows?
Oct 26, 2010i am trying to get a script that i'm calling to have information from a sql populate into rows... but i'm not getting the data to output correctly into the rows. can someone please help?
<table>
<thead>
<tr>
<th>Name</th>
<th>Help</th>
<th>Folder</th>
code....
Programming :: Unload File From A Database?
Jan 5, 2009I am trying to unload file from a database. Which contains few lines with the character below. Rest of the data was unloaded appropriately.
Code:
a) What does this below character means?
b) How can i remove it,
I already have
Code:
sed '/^$/d'
c) Will this effect the file by any means (If I am guessing properly, this is the eof notation)
Ubuntu :: Kubuntu 10.04 LTS - To Open Wdb Or Mdb - Database File
Oct 20, 2010I'm using kubuntu 10.04 LTS and i need to open a wdb or a mdb (database file) and then save in one of those formats for a computing course I'm doing.
View 2 Replies View RelatedServer :: Accessing Database In FBD Data File
Feb 19, 2011We purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base. The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.
Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd. I can get into this database with MySQL. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.) Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started.
Server :: Import A Database File In Mysql?
Nov 1, 2010i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies View Related
