Nov 23 04:09:51 mail.wesleyan.edu named[16108]: Lame server on 'mpwa.mtnpeoplesw
hs.com' (in 'MTNPEOPLESWHS.com'?): [206.170.175.2].53 'NS2.FOOTHILL.NET': learnt  
(A=192.5.5.241,NS=128.63.2.53)


#####################################
Cool commands
#####################################
fuser 
/usr/proc/bin/pfiles
vmstat
mpstat

for kernel crashes:
adb -k unix.# vmcore.#
$c 
$<stackregs
$<stacktrace
get these pieces of info:
/var/crash/<system_name>/unix.X     ( X = a number )
/var/crash/<system_name>/vmcore.X   ( X = a number )
/var/adm/messages
/etc/system
output from the showrev -p command
output from the prtconf -vp command 

sendmail flag o the day:

# maximum message size
#O MaxMessageSize=1000000

###############33
Majordomo
################
With moderated list
1.  Send mail to listname@wesleyan.edu
2.  It will bounce back (assuming you are owner)
3.  Forward this to list@wesleyan.edu with 1st line as:
Approved: password
4.  Pray

#######################################
Contact info
#######################################
	IBM:
Hardware:	1800IBMSERV  Acct number is 9616000
	info on adsm is at www/its/adsm/documentation.html
	to get into adsm go to nighthawk:1580 admin is user, passwd is root's
	10-17954 is the serial number.
	Type 7025-F50  <---------  NEEDED
	Number on ethernet: 9-D
	1800 IBM SERV
	AIX 4.2.0.0 -- oslevel
Software:	1800 CALL AIX	Software phone number = 18002375511
	port 1580 on nighthawk is web admin
	
	ITS, 265 Church Street
	Middletown Ct 06459




  Sun:
	1800USA4SUN 
	Hardware: SC31391
	Software: SC15506
	contractverification@sun.com
	sunsolve.sun.com username:abelew passwd:S1tiHsu


	Serial Numbers:
Registration:  912H3051

########################################
Hardware
########################################
  Parts of old mail server that Wes. is keeping:
	2 SCSI hard drives
	1 SCSI Cd-ROM
	8 64 Meg Sun DIMMS
	2 SCSI/100baseT cards  <--  1 is in beef.its
	1 Framebuffer card   <-- in beef.its
	1 Powersupply
	1 Fan
	1 SCSI 2 Assembly (from motherboard to Sun proprietary SCSI)
	1 Power cabling assembly

#####################################
Disks
#####################################
  	Mirrors and such:
	
device				mount		{
Inside the {} are the submirrors which comprise this device and their config.
Inside the [] are the total K followed by K used as of last I checked...
	Condor:
/dev/md/dsk/d5   		swap		{ 
  submirrors d1(c1 t10 d0 s1), d9(c1 t11 d0 s1)
}
/dev/md/dsk/d4  		/	 	{
	submirrors d0(c1 t10 d0 s0), d8(c1 t11 d0 s0)
					[384871  283991]}
/dev/md/dsk/d7  		/var		{
	submirrors d3(c1 t10 d0 s7), d12(c1 t11 d0 s7)
					[384871  171085]}
/dev/md/dsk/d6  		/opt		{
	submirrors d2(c1 t10 d0 s5) d11(c1 t11 d0 s5)
					[866534  770606]}
/dev/md/dsk/d30 		/home		{
	submirrors d20,d21
		d20(c0 t1 d0 s7)(c0 t2 d0 s7)
		d21(c2 t1 d0 s7)(c2 t2 d0 s7)
					[7872696 3899690]}   
/dev/dsk/c2t3d0s7 	/opt/src	[3936364 2183946]
/dev/dsk/c2t5d0s7 	/html 		[3936364 1992503]
/dev/dsk/c0t3d0s7 	/scratch	[2888885 1562982]
/dev/dsk/c1t2d0s6 	/SAS	       	[8316189  961776]
/dev/dsk/c0t4d0s7 	/helpdesk	[3939604   24867]
/dev/dsk/c1t1d0s6 	/media		[8316189  180860]
/dev/dsk/c0t5d0s7    	/usr/local	[3939604  844439] 


	Mail:
/dev/md/dsk/d5  	swap			{
	submirrors d1(c0 t0 s1)  d9(c0 t1 s1)
}
/dev/md/dsk/d4  	/			{
	submirrors d0(c0 t0 s0) d8(c0 t1 s0)
					[709495  220469]}       
/dev/md/dsk/d7  	/var			{
	submirrors d3(c0 t0 s7) d12(c0 t1 s7) 
					[1251078  404208]}
/dev/md/dsk/d6  	/opt			{
	submirrors d2(c0 t0 s5) d11(c0 t1 s5)
					[1251078  801580]}    
/dev/md/dsk/d18 /dev/md/rdsk/d18 /bigdisk	{
	submirrors d16,d10
		d16(c2 t3 s7)(c2 t4 d7)(c2 t2 s7)
		d10(c1 t0 s7)(c1 t1 s7)(c1 t2 s7)
					[11807948 6386624]}    
/dev/md/dsk/d14 /dev/md/rdsk/d14 /bigdisk2	{
	submirrors d13,d15 
		d13(c2 t0 s7)(c2 t1 s7)
		d15(c1 t3 s7)(c1 t4 s7)
					[7871616 3312262]}
/dev/dsk/c2t5d0s0 	/bcksys      	[1969278  553748]
/dev/dsk/c2t5d0s1 	/bcksys/home    [1969278  928065]
/dev/dsk/c1t5d0s7 	/bckusr/mail	[3938524 1632057] 

	WWW:
/dev/md/dsk/d0 		/ 			{
	submirrors d10, d20
		d10(c0 t0 s0) d20(c0 t1 s0)
					[384871  254645]}
/dev/md/dsk/d1		swap			{
	submirrors d11, d21
		d11(c0 t0 s1) d21(c0 t1 s1)
}
/dev/md/dsk/d3 		/var			{
	submirrors d7, d9
		d7(c0 t0 s7) d9(c0 t1 s7)
					[384111  236791]}
/dev/md/dsk/d2 		/opt		 	{
	submirrors d6, d8
		d6(c0 t0 s5) d8(c0 t1 s5)
					[866534  534411]}
/dev/md/dsk/d4 		/www			{
	submirrors d12, d24
		d12(c1 t0 s7) d24(c1 t1 s7)
					[3934204 3501879]}
/dev/md/dsk/d5		/administrative		 {
	submirrors d13, d26
		d13(c1 t4 s7) d26(c2 t0 s7)
					[3936364  176649]}
/dev/dsk/c1t2d0s7       /staging	[3936364 3446409]
/dev/dsk/c1t3d0s7       /development	[3935284 1903539]
				

	News:
/dev/dsk/c0t0d0s0	/		[384871  267119]
/dev/dsk/c0t0d0s7	/var		[478607  315521]
/dev/dsk/c0t0d0s5	/opt		[961822  441679]
/dev/md/dsk/d20		/var/spool/news 	{
	stripe: (c1 t2 s7) (c1 t3 s7)
		(c1 t4 s7) (c1 t5 s7)
					[15744280 9087746]}
/dev/dsk/c0t1d0s0	/opt/usr/local/news/hisdir
					[384871   67516]
/dev/md/dsk/d10		/opt/dns		{
	stripe: (c1 t0 s6) (c1 t1 s6)
					[961822  441679]} 
/dev/md/dsk/d5		swap			{
	mirror: d1(c0 t0 s5)
}
/dev/md/dsk/d6					{
	mirrors: d2, d11
		d2(c0 t0 s5) d11(c0 t1 s5)
}
/dev/md/dsk/d7
	mirrors: d3, d12
		d3(c0 t0 s7), d12(c0 t1 s7)
}
	Search:
/dev/dsk/c0t0d0s0 	/		[96019   14002]
/dev/dsk/c0t0d0s6 	/usr		[240302  100844]
/dev/dsk/c0t0d0s4 	/var		[192056    8917]
/dev/dsk/c0t0d0s7 	/export/home	[2392283  363634]
/dev/dsk/c0t0d0s5 	/opt		[288556   85318]
/dev/dsk/c0t0d0s3 	/usr/openwin	[240302  111713]

	www2:
/dev/dsk/c0t0d0s0 	/		[432839  278373]
/dev/dsk/c0t0d0s6 	/var		[865221    3331]
/dev/dsk/c0t0d0s7 	/export/home	[602669     481]
/dev/md/dsk/d0	  	/data			{
	mirrors: d1, d2
		d1(c1 t2 s7)(c2 t2 s7)
		d2(c1 t1 s7)(c2 t1 s7) 
					[8240997 3477315]}
/dev/dsk/c1t4d0s7 	/stuff 		[8705501  903569]
/dev/dsk/c0t0d0s5 	/opt  		[1784644 1055055]	



############################################
phone numbers
############################################
clemens 617-621-4223



##########################################
Network
##########################################
what can you do with ndd?
Below are parameters with ndd and their current status:(on www)
?                             (read only)
tcp_close_wait_interval       (read and write) 25000
tcp_conn_req_max_q            (read and write) 128
tcp_conn_req_max_q0           (read and write) 
tcp_conn_grace_period         (read and write)
tcp_cwnd_max                  (read and write)
tcp_debug                     (read and write)
tcp_smallest_nonpriv_port     (read and write)
tcp_ip_abort_cinterval        (read and write)
tcp_ip_abort_linterval        (read and write)
tcp_ip_abort_interval         (read and write)
tcp_ip_notify_cinterval       (read and write)
tcp_ip_notify_interval        (read and write)
tcp_ip_ttl                    (read and write)
tcp_keepalive_interval        (read and write)
tcp_maxpsz_multiplier         (read and write)
tcp_mss_def                   (read and write)
tcp_mss_max                   (read and write)
tcp_mss_min                   (read and write)
tcp_naglim_def                (read and write)
tcp_old_urp_interpretation    (read and write)
tcp_rexmit_interval_initial   (read and write)
tcp_rexmit_interval_max       (read and write)
tcp_rexmit_interval_min       (read and write)
tcp_wroff_xtra                (read and write)
tcp_deferred_ack_interval     (read and write)
tcp_snd_lowat_fraction        (read and write)
tcp_sth_rcv_hiwat             (read and write)
tcp_sth_rcv_lowat             (read and write)
tcp_dupack_fast_retransmit    (read and write)
tcp_ignore_path_mtu           (read and write)
tcp_rwin_credit_pct           (read and write)
tcp_rcv_push_wait             (read and write)
tcp_smallest_anon_port        (read and write)
tcp_largest_anon_port         (read and write)
tcp_xmit_hiwat                (read and write)
tcp_xmit_lowat                (read and write)
tcp_recv_hiwat                (read and write)
tcp_recv_hiwat_minmss         (read and write)
tcp_fin_wait_2_flush_interval (read and write)
tcp_co_min                    (read and write)
tcp_max_buf                   (read and write)
tcp_zero_win_probesize        (read and write)
tcp_strong_iss                (read and write)
tcp_rtt_updates               (read and write)
tcp_status                    (read only)
tcp_bind_hash                 (read only)
tcp_listen_hash               (read only)
tcp_conn_hash                 (read only)
tcp_queue_hash                (read only)

################################################
sql
################################################

mysqlshow
mysqlshow mysql
mysql -e "select host,db,user from db" mysql

mysql> insert into 
           host(host,db,Select_priv,Insert_priv,Update_priv,
           Delete_priv,Create_priv,Drop_priv)
           values('localhost','mydb','Y', 'Y', 'Y', 'Y', 'Y', 'Y'); 

mysql> insert into
           host(host,db,Select_priv,Insert_priv,Update_priv,
           Delete_priv,Create_priv,Drop_priv)
           values('myhostname','mydb','Y', 'Y', 'Y', 'Y', 'Y', 'Y');

mysql> insert into
           host(host,db,Select_priv,Insert_priv,Update_priv,
           Delete_priv,Create_priv,Drop_priv)
           values('localhost','%','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
           mysql> insert into
           host(host,db,Select_priv,Insert_priv,Update_priv,
           Delete_priv,Create_priv,Drop_priv)
           values('dv1','%','Y', 'Y', 'Y', 'Y', 'Y', 'Y');

mysql> insert into user (host,user,password)
           values('localhost','dario',password('mamamia')); 

mysql>insert into user (host,user,password)
           values('www.devshed.com','dario',password('mamamia')); 

mysql> insert into db
           (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
           Create_priv,Drop_priv)
           values ('localhost','pasta','dario','Y','Y','Y','Y','Y','Y');
          
 mysql> insert into db
           (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
           Create_priv,Drop_priv)
           values ('%','chicken','dario','Y','Y','Y','Y','Y','Y');

mysqladmin -u root -p create pasta

mysql> mysqladmin -u root -p reload;

mysql> CREATE TABLE test (
           > name VARCHAR (15),
           > email VARCHAR (25),
           > phone_number INT,
           > ID INT NOT NULL AUTO_INCREMENT,
           > PRIMARY KEY (ID));

mysql> show tables;
mysql> show columns from test; 

mysql> INSERT INTO test VALUES 
           mysql> ('Bugs Bunny', 'carrots@devshed.com',
           mysql> 5554321, NULL); 





To give rights to me, trey, do this.
mysql> INSERT INTO user VALUES ('localhost','trey','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

mysql> CREATE TABLE test(
    -> name VARCHAR (15),
    -> email VARCHAR(35),
    -> phone INT,
    -> PRIMARY KEY(name));
Query OK, 0 rows affected (0.02 sec)


mysql> show tables
    -> ;
1 rows in set (0.02 sec)

+--------------------+
| Tables in vacation |
+--------------------+
| test               |
+--------------------+

mysql> insert into test values('trey', 'abelew@wesleyan.edu', 3142);
Query OK, 1 rows affected (0.03 sec)


mysql> select * from test;
1 rows in set (0.00 sec)

+------+---------------------+-------+
| name | email               | phone |
+------+---------------------+-------+
| trey | abelew@wesleyan.edu |  3142 |
+------+---------------------+-------+

#######################################################
Os's 
#######################################################
AIX:
Dan LeGate (dlegate@rsa.csuhayward.edu) wrote:
: Is there a way to find out how much room is left on a hard drive?  I want 
: to expand a file system, but don't know what my limits are.  Is there a 
: way to find that out?

"lsvg" tells you which volume groups there are
"lspv" tells you what harddisks your have
"lspv -p hdisk0" will tell you if there are any unallocated PPs on hdisk0
"lslv", and various option combos of the other commands, will give you 
more info on each VG/LV/hdisk, such as if an LV can span more than one disk

: How can I list the contents of an 8mm tape?  I'm trying to find out if a 
: tape is blank or not - it's unlabeled, but might have some data on it.

"dd" (at least try to) the contents to an empty filesystem (not /tmp since
if there's 2GB of data on the tape, you'll fill up /tmp).  You may have to
try different block sizes (0,512,1024), if you get an error saying the tape
is unreadable.  I don't know if an empty/blank tape will give the same msg.

Ron,,,


#####################################################
###  Commands
###################################################
showrev -p


#########################################################
Acronyms
#########################################################
ROS : read only storage
EPROM : Erasable Programmable Read Only Memory



#######################################################
ADSM
#######################################################
Tests with assorted client parameters:
114.76Mb file
all options off:
1:37 min
net rate 11,979.41
aggregate rate 585.99
bytes trans 55.51

tcp large windows and no delay on. tcp buffer:56
tcp window 64
1:31 min
net rate 15,319.55
aggregate rate 619.71
bytes: 55.51


tcp large windows and no delay on. tcp buffer:256
tcp window 64
dog ass slow.


##########################################################
News
##########################################################
If the history file dies, do a makeactive followed by makehistory.

################################################
Random
################################################
  Random things:
	swmtool for installing software on solaris.


www.wesleyan.edu
	Driver for ethernet card:  will need patch 104212 v.13


####################################################
Driver installation
##################################################
1.  pkgrm SUNWhmd and SUNWhmdu
2.  pkgadd SUNWhmd and SUNWhmdu
3.  reboot -- -s
4.  rem_drv hme
5.  add_drv -i "SUNW,hme" hme
6.  ifconfig hme0 plumb
7.  reboot
8.  apply patch 104212-xx
9.   ------  To set hme0 to full duplex:
9a.  ndd -set /dev/hme instance 0
10.  ndd -set /dev/hme adv_100T4_cap 0
11.  ndd -set /dev/hme adv_100fdx_cap 1
12.  ndd -set /dev/hme adv_100hdx_cap 0
13.  ndd -set /dev/hme adv_10fdx_cap 0
14.  ndd -set /dev/hme adv_autoneg_cap 0


#######################################
other depts
####################################
chem:chili:lactam2




#####################################
C
####################################
Interger printf/sscanf conversion table:
%hd = (signed) short int  --  16 bits (15 and sign) -- -32768 to 32767
%d  = (signed) int
%ld = (signed) long int
%hu = unsigned short int  --  16 bits -- 0 to 65535
%u  = unsigned int
%lu = unsigned long int
%d  = signed char         --  2 bits -128 to 127
%d  = unsigned char       --  2 bits 0 to 255
%f  = float
%lf = double
%Lf = long double

leading a numeral with 0 means it is octal thus 0123 is 83 in decimal
leading with 0x makes hexadecimal so 0x15 is 21 in decimal