?

Log in

No account? Create an account
protei's notes

> recent entries
> calendar
> friends
> profile
> previous 20 entries

Wednesday, November 19th, 2014
11:01 pm - не, ну вот конкретно непоятно, когда этих пи... садить начнут?

(comment on this)

Tuesday, April 20th, 2010
4:27 pm - дааас...
tcp 0 0 :::80 :::* LISTEN 17062/sh

(1 comment | comment on this)

1:32 pm - убейте меня горячим пирожком!
whois 38.79.199.231
[Querying whois.arin.net]
[Redirected to rwhois.cogentco.com:4321]
[Querying rwhois.cogentco.com]
[rwhois.cogentco.com]
%rwhois V-1.5:0010b0:00 rwhois.cogentco.com
38.79.199.231

Warning: mssql_pconnect(): Unable to connect to server:  dca-05.ms.cogentco.com in /local/apache/www/data/starfish/func_db.php on line 219


Could not connect to MSSQL database !

No connection to MSSQL !

%ok

(comment on this)

Friday, April 16th, 2010
5:32 pm - proxytunnel
http://proxytunnel.sourceforge.net/usage.php

root@gump:~/.ssh>cat /root/.ssh/config
Host 10.50.150.20
        ProxyCommand /usr/local/bin/proxytunnel -p xx.xx.xx.xx:3128 --proxyauth testuser:testpassword -d 10.50.150.20:443
root@gump:~/.ssh>ssh root@10.50.150.20
Via xx.xx.xx.xx:3128 -> 10.50.150.20:443
root@10.50.150.20's password:
Last login: Fri Apr 16 06:28:20 2010 from 10.50.151.60
[root@reports ~]# netstat -lpnt|grep sshd
tcp        0      0 :::22                       :::*                        LISTEN      9575/sshd
tcp        0      0 :::443                      :::*                        LISTEN      9575/sshd
[root@reports ~]#

(comment on this)

Thursday, April 1st, 2010
6:50 pm - howto quickly check availability of something...
for n in 159 160 161 162 163 164 174 175; do \
snmpget -v 2c -c public 10.50.150.101 snL4RealServerCfgAdminStatus.10.50.150.$n.9400; done;
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.159.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.160.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.161.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.162.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.163.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.164.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.174.9400 = INTEGER: enabled(1)
FOUNDRY-SN-SW-L4-SWITCH-GROUP-MIB::snL4RealServerCfgAdminStatus.10.50.150.175.9400 = INTEGER: enabled(1)

(comment on this)

Friday, March 26th, 2010
4:02 pm - passive ftp to Amazon Clouds (proftpd)
PassivePorts 12000 12003 - открыть их в AWSConsole
MasqueradeAddress your.hostname

- иначе работает только активный ftp, и то только для хостов c маршрутизируемыми айпишниками

(comment on this)

Monday, March 22nd, 2010
4:08 pm - Oracle gluck
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as prod_etl_file

SQL> SELECT value FROM V$SYSSTAT WHERE name = 'user commits';

SELECT value FROM V$SYSSTAT WHERE name = 'user commits'

ORA-00942: table or view does not exist

SQL>


И как такое может быть? Хотя...

(comment on this)

Tuesday, February 9th, 2010
12:50 am - just a little fix
"Завял цветок, упал на поле лепесток,
Рассыпался на сотни каторжных мгновений,
Бежит толпа, да поломала ворота - 
И УДАЧНАЯ мечта - одно мученье"

Вот так - правильно.

(1 comment | comment on this)

Tuesday, January 26th, 2010
5:28 pm - ssh error
Just for memory: если по ssh -v видно такое:

debug1: Unspecified GSS failure.  Minor code may provide more information
Unknown code krb5 195

То это скорее всего просто /home у юзера world writable ;)

(comment on this)

Monday, January 25th, 2010
5:45 pm - keys for Amazon EC2
Есть private RSA ключ, и нужно получить public SSH-ключ для того, чтобы поместить его в authorized_keys
(обычно ssh-keygen делает сразу пару ключей, но амазоновцы дают только private, а public не дают). 
Памятка, как получить public из private в "SSH-формате":

ssh-keygen -f RedAril_US_East.pem -e > RedAril_US_East.pub
ssh-keygen -i -f RedAril_US_East.pub > RedAril_US_East.pub.ssh
cat  RedAril_US_East.pub.ssh
ssh-rsa AAAAB...................... - искомое

(comment on this)

Thursday, January 21st, 2010
5:21 pm - minicom + cisco
[root@ps3 ~]# cat /etc/minirc.dfl
# Machine-generated file - use "minicom -s" to change parameters.
pr port             /dev/ttyS0
pu baudrate         9600
pu minit
pu mreset
pu mdialpre
pu rtscts           No
[root@ps3 ~]# cat /etc/grub.conf |grep hda
#        kernel /boot/vmlinuz-2.6.27.7 ro root=/dev/hda1 console=ttyS0,19200 pnpacpi=off console=tty0 vga=791
        kernel /boot/vmlinuz-2.6.27.7 ro root=/dev/hda1 pnpacpi=off vga=791
[root@ps3 ~]# cat /etc/inittab|grep agetty
#s0:2345:respawn:/sbin/agetty -L ttyS0 19200 vt100
[root@ps3 ~]#


И пока про последнюю строчку в иниттабе не вспомнил, minicom выдавал на экран самые фантастические кракозябры. JFYM!

(comment on this)

Monday, December 28th, 2009
3:58 pm - iptables gluck
iptables -t nat -A PREROUTING -p tcp --dport 80 -m string --string 'partners/core' --algo kmp -j REDIRECT --to-ports 8888

iptables -t nat -A PREROUTING -p tcp --dport 80 -m string --string 'partners/core' --algo bm -j REDIRECT --to-ports 8888

iptables --version
iptables v1.4.1.1
uname -a
Linux domU-12-31-39-04-29-31 2.6.21.7-2.fc8xen #1 SMP Fri Feb 15 12:34:28 EST 2008 x86_64 x86_64 x86_64 GNU/Linux


- не работает, запросы на 8888 не попадают! чертовщина...

(1 comment | comment on this)

Thursday, November 26th, 2009
3:30 pm - hehe
root@gump:/>cowsay `cat /etc/slack* && uname -a`
 _______________________________________
/ Slackware 10.2.0 Linux gump 2.4.35 #1 \
| Sat Jul 11 08:09:00 MSK 1936 i686     |
\ unknown unknown GNU/Linux             /
 ---------------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

(comment on this)

Monday, November 16th, 2009
8:59 pm - bugzilla backup
[root@elm ~]# mysqldump -u bugs -p --compress --add-drop-table --databases bugs |bzip2 -c >`date +%Y-%m-%d-bugs.sql.bz2`
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `attach_data` at row: 771
[root@elm ~]# mysqldump -u bugs -p --max_allowed_packet=1G --net_buffer_length=1G --compress --add-drop-table --databases bugs |bzip2 -c >`date +%Y-%m-%d-bugs.sql.bz2`
Enter password:


YESS!

(comment on this)

Friday, October 30th, 2009
4:18 pm - just for memory
SQL> grant manage scheduler to prod_meta with admin option;

Grant succeeded.

SQL> grant create job to prod_meta;

Grant succeeded.

SQL>

grant dba для создания джобов недостаточно! ;)

(2 comments | comment on this)

Wednesday, October 14th, 2009
5:12 pm - fuuuuuuck!
dhcdrop -i eth0 -y -l 00:1B:C0:C0:05:4B
Using interface: 'eth0'
Got response from server 192.168.0.73 (IP-header 192.168.0.73), server ethernet address: 00:16:E6:5B:B7:98, lease time: 1.7e+02h (604800s)
Got BOOTREPLY (DHCPOFFER) for client ether: 00:F2:FB:9A:1D:E0 You IP: 192.168.0.77/24
1. Got BOOTREPLY (DHCPACK) for client ether: 00:F2:FB:9A:1D:E0 You IP: 192.168.0.143/24
2. Got BOOTREPLY (DHCPACK) for client ether: 00:C3:C0:68:29:4C You IP: 192.168.0.113/24
3. Got BOOTREPLY (DHCPACK) for client ether: 00:2B:3A:D9:AC:66 You IP: 192.168.0.39/24
4. Got BOOTREPLY (DHCPACK) for client ether: 00:76:C0:72:D8:83 You IP: 192.168.0.8/24
5. Got BOOTREPLY (DHCPACK) for client ether: 00:82:B4:CD:11:5B You IP: 192.168.0.143/24
6. Got BOOTREPLY (DHCPACK) for client ether: 00:E7:DA:48:33:37 You IP: 192.168.0.102/24
7. Got BOOTREPLY (DHCPACK) for client ether: 00:2C:EC:0E:92:AD You IP: 192.168.0.61/24
8. Got BOOTREPLY (DHCPACK) for client ether: 00:7A:90:FC:FD:F5 You IP: 192.168.0.69/24
9. Got BOOTREPLY (DHCPACK) for client ether: 00:84:E7:88:E0:0E You IP: 192.168.0.218/24
10. Got BOOTREPLY (DHCPACK) for client ether: 00:D4:47:28:0B:38 You IP: 192.168.0.82/24
11. Got BOOTREPLY (DHCPACK) for client ether: 00:27:7C:F7:D5:36 You IP: 192.168.0.62/24
...

Оно не заканчивается! :(

(comment on this)

Saturday, October 10th, 2009
12:48 pm - FC8: /usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found
./log_replay
./log_replay: /usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by ./log_replay)

[root@domU-12-31-39-00-E9-E2 ~]#  rpm -q --provides libstdc++
Read more...Collapse )

(comment on this)

Friday, October 2nd, 2009
1:47 pm - фигасе!
[root@qanciler scripts]# mount
/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
/dev/sda1 on /boot type ext3 (rw)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
[root@qanciler scripts]# mount -o rw,remount /
mount: block device /dev/VolGroup00/LogVol00 is write-protected, mounting read-only
[root@qanciler scripts]# pwd
/root/scripts
[root@qanciler scripts]# touch test
touch: cannot touch `test': Read-only file system
[root@qanciler scripts]#

(2 comments | comment on this)

Thursday, October 1st, 2009
7:22 pm - Apache HTTPS to Tomcat HTTPS - HOW?!
openssl genrsa -des3 -out p.ctasnet.com.key 1024
openssl req -new -key  p.ctasnet.com.key -out  p.ctasnet.com.csr

- somebody before me ;)Read more...Collapse )

(comment on this)

Wednesday, September 30th, 2009
1:28 pm - howto insert Russian characters into varchar2?
SQL> shutdown immediate;

---- nothing, wait
in another session:
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Read more...Collapse )

(comment on this)

> previous 20 entries
> top of page
LiveJournal.com