Selcuk's Blog

Çarşamba, Kasım 20, 2013

BIND DNS Subdomain Settings For Office 365

When you have BIND DNS server with subdomains, and you want to add Office 365 e-mail server settings one of the subdomains, you need add to records below in your master zone dns file.
;
; Microsoft Office 365
;
mysubdomain.domain.com.tr.         IN      MX             0 mysubdomain-comain-com-tr.mail.protection.outlook.com.

mysubdomain.domain.com.tr.         IN      TXT             "v=spf1 include:spf.protection.outlook.com -all"

 autodiscover.mysubdomain.domain.com.tr.    IN      CNAME   autodiscover.outlook.com.

sip.mysubdomain.domain.com.tr.     IN      CNAME   sipdir.online.lync.com.
lyncdiscover.mysubdomain.domain.com.tr.    IN      CNAME   webdir.online.lync.com.
;
; Microsoft Lync Online
;
_sip._tls.mysubdomain.domain.com.tr.        IN      SRV 100 1 443 sipdir.online.lync.com.
_sipfederationtls._tcp.mysubdomain.domain.com.tr.   IN      SRV 100 1 5061 sipfed.online.lync.com.
msoid.mysubdomain.domain.com.tr.   IN      CNAME   clientconfig.microsoftonline-p.net.
;



Pazartesi, Ekim 07, 2013

SQL Server Index Fragmentation Monitoring

Hi,

This is the very simple monitoring command for sql server. Of course you must create a mail profile.


DECLARE @xml NVARCHAR(MAX)
DECLARE @body NVARCHAR(MAX)

SET @xml = CAST(( SELECT Object_name(object_id) as 'td',s.name as 'td1'
,LTRIM(Str(avg_fragmentation_in_percent, 25, 3)) as 'td2'
FROM sys.dm_db_index_physical_stats (DB_ID('AdventureWorks2012'), NULL, NULL , NULL, 'LIMITED') d
join sysindexes s on d.object_id = s.id
and d.index_id = s.indid
and avg_fragmentation_in_percent > 30 and s.name is not null
FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))

SET @body =' < html >< body >< H 3>Index Fragmantetion Results< / H3 >
< table border = 1 >
< tr >
< th > Table Name < /th> Index Name < /th> Avg. Rate  < /tr >'    

SET @body = @body + @xml +'< /table>< /body>< /html>'
SET @body = REPLACE(@body,'td1','td')
SET @body = REPLACE(@body,'td2','td')

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'dbmail', -- you have to create this
    @recipients = 'mail@mail.com.tr',
@body = @body,
    @body_format ='HTML',
--@execute_query_database='AdventureWorks2012', --maybe necessary
    @subject = 'Index Monitoring' ;

Salı, Nisan 19, 2011

PDFCreator AutoSave Folder Reset at Windows 2008 R2

Just Set

Under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PDFCreator\Program Key SEt Auto-Save folder value.


Pazartesi, Mart 14, 2011

Simple OnAccess Scan Solution For Clamav in Redhat

Clamav is powerfull antivir solution for linux. But if you wantto add onaccess scan functionality of clamav you maus re-compile your kernel with DazukoFS. I think it is quite diffucult process for running systems.


There is another alternative for this with inotify tools. Here is the steps;

1. Instal ClamAv for linux.
2.Install intotify tools for linux
2.1. wget http://sourceforge.net/projects/inotify-tools/files/inotify-tools/3.13/inotify-tools-3.13.tar.gz/download
2.2 goto inotify source inotifywait.c line 310
2.3 add this lines before " fflush( NULL );" atom

static char * scanfiles;
nasprintf( &scanfiles, "%s%s",inotifytools_filename_from_wd( event->wd ), event->name );
char command[1000];
strcpy (command,"/usr/local/clamav/bin/clamscan -r --remove ");
strcat (command,scanfiles);
system(command);

2.4 goto instalation dir of inotify tools
2.5 run
./configure
make
make install
2.6 goto rc.local add this line

nohup /usr/local/bin/inotifywait -qq -r -m -e create,close_write /watch_folder_name/ > /dev/null &


also you can add these parameters before folder name , if you have joomla or another application

--exclude "refTableSQL/* --exclude "cache/*" (quotas must be include)

and that's it. When new file created or replaced , or whatever event ocuured, clamav scan these files.

I hope that this is helpfull for anyone.

Çarşamba, Ağustos 25, 2010

The Mars

Nihayet, uzun zamandır planladığım siteyi açtım.


www.iwanttogotomars.org

...

Pazar, Aralık 06, 2009

The module “jscript.dll” DllregisterServer failed with error code 0×80004005

Zalim bir virus darbesinden sonra bu hatayı alıyorsanız, Windows media player ını açılmıyorsa, Search ekranınız boş geliyorsa ve gecenin bir vakti çözüm arıyorsanız işte altenatif çözüm:


1.http://support.microsoft.com/kb/313222#Fixed adresine gidip , Microsoft fix it dosyasını indiriniz ve çalıştırınız. ( ah microsoft ah!)
2. Daha sonra bilgisayarınızı restart ediniz.
3. Başlat -> Çalıştır -> regsvr32 jscript.dll yazınız.
4. Media Player 'ı çalıştırınız.

gece saat01 itibariyle sorunum çözüldü.


Salı, Temmuz 25, 2006

regenerative dentistry

Galiba çok kısa bir süre içinde bu terimi sıkça duyacağız. yılardır benim de hayalim olan; diş dolgusu, kanal tedavisi, iğrenç çürüklerden kurtulup, çürüyen pis :) dişimizin yerine , yenisini çıkartabileceğiz. http://www.odontis.co.uk/ adresinden detaylar öğrenilebilir.