cat out.tmp
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
30 81.5M 30 24.8M 0 0 2818k 0 0:00:29 0:00:09 0:00:20 4305k
All I ask is one thing:
1. Where can i dl unix and the driver for my modem?
right now i have win xp HP notebook, and bellsouth is my provider with a westell modem. (2 Replies)
I am trying to find any line with the 9th column's number greater than 200, but why the following awk command does not work?
awk '$9 > 200' /tmp/test
2007-09-05 10:13:05.714 640.847 any 1.2.3.4 719 2445 487260 32 6082 199
2007-09-05 10:13:02.686 641.827... (2 Replies)
hi guys,
i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB
MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
this the file raw format:
Number of... (6 Replies)
I have some data, each record (line) ends with a line feed (\n). Each field is pipe (|) delimited.
1|short desc|long text|2001-01-01 01:01
2|short desc| long
text |2002-02-02 02:02
3|short desc| long text | 2003-03-03 03:03
4|short desc
| long text | 2004-04-04 04:04
... (10 Replies)
Hi all
In my system we have implemented user lockout feature after 3 failure attempt if he tries to login directly or if he run the any command through sudo and enter wrong password thrice. Now I have requirement in which particular user account shouldn't be locked when he run the command... (1 Reply)
i suspect the issue is with the IFS part. I have a script that reads a file. the problem here is that, when i run the script, it outputs a bunch of numbers. i know what these numbers are, but i dont understand why they're being sent to the screen.
as you can see below, everything should be... (5 Replies)
Oracle Linux 6.5
oracle user's primary group is oinstall and its secondary group is dba,asmdba,asmoper.
For the below created directory, I want the users belonging to dba,asmdba,asmoper to be able create, read and execute files but not delete them. How can I achieve that.
If I use 775 as... (5 Replies)
Hi everyboy,
I am a little confused and can't understand why I get a positive match in the following case.
Shell Script section echo $SHELL
echo "Server type = ${SERV_TYPE}"
if ]]; then
echo "foor"
echo -e $(_date) "${cinfo}INFO: ${crst}Checking SAP memory on ${HOST}"This is the... (1 Reply)
Discussion started by: h1kelds
1 Replies
LEARN ABOUT DEBIAN
asql
ASQL(8) Perl Programmers Reference Guide ASQL(8)NAME
asql - Provide an SQL interface to Apache logfiles.
SYNOPSIS
asql [options]
General Options:
--help Show brief help intstructions.
--manual Show more complete help.
--version Show the version of the software.
Scripting Options:
--load Load the named file, or glob.
--execute Execute a single query then exit.
Options:
--file Rather than running as a shell read commands from a named file.
--quiet Don't show the banner at startup.
DESCRIPTION
asql provides a simple console interface to allow a user to
query the contents of an Apache logfile via an SQL interface.
The shell features include:
Persistent alias definitions.
Command line completion
Command history
Simple scriptability
INTRODUCTION
The asql shell will create a temporary SQLite database based upon
any number of Apache logfiles. This temporary database may then
be interactively queried using common SQL syntax.
To get started you should load your logfiles into the database:
load /var/log/apache2/acces*
(The tool will automatically decompress files which have been
compressed with gzip or bzip2.)
Once you've loaded at least one file you may run queries, for
example:
SELECT source,SUM(size) AS Number FROM logs GROUP BY source ORDER BY Number DESC, ip
This example shows all the clients connecting to your webserver
and the size of files/requests that they have downloaded in total.
As you can see we've selected two columns "source" and "SUM(size)".
To see which other columns are available you may execute the "show"
command.
Because parsing the Apache logfile(s) specified might be quite
slow there is the option of dumping the temporary SQLite database
to a known filename with the 'save' command. The analog to the
save command is the 'restore' command, which will read in an
existing SQLite database and allow future queries to be executed
against it.
FILES
When the shell starts up it will read and intepret the initialisation
file of ~/.asqlrc if it exists. Any commands present in that file
will be executed prior to the launch of the interactive session.
All aliases will be read and written to the file ~/.asql.aliases.
All interactive history will be written to the file ~/.asql.
AUTHOR
Steve
--
http://www.steve.org.uk/
LICENSE
Copyright (c) 2007,2008,2009,2010 by Steve Kemp. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the
full text of the license.
AUTHOR
Steve
--
http://www.steve.org.uk/
LICENSE
Copyright (c) 2007-2020 by Steve Kemp. All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the
full text of the license.
perl v5.10.1 2010-10-04 ASQL(8)