Tag Archives: sysadmin

LINKSYS WPS54GU2 wi-fi print server – the secret manual

To reset the CISCO LINKSYS WPS54GU2 wi-fi print server to factory default settings:

  1. Unplug the PrintServer.
  2. Connect to LAN using LAN cable
  3. Press and hold the Reset button.
  4. While pressing the Reset button, plug in the PrintServer.
  5. Continue pressing the button for 10 seconds and the PrintServer will be reset to factory defaults.
  6. Finally a DHCP request will be made

You can then login to the admin screen using the factory default login details:

  • User : admin
  • Password : admin

Read and post comments | Send to a friend

GNU/Linux global system cron jobs

As well as cron jobs for each user there may also be global "system" cron jobs that run hourly, daily, weekly or monthly on your GNU/Linux system

# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/
# run-parts
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

So to get a complete list of scheduled tasks (including prelink and makewhatis) try

# ls -lR /etc/cron*
-rw-r--r--  1 root root    0 Oct 27 19:08 /etc/cron.deny
-rw-r--r--  1 root root  255 Feb 21  2005 /etc/crontab
/etc/cron.d:
total 4
-rw-------  1 root root 366 Jun 14 21:19 sa-update
/etc/cron.daily:
total 84
lrwxrwxrwx  1 root root   28 Oct 27 19:07 00-logwatch -> ../log.d/scripts/logwatch.pl
-rwxr-xr-x  1 root root  418 Sep 14  2006 00-makewhatis.cron
-rwxr-xr-x  1 root root  135 Feb 21  2005 00webalizer
-rwxr-xr-x  1 root root  276 Feb 21  2005 0anacron
-rw-r--r--  1 root root  797 Feb 21  2005 certwatch
-rwxr-xr-x  1 root root  180 Oct 20  2006 logrotate
-rwxr-xr-x  1 root root 2133 Dec  1  2004 prelink
-rwxr-xr-x  1 root root  104 May  4 12:55 rpm
-rwxr-xr-x  1 root root  121 Aug 22  2005 slocate.cron
-rwxr-xr-x  1 root root  286 Feb 21  2005 tmpwatch
-rwxr-xr-x  1 root root  158 May  5 14:08 yum.cron
/etc/cron.hourly:
total 0
/etc/cron.monthly:
total 8
-rwxr-xr-x  1 root root 278 Feb 21  2005 0anacron
/etc/cron.weekly:
total 24
-rwxr-xr-x  1 root root 414 Sep 14  2006 00-makewhatis.cron
-rwxr-xr-x  1 root root 277 Feb 21  2005 0anacron
-rwxr-xr-x  1 root root  90 May  5 14:08 yum.cron

Read and post comments | Send to a friend

Oracle and Open Source

IBM Information Management & other webcasts

http://www-306.ibm.com/software/info/mgmt/webcasts/index.jsp

These webcasts cover a wide range of information services such as Content Management and Discovery, Database Servers and Tools, Data Warehousing and Analytics, Information Integration and Master Data Management.

http://www-306.ibm.com/software/info/mgmt/webcasts/index.jsp

Read and post comments | Send to a friend

Apache HTTP logrotate – rotatelogs

There is a special logrotate program for Apache HTTP logrotate – rotatelogs

This allows you to rotate Apache HTTP logfiles without having to restart Apache !

Read and post comments | Send to a friend

ApacheBench HTTP server benchmarking tool & other Apache tools

Did you know that if you are running Apache you already have a HTTP benchmarking tool called ApacheBench aka ab !

Theres a list of all the tools you get with Apache @ http://httpd.apache.org/docs/2.2/programs/ including logresolve which is a post-processing program to resolve IP-addresses in Apache's access logfiles !

Finally there a great list of Open Source performance testing tools @ http://www.opensourcetesting.org/performance.php

Read and post comments | Send to a friend

MySQL slow query log and mysqldumpslow

First enable slow query logging, then generate a slow query and finally look at the slow query log !

Enable
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

Generate

select sleep(2)

then run mysqldumpslow

$ mysqldumpslow --help
Usage: mysqldumpslow [ OPTS... ] [ LOGS... ]

Parse and summarize the MySQL slow query log. Options are

  --verbose    verbose
  --debug      debug
  --help       write this text to standard output

  -v           verbose
  -d           debug
  -s ORDER     what to sort by (t, at, l, al, r, ar etc), 'at' is default
  -r           reverse the sort order (largest last instead of first)
  -t NUM       just show the top n queries
  -a           don't abstract all numbers to N and strings to 'S'
  -n NUM       abstract numbers with at least n digits within names
  -g PATTERN   grep: only consider stmts that include this string
  -h HOSTNAME  hostname of db server for *-slow.log filename (can be wildcard),
               default is '*', i.e. match all
  -i NAME      name of server instance (if using mysql.server startup script)
  -l           don't subtract lock time from total time

mysqldumpslow output

# Time: 070906 12:47:20
# User@Host: root[root] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
select sleep(3);

Read and post comments | Send to a friend

StopBadware.org

StopBadware.org is a "Neighborhood Watch" campaign aimed at fighting badware. We will seek to provide reliable, objective information about downloadable applications in order to help consumers to make better choices about what they download on to their computers. We aim to become a central clearinghouse for research on badware and the bad actors who spread it, and to become a focal point for developing collaborative, community-minded approaches to stopping badware.

Harvard Law School's Berkman Center for Internet & Society and Oxford University's Oxford Internet Institute are leading this initiative with the support of several prominent tech companies, including Google, Lenovo, and Sun Microsystems. Consumer Reports WebWatch is serving as an unpaid special advisor.

Read and post comments | Send to a friend

apache htaccess file for wordpress

apache htaccess file for wordpress from

http://perishablepress.com/press/2006/06/14/the-htaccess-rules-for-all-wordpress-permalinks/

wordpress in same dir

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

wordpress in sub dir

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /foo/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /foo/index.php [L]
</IfModule>
# END WordPress

Read and post comments | Send to a friend

MEMSET virtual web hosting

I'm now trying MEMSET virtual web hosting and its looking very good so far.

WHM/CPANEL has changed (improved) a lot since I last used it two years ago (when I defected to Plesk).

Not only does the MEMSET reseller package give you ssh root access to your VM you also get ability to update Fantastico yourself and update key system packages such as wget !

If fact the very first thing you have do using WHM (and by ssh as root) is update wget

# rpm -qa wget ;
# wget ftp://fr2.rpmfind.net/linux/fedora/core/5/i386/os/Fedora/RPMS/wget-1.10.2-3.2.1.i386.rpm ;
# rpm -e wget ;
# rpm -ivh --force wget-1.10.2-3.2.1.i386.rpm ;
# rpm -qa wget ;

https://netenberg.com/forum/index.php?topic=5430.0

and then update Fantastico !

Not for VM webhost beginners then but power equals complexity !

Read and post comments | Send to a friend