grzech.webio.pl


.. kolejny blog w sieci (głównie na własne potrzeby)


  1. Mikrotik - przekierowanie

    ip fi nat add chain=dstnat protocol=tcp dst-port=PORTZEW action=dst-nat to-addresses=IPWEW to-ports=PORTWEW comment=KOMENTARZ

  2. Generowanie T-SQL do odbudowy katalogów FullText

    declare @db_name sysname; declare db cursor for select sd.name as db_name from sys.dm_fts_active_catalogs fts inner join sys.databases sd on fts.database_id = sd.database_id ORDER BY sd.name open db fetch next from db into @db_name while @@fetch_status = 0 begin declare @fts_name sysname; declare fts cursor for select fts.name as fts_name from sys.dm_fts_active_catalogs fts inner join sys.databases sd on fts.database_id = sd.database_id WHERE sd.name = @db_name open fts fetch next from fts into @fts_name while @@fetch_status = 0 begin print 'USE ' + QUOTENAME(@db_name) + '; ALTER FULLTEXT CATALOG...

  3. Problem z uzupełnianiem katalogów Full Text

    Błąd w logach: Error '0x80040e97' occurred during full-text index population for table or indexed Rozwiązanie: Exec sp_fulltext_service 'ft_timeout', 1200000 Źródło: http://support.microsoft.com/kb/2270849

  4. vCenter Appliance - akceptacja EULA z linii poleceń

    To deal with it I found a way to accept EULA directly from the appliances shell console: Login to the vCenter server appliance shell console (default credentials: root/vmware ) Navigate to the /etc/vmware-vpx folder: cd /etc/vmware-vpx Create empty file eula.accepted with: vi eula.accepted and save it: :wq You can now start vCenter Service from the console with: service vmware-vpxd start service vmware-vpxd status Źródło: http://grzegorzosinski.blogspot.com/2012/07/accept-vmware-vcenter-server-appliance.html...

  5. Zmiana klucza produktu w Windowsie

    slmgr.vbs -ipk <type your product key here> Źródło: http://social.microsoft.com/Forums/zh/genuinewindows7/thread/ce677eb0-7d97-46d6-81df-a05dca1c2b85

  6. Problem z bazą danych (embedded) vCenter Appliance

    Uruchomić z poziomu SSH: su -l db2inst1 db2 get db cfg for vCDB | grep log db2 UPDATE DB CFG FOR VCDB USING logprimary 128 logsecond 16 logfilsiz 8192 Źródło: http://www.virtualserverguy.com/blog/2012/2/23/vcenter-server-appliance-database.html

  7. Ustawienie logowania do zdalnego sysloga

    esxcli system syslog config get esxcli system syslog config set --loghost='tcp://ADRESIP:514' esxcli system syslog reload esxcli network firewall ruleset set --ruleset-id=syslog --enabled=true esxcli network firewall refresh Źródło: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2003322...

  8. Przypisywanie ilości rdzeni do jednego vCPU

    Listowanie VM: xe vm-list Ustawianie ilości rdzeni na jeden vCPU dla konkretnej VM z danym uuid: xe vm-param-set platform:cores-per-socket=4 uuid=<vm-uuid> Źródło: http://forums.citrix.com/thread.jspa?threadID=245236

  9. Tworzenie i odtwarzanie backupu dla bazy MySQL

    Tworzenie: mysqldump -u root -p Tutorials > tut_backup.sql Odtwarzanie: mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql] Zrodlo: http://www.webcheatsheet.com/SQL/mysql_backup_restore.php

  10. Sprawdzanie statusu Dell OpenManage pod XenServer

    /opt/dell/srvadmin/sbin/srvadmin-services.sh status