• Solaris Fair Share Scheduling and Projects

    Scheduling_solutions_small_355048

    Solaris FSS is a method of resource sharing and allocation based on the importance of a process. Specifically a SHARE is a portion of a CPUs resources. In the instance below I was asked to setup FSS and Projects so that two low priority test databases could run along side production databases without any risk of impact.

    First off its work nothing that FSS is not always installed by default, you need to ensure that you have the package, SUNWfss.

    pkginfo SUNWfss

    You are looking for the response below

    system      SUNWfss Fair Share Schedule system      SUNWfss Fair Share Schedule

     Ok, since I have several databases running on each box, I am going to make this easy on myself and create two NIS groups, one that the production database users will belong to and one that the non-production, or low priority databases will belong to. The two groups that I created are ora-high and ora-low. This should be self explanitory. Once created in NIS and given access to the box, the xext step is to add ourprojects.

    The two examples below define projects by groups.

    #projadd -c "Oracle high priority project" group.ora-high

    #projadd -c "Oracle low priority project" group.ora-low 

    Now view your new projects.

    #projects -l

     

    Use the command below to see what projects a user id is part of.

    #id -p <userid>

     Now that the projects are created, go ahead and change the system scheduling to use Solaris FSS. This change will require a reboot.

    (more…)

  • Troubleshooting NTP on Linux

    Daylight-savings-time Using NTP to set the time on a linux server is not hard, however it can have a trick or two up its sleeve. In this example I was troubleshooting NTP on a RedHat 8 server (yes I know its old).

    Before we get started, the basics on NTP can be found here. A primer on the ntp.conf file can be found here. For most people this is all you will need to get ntp up and running. I unfortunately was not one of those people.

    Below is the error messages that I was receiving when I attempted to start ntp via ‘service ntpd start’.

    ntpdate[4999]: no server suitable for synchronization found

    What is this??? Unfortunatley the server that am attempting to sync to is behind a firewall and is not pingable, so doing a simple ping test to verify that I can connect to the box is out of the question. So I ask a network guy to check the firewall and he tells me that he sees the request coming from the box in question, but its not going to the box that I specified in the ntp.conf. The answer can be found in the /etc/ntp/step-tickers file.

    The step-tickers file is meant to hold an initial hostname or IP address to sync with upon startup of ntp. In RedHat, at least, the server runs an ntpdate against it. The entry in my step-tickers was an external host that was no longer accessible so I removed it and added one of my ntp hosts.

    However the sync still failed. This time I take a close look at the current time on the client box, and sure enough the date way off. NTP will not sync if there is more than a 1000 second difference between the host and the server. So I fix this using the date command and try again.

    Again it fails..

    So I run the ntpdate -db command below to get some more info.  The transmit section shows that I am not getting a response, this is not news to me but its good to verify,

    ntpdate -bd <NTP_SERVER>
     ntpdate[5023]: ntpdate 4.2.0a@1.1199-r Thu May  4 11:01:34 EDT 2006 (1)
    Looking for host <NTP_SERVER> and service ntp
    host found :<NTP_SERVER>
    transmit<NTP_SERVER>
    transmit<NTP_SERVER>
    transmit<NTP_SERVER>
    transmit<NTP_SERVER>
    transmit<NTP_SERVER>
    <NTP_SERVER> Server dropped: no data
    server <NTP_SERVER> port 123
    stratum 0, precision 0, leap 00, trust 000
    refid [10.253.82.1], delay 0.00000, dispersion 64.00000
    transmitted 4, in filter 4
    reference time:    00000000.00000000  Thu, Feb  7 2036  1:28:16.000
    originate timestamp: 00000000.00000000  Thu, Feb  7 2036  1:28:16.000
    transmit timestamp:  ccf1430f.64e5a35d  Mon, Dec 15 2008 15:56:47.394
    filter delay:  0.00000  0.00000  0.00000  0.00000
             0.00000  0.00000  0.00000  0.00000
    filter offset: 0.000000 0.000000 0.000000 0.000000
             0.000000 0.000000 0.000000 0.000000
    delay 0.00000, dispersion 64.00000
    offset 0.000000

    Ok so onto the NTP host where I run the following command to sniff traffic on UDP port 123.

    tcpdump dst port 123

    There is can see the client communicating with the host

    5:52:49.831677 IP <HIDDEN IP> .ntp > <HIDDEN IP>: NTPv4, Client, length 48

    So another call goes out to the Admin of the ntp server and have him verify that ntp is setup properly and is running. The provided the information above to him. Turns out he had iptables running and was blocking NTP. The other Admin makes a change and I am off and running.

  • Linux + Cron + Pam Access

    RedhatSo I ran into the following issue when attempting to setup a user to have cron access on a RHEL 4 box.

    Oct  7 10:34:01 ‘hostname’ pam_access[20206]: access denied for user `user’ from `cron’
    Oct  7 10:34:01 ‘hostname’ crond[20206]: Permission denied

    First and foremost, you should know that any user that you want to be able to user cron should be added to /etc/cron.allow. Almost anyone who is familiar with Cron should already know this.

    Poking around a bit on google indicated that I needed to add the following to /etc/security/access.conf

    +ALL:cron crond

    Make sure that the line above comes before the line below.

    -:ALL:ALL

    Below is the /etc/pam.d/crond file that I used

    #
    # The PAM configuration file for the cron daemon
    #
    #
    auth       sufficient pam_rootok.so
    auth       required   pam_stack.so service=system-auth
    auth       required   pam_env.so
    account    sufficient /lib/security/$ISA/pam_localuser.so
    account    required   pam_stack.so service=system-auth
    account    required   pam_access.so
    session    required   pam_limits.so
    session    required   pam_loginuid.so

  • More Console Fun with the Lantronix 3200

    20230295-177x150-0-0_Lantronix+Secure+Console+Server+SCS3200
    Ah, the good old console server. Can't say that I get a lot of chances to work on one, and I will tell you that when I do get a chance I can never remember how to get them setup without referring to my notes.

    One of the things that I find most annoying is the command structure and how incredibly user-unfriendly the command line is.

    No matter how old and antiquated you consider the console server to be I am sure that you have at least one around somewhere, and I cannot say that they are the worst thing to have at your desk for quick console access to a Sun box.

    First thing that you need to know is the difference between the set and the define command.

    set    # Immediate but not permanent (effective only until reboot).
    define # Permanent but not immediate (effective only after reboot).

    Then you need to know save, show, and list

    save   # Transform a setting made with 'set' into a permanent setting.
    show   # Displays current settings, both temporary and permanent.
    list   # Displays settings scheduled to take effect after next reboot.

    You are also going to need to know how to delete settings.
    clear  # Deletes temporary settings immediately.
    purge  # Deletes permanent settings, effective upon next reboot.

    Basic Commands:


    This will clear the label on a port, this is useful when you are changing the device connected to a port.

    set service "service name" port <#> enable
    Replace the port number with the port that you are working on, remember to use set so that the change is immediate. Then save your changes to make them permanent with the command , save service all

    show port all/show port <port #>
    The first command will let you see all your ports, while the second command allows you to view the settings of just one port.

    set port <port #> access remote
    Use this when setting up a port for remote access. Common on your Sun servers

    set port <port #> flow none
    Use the command above to set flow control to off

    misc. commands
    --------------
    Local_33>> logout
    Local_33>> logout port 2
    Local_33>> finger # Good brief overview of all ports and status.
    Local_33>> show ports all status # Verbose finger.
    Local_33>> set port menu enable # Return to menu (from whence you came.)
    Local_33> broadcast scsman "test ms"
  • Linux Library Madness

    Been having a very hard time working with a DBA to install Oracle 10g on a RHEL 4 box. He was getting this message.

    #java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-09-23_10-47-22AM/jre/1.4.2/lib/i386/libawt.so: libXtst.so.6: wrong ELF class: ELFCLASS64

    First thing that I did was figure out what rpm provides this libXtss.so.6 file

    #rpm -qf /usr/lib64/libXtst.so.6

    this command responds with: libXtst-1.0.1-3.1

    Now from what I have read Oracle 10g does not like 64 bit libraries, so I needed to figure out what architecture that I have installed.

    # rpm -qa –qf="%{n}-%{v}-%{r}.%{arch}.rpm\n" "libXtst"
    libXtst-1.0.1-3.1.x86_64.rpm

    So know I know that I have the 64 bit version of the rpm installed. I need to install the 32 bit version.

    #libXtst.i386                             1.0.1-3.1              base
    Matched from:
    libXtst
    X.Org X11 libXtst runtime library
    X.Org X11 libXtst runtime library

    Ok, there is the package. So lets install it.
    yum install libXtst.i386

    Issue resolved.

    Additional One Liners:

    rpm -ivh packages(s).rpm
    install rpm file(s)

    rpm -Uvh packages(s).rpm  
    upgrade system with rpms

    rpm -e package
    remove package

    rpm -q package  
    show version of package installed

    rpm -q -i package  
    show all package metadata

    rpm -q -f /path/file  
    what package does file belong

    rpm -ql package
    lists files in a rpm package


  • I stole these sed one liners…..

    FILE SPACING:

    double space a file

     sed G

    double space a file which already has blank lines in it. Output file

    should contain no more than one blank line between lines of text.

    sed '/^$/d;G'

    triple space a file

    sed 'G;G'

    undo double-spacing (assumes even-numbered lines are always blank)

     sed 'n;d'

    insert a blank line above every line which matches “regex”

    sed '/regex/{x;p;x;}'

    insert a blank line below every line which matches “regex”

    sed '/regex/G'

    insert a blank line above and below every line which matches “regex”

    sed '/regex/{x;p;x;G;}'

    NUMBERING:

    number each line of a file (simple left alignment). Using a tab

    note on ‘\t’ at end of file) instead of space will preserve margins.

     sed = filename | sed 'N;s/\n/\t/'

    number each line of a file (number on left, right-aligned)

    sed = filename | sed 'N; s/^/ /; s/ *\(.\{6,\}\)\n/\1 /'

    number each line of file, but only print numbers if line is not blank

    sed '/./=' filename | sed '/./N; s/\n/ /'

    count lines (emulates “wc -l”)

    sed -n '$='

    Text Conversion and Subsitution:

    IN UNIX ENVIRONMENT: convert DOS newlines (CR/LF) to Unix format

     sed 's/.$//' # assumes that all lines end with CR/LF
     sed 's/^M$//' # in bash/tcsh, press Ctrl-V then Ctrl-M
     sed 's/\x0D$//' # gsed 3.02.80, but top script is easier

    IN UNIX ENVIRONMENT: convert Unix newlines (LF) to DOS format

     sed "s/$/`echo -e \\\r`/" # command line under ksh
     sed 's/$'"/`echo \\\r`/" # command line under bash
     sed "s/$/`echo \\\r`/" # command line under zsh
     sed 's/$/\r/' # gsed 3.02.80

    IN DOS ENVIRONMENT: convert Unix newlines (LF) to DOS format

    sed "s/$//" # method 1
     sed -n p # method 2

    IN DOS ENVIRONMENT: convert DOS newlines (CR/LF) to Unix format

    Can only be done with UnxUtils sed, version 4.0.7 or higher.

    Cannot be done with other DOS versions of sed. Use “tr” instead.

    sed "s/\r//" infile >outfile # UnxUtils sed v4.0.7 or higher
     tr -d \r <infile >outfile # GNU tr version 1.22 or higher

    delete leading whitespace (spaces, tabs) from front of each line

    aligns all text flush left

    sed 's/^[ \t]*//' # see note on '\t' at end of file

    delete trailing whitespace (spaces, tabs) from end of each line

    sed 's/[ \t]*$//' # see note on '\t' at end of file

    delete BOTH leading and trailing whitespace from each line

    sed 's/^[ \t]*//;s/[ \t]*$//'

    insert 5 blank spaces at beginning of each line (make page offset)

    sed 's/^/ /'

    align all text flush right on a 79-column width

    sed -e :a -e 's/^.\{1,78\}$/ &/;ta' # set at 78 plus 1 space

    center all text in the middle of 79-column width. In method 1,

    spaces at the beginning of the line are significant, and trailing

    spaces are appended at the end of the line. In method 2, spaces at

    the beginning of the line are discarded in centering the line, and

    no trailing spaces appear at the end of lines.

    sed -e :a -e 's/^.\{1,77\}$/ & /;ta' # method 1
     sed -e :a -e 's/^.\{1,77\}$/ &/;ta' -e 's/\( *\)\1/\1/' # method 2

    substitute (find and replace) “foo” with “bar” on each line

    sed 's/foo/bar/' # replaces only 1st instance in a line
     sed 's/foo/bar/4' # replaces only 4th instance in a line
     sed 's/foo/bar/g' # replaces ALL instances in a line
     sed 's/\(.*\)foo\(.*foo\)/\1bar\2/' # replace the next-to-last case
     sed 's/\(.*\)foo/\1bar/' # replace only the last case

    substitute “foo” with “bar” ONLY for lines which contain “baz”

    sed '/baz/s/foo/bar/g'

    substitute “foo” with “bar” EXCEPT for lines which contain “baz”

    sed '/baz/!s/foo/bar/g'

    change “scarlet” or “ruby” or “puce” to “red”

    sed 's/scarlet/red/g;s/ruby/red/g;s/puce/red/g' # most seds
    sed 's/scarlet\|ruby\|puce/red/g' # GNU sed only

    reverse order of lines (emulates “tac”)

    bug/feature in HHsed v1.5 causes blank lines to be deleted

    sed '1!G;h;$!d' # method 1
     sed -n '1!G;h;$p' # method 2

    reverse each character on the line (emulates “rev”)

    sed '/\n/!G;s/\(.\)\(.*\n\)/&\2\1/;//D;s/.//'

    join pairs of lines side-by-side (like “paste”)

    sed '$!N;s/\n/ /'

    if a line ends with a backslash, append the next line to it

    sed -e :a -e '/\\$/N; s/\\\n//; ta'

    if a line begins with an equal sign, append it to the previous line

    and replace the “=” with a single space

    sed -e :a -e '$!N;s/\n=/ /;ta' -e 'P;D'

    add commas to numeric strings, changing “1234567” to “1,234,567”

    gsed ':a;s/\B[0-9]\{3\}\>/,&/;ta' # GNU sed
     sed -e :a -e 's/\(.*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta' # other seds

    add commas to numbers with decimal points and minus signs (GNU sed)

    gsed ':a;s/\(^\|[^0-9.]\)\([0-9]\+\)\([0-9]\{3\}\)/\1\2,\3/g;ta'

    add a blank line every 5 lines (after lines 5, 10, 15, 20, etc.)

    gsed '0~5G' # GNU sed only
     sed 'n;n;n;n;G;' # other seds

    Selective Printing of Lines:

    print first 10 lines of file (emulates behavior of “head”)

     sed 10q

    print first line of file (emulates “head -1”)

    sed q

    print the last 10 lines of a file (emulates “tail”)

    sed -e :a -e '$q;N;11,$D;ba'

    print the last 2 lines of a file (emulates “tail -2”)

    sed '$!N;$!D'

    print the last line of a file (emulates “tail -1”)

    sed '$!d' # method 1
     sed -n '$p' # method 2

    print only lines which match regular expression (emulates “grep”)

    sed -n '/regexp/p' # method 1
     sed '/regexp/!d' # method 2

    print only lines which do NOT match regexp (emulates “grep -v”)

    sed -n '/regexp/!p' # method 1, corresponds to above
     sed '/regexp/d' # method 2, simpler syntax

    print the line immediately before a regexp, but not the line

    containing the regexp

    sed -n '/regexp/{g;1!p;};h'

    print the line immediately after a regexp, but not the line

    containing the regexp

    sed -n '/regexp/{n;p;}'

    print 1 line of context before and after regexp, with line number

    indicating where the regexp occurred (similar to “grep -A1 -B1”)

    sed -n -e '/regexp/{=;x;1!p;g;$!N;p;D;}' -e h

    grep for AAA and BBB and CCC (in any order)

    sed '/AAA/!d; /BBB/!d; /CCC/!d'

    grep for AAA and BBB and CCC (in that order)

    sed '/AAA.*BBB.*CCC/!d'

    grep for AAA or BBB or CCC (emulates “egrep”)

    sed -e '/AAA/b' -e '/BBB/b' -e '/CCC/b' -e d # most se ds
     gsed '/AAA\|BBB\|CCC/!d' # GNU sed only

    print paragraph if it contains AAA (blank lines separate paragraphs)

    HHsed v1.5 must insert a ‘G;’ after ‘x;’ in the next 3 scripts below

    sed -e '/./{H;$!d;}' -e 'x;/AAA/!d;'

    print paragraph if it contains AAA and BBB and CCC (in any order)

    sed -e '/./{H;$!d;}' -e 'x;/AAA/!d;/BBB/!d;/CCC/!d'

    print paragraph if it contains AAA or BBB or CCC

    sed -e '/./{H;$!d;}' -e 'x;/AAA/b' -e '/BBB/b' -e '/CCC/b' -e d
     gsed '/./{H;$!d;};x;/AAA\|BBB\|CCC/b;d' # GNU sed only

    print only lines of 65 characters or longer

    sed -n '/^.\{65\}/p'

    print only lines of less than 65 characters

    sed -n '/^.\{65\}/!p' # method 1, corresponds to above
     sed '/^.\{65\}/d' # method 2, simpler syntax

    print section of file from regular expression to end of file

    sed -n '/regexp/,$p'

    print section of file based on line numbers (lines 8-12, inclusive)

    sed -n '8,12p' # method 1
     sed '8,12!d' # method 2

    print line number 52

    sed -n '52p' # method 1
     sed '52!d' # method 2
     sed '52q;d' # method 3, efficient on large files

    beginning at line 3, print every 7th line

    gsed -n '3~7p' # GNU sed only
     sed -n '3,${p;n;n;n;n;n;n;}' # other seds

    print section of file between two regular expressions (inclusive)

    sed -n '/Iowa/,/Montana/p' # case sensitive

    Selective Deletion of Lines:

    print all of file EXCEPT section between 2 regular expressions

    sed '/Iowa/,/Montana/d'

    delete duplicate, consecutive lines from a file (emulates “uniq”).

    First line in a set of duplicate lines is kept, rest are deleted.

    sed '$!N; /^\(.*\)\n\1$/!P; D'

    delete duplicate, nonconsecutive lines from a file. Beware not to

    overflow the buffer size of the hold space, or else use GNU sed.

    sed -n 'G; s/\n/&&/; /^\([ -~]*\n\).*\n\1/d; s/\n//; h; P'

    delete all lines except duplicate lines (emulates “uniq -d”).

    sed '$!N; s/^\(.*\)\n\1$/\1/; t; D'

    delete the first 10 lines of a file

    sed '1,10d'

    delete the last line of a file

    sed '$d'

    delete the last 2 lines of a file

    sed 'N;$!P;$!D;$d'

    delete the last 10 lines of a file

    sed -e :a -e '$d;N;2,10ba' -e 'P;D' # method 1
     sed -n -e :a -e '1,10!{P;N;D;};N;ba' # method 2

    delete every 8th line

    gsed '0~8d' # GNU sed only
     sed 'n;n;n;n;n;n;n;d;' # other seds

    delete ALL blank lines from a file (same as “grep ‘.’ “)

    sed '/^$/d' # method 1
     sed '/./!d' # method 2

    delete all CONSECUTIVE blank lines from file except the first; also

    deletes all blank lines from top and end of file (emulates “cat -s”)

    sed '/./,/^$/!d' # method 1, allows 0 blanks at top, 1 at EOF
     sed '/^$/N;/\n$/D' # method 2, allows 1 blank at top, 0 at EOF

    delete all CONSECUTIVE blank lines from file except the first 2:

    sed '/^$/N;/\n$/N;//D'

    delete all leading blank lines at top of file

    sed '/./,$!d'

    delete all trailing blank lines at end of file

    sed -e :a -e '/^\n*$/{$d;N;ba' -e '}' # works on all seds
     sed -e :a -e '/^\n*$/N;/\n$/ba' # ditto, except for gsed 3.02*

    delete the last line of each paragraph

    sed -n '/^$/{p;h;};/./{x;/./p;}'
    
    

    Resources:

    http://www.catonmat.net/blog/wp-content/uploads/2008/09/sed1line.txt

  • Configure ALOM on the v210 from the OS

    I was recently tasked to re-ip a v210 that was using a terminal server for console connectivity.I was actually pleased to find out the the V210 has an SC.

    The scadm command is located here : /usr/platform/SUNW,Sun-Fire-V240/sbin

    This should not be a surprise for those who have used the command before. You can use the command to show the config for the SC.

    bash-2.03# ./scadm shownetwork
    IP Address: 0.0.0.0
    Gateway address: 0.0.0.0
    Netmask: 255.255.255.0
    Ethernet address: 00:03:ba:41:51:00

    Use the "scadm set" command to setup the ALOM, using the format below.
    
    #scadm set if_network true
    #scadm set netsc_tpelinktest true
    #scadm set netsc_dhcp false
    #scadm set netsc_ipaddr x.x.x.x
    #scadm set netsc_ipnetmask x.x.x.x
    #scadm set netsc_ipgateway x.x.x.x

    Note that you must reset the SC for the new settings to take affect.