Архив рубрики: Без рубрики

Переход на постоянное зимнее время 26.10.2014 Centos/Debian/Ubuntu/Windows/Cisco… etc

Добавить комментарий

Собственно актуально.

В соответствии с постановлением главы нашего государства переход на зимнее время состоится в ночь на 26 октября 2014 года

Ман по переходу на различных версиях ОС ниже.

Windows (2008 R2)

wusa.exe \\FS\setup$\Windows6.1-KB2998527-x64.msu /quiet /norestart
tzutil /s "Russian Standard Time"

Freebsd

[root@eis /home/lexit/tzdata] zdump -v /etc/localtime | grep 2014

#fetch ftp://ftp.iana.org/tz/tzdata-latest.tar.gz
#mkdir tzdata 
#cd tzdata
#tar xzf ../tzdata-latest.tar.gz
#zic europe
#tzdata
[x]Europe [x] Russian Federation][x] Moscow

# zdump -v /etc/localtime | grep 2014
/etc/localtime Sat Oct 25 21:59:59 2014 UTC = Sun Oct 26 01:59:59 2014 MSK isdst=0 gmtoff=14400
/etc/localtime Sat Oct 25 22:00:00 2014 UTC = Sun Oct 26 01:00:00 2014 MSK isdst=0 gmtoff=10800

Centos

Вариант 1. ( для продакт сред может принести лишний геморой)   yum update && yum upgrade

Вариант 2.

# yum update tzdata
# rm -rf /etc/localtime
# ln -s /usr/share/zoneinfo/Europe/Moscow /etc/localtime

Debian / Ubuntu / + (java)

Вариант 1. ( для продакт сред может принести лишний геморой) apt-get update && apt-get upgrade

Вариант 2.

wget http://ftp.ru.debian.org/debian/pool/main/t/tzdata/tzdata_2014h-2_all.deb 
dpkg -i tzdata_2014h-2_all.deb 

#JAVA
wget http://ftp.ru.debian.org/debian/pool/main/t/tzdata/tzdata-java_2014h-2_all.deb
dpkg -i tzdata-java_2014h-2_all.deb

#check
zdump -v /etc/localtime | grep 2014

Java (Windows)

 

http://www.oracle.com/technetwork/java/javase/downloads/tzupdater-download-513681.html

c:\Install>java -jar tzupdater.jar -u -v
java.home: C:\Program Files\Java\jre7
java.vendor: Oracle Corporation
java.version: 1.7.0_71
JRE time zone data version: tzdata2014c
Embedded time zone data version: tzdata2014h
Extracting files... done.
Renaming directories... done.
Validating the new time zone data... done.
Time zone data update is complete.

Exchange

Exchange Server meetings in Russian time zones as well as names of time zones are incorrect after October 26, 2014

http://support2.microsoft.com/kb/3004235

Cisco

clock timezone MSK 3
ntp master 3
ntp server 192.168.0.2

This mailbox database contains one or more mailboxes

1 комментарий 
Get-Mailbox -Database "Mailbox Database 0463961086" | New-MoveRequest -TargetDatabase "MDB1"
Get-Mailbox -Archive -Database 'Mailbox Database 0463961086' | New-MoveRequest -TargetDatabase "MDB1"
Get-Mailbox -PublicFolder -Database 'Mailbox Database 0463961086' | New-MoveRequest -TargetDatabase "MDB1"
Get-Mailbox -Arbitration -Database 'Mailbox Database 0463961086' | New-MoveRequest -TargetDatabase "MDB1"


Get-Mailbox | where {$_.ArchiveDatabase -eq "Mailbox Database 0463961086"}

Name Alias ServerName ProhibitSendQuota
---- ----- ---------- -----------------
Firstname Lastname0001... user0001 mail 8 GB (8,589,934,592 bytes)
...

new-moveRequest user0001 -ArchiveOnly

Get-MailboxExportRequest | ?{ $_.RequestQueue -eq "Mailbox Database 0463961086" }

Name Mailbox Status
---- ------- ------
MailboxExport ***.***/User999 Failed

Get-MailboxExportRequest -Status Completed | Remove-MailboxExportRequest
Get-MailboxExportRequest -Status failed | Remove-MailboxExportRequest

Remove-Database "Mailbox Database 0463961086"

AdressBookPolicy exchange 2013

Добавить комментарий 
New-AddressList -Name "PROMOUTER_ADR" -RecipientFilter {((RecipientType -eq 'UserMailbox') -or (RecipientType -eq "MailUniversalDistributionGroup") -or (RecipientType -eq "DynamicDistributionGroup")) -and (title -eq "Промоутер")}

New-AddressList -Name PROMOUTER_Room -RecipientFilter {(Alias -ne $null) -and (title -eq "Промоутер")-and (RecipientDisplayType -eq 'ConferenceRoomMailbox') -or (RecipientDisplayType -eq 'SyncedConferenceRoomMailbox')}

New-GlobalAddressList -Name "GAL_PROMOUTER" -RecipientFilter {(title -eq "Промоутер")}

New-OfflineAddressBook -Name "OAB_PROMOUTER" -AddressLists "GAL_PROMOUTER"

New-AddressBookPolicy -Name "ABP_PROMOUTER" -AddressLists "PROMOUTER_ADR" -OfflineAddressBook "\OAB_PROMOUTER" -GlobalAddressList "\GAL_PROMOUTER" -RoomList "\PROMOUTER_Room"

Get-Mailbox -resultsize unlimited | where {$_.title -eq "Промоутер"} | Set-Mailbox -AddressBookPolicy "ABP_PROMOUTER"

Убираем тяжелый MySQL запрос

Добавить комментарий

1. Заходим на сервер по SSH

mysql>
mysql> use asterisk;
mysql> show processlist;
+--------+----------+-----------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id     | User     | Host      | db       | Command | Time | State                | Info                                                                                                 |
+--------+----------+-----------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 179394 | asterisk | localhost | asterisk | Query   | 1056 | Locked               | INSERT INTO cdr (`calldate`,`clid`,`src`,`dst`,`dcontext`,`channel`,`dstchannel`,`lastapp`,`lastdata |
| 190018 | root     | localhost | asterisk | Query   | 1080 | Locked               | UPDATE cdr SET import_cdr=1 WHERE acctid=384599                                                      |
| 190024 | root     | localhost | asterisk | Query   |    0 | NULL                 | show processlist                                                                                     |
| 190027 | manager   | localhost | asterisk | Query   |    9 | Locked               | SELECT * FROM `cdr`
LIMIT 0, 30                                                                     |
+--------+----------+-----------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)


mysql> kill 190027;
Query OK, 0 rows affected (0.00 sec)

Powershell удаление файлов старше n дней

1 комментарий

С рекурсивным обходом папок

$now = Get-Date
$date = $now.AddMonths(-1)
$files = Get-ChildItem -Path C:\Log -recurse | Where {$_.LastWriteTime -le "$date"}
foreach ($file in $files) {
write-host "Deleting File $file" -foregroundcolor "Red";  
Remove-Item $file # для теста добавить -whatif
}

Squid блокировка «всё кроме «…

Добавить комментарий

#—————БАНКИ———————
acl banki url_regex «/etc/squid/banki.txt»
acl banki_port port 443 9443 9080 8080 80 6548 8457
http_access allow banki_port banki
#——————————————

#—————HTTPS Сайты доступные———————
acl sites_url url_regex «/etc/squid/sites_access.txt»
acl sites_port port 443 80
http_access allow sites_port sites_url
#——————————————

/etc/squid/sites_access.txt

Регулярка Разрешить все кроме…

!(^|[-\?+=/_])(mail|mail?|disk?|vk|vk?|gmail|gmail+)([-\?+=/_]|$)