SQL 2005 MM-DDD-YY format

To format a date as MM-DDD-YY

Today:
REPLACE(right(UPPER(convert(varchar(20),getdate() ,06)), len(convert(varchar(20),getdate(),06))), ‘ ‘, ‘-‘)

to get Yesterday’s date:

PRINT REPLACE(right(UPPER(convert(varchar(20),getdate()-1 ,06)), len(convert(varchar(20),getdate()-1,06))), ‘ ‘, ‘-‘)

Extra date format for Microsoft SQL:
Continue reading SQL 2005 MM-DDD-YY format

Saudi Aramco selects Actenum DSO/Upstream software for scheduling Exploration drilling

Vancouver, BC, 22 June 2011 – Actenum Corporation today announced that Aramco Services Company’s subsidiary of Saudi Aramco, the world’s largest petroleum company?has acquired DSO/Upstream for use by Saudi Aramco’s Exploration Department.

DSO/Upstream will enable Saudi Aramco users to manage exploration drilling programs on a multi-year basis, balancing scheduled activities against available resources and departmental targets. Using DSO/Upstream’s multi-objective optimization facility, together with its integrated scenario generation and analysis features, schedulers will be able to track and control key metrics as drilling programs are created and updated over time.

[ad#ad-2]

Continue reading Saudi Aramco selects Actenum DSO/Upstream software for scheduling Exploration drilling

Cisco 7940/7960 Protocol Application Invalid

The easiest way to fix this is to setup Windows DHCP or Linux DHCP and pass TFTP IP address from your DHCP Server.

I fixed my issue by setting up DHCP in Windows 2003, then as per Cisco recommendation, I added the option 150 to the DHCP, check this link: http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008055c1fe.shtml

There is another step, in Windows 2003, . . . → Read More: Cisco 7940/7960 Protocol Application Invalid

Installing IIS – issue with staxmem.dll

If you are receiving error copying staxmem.dll then

Click Start, go to RUN, type cmd press enter
type the following command:

esentutl /p %windir%/security/database/secedit.sdb

then go to Control Panel, Add/Remove Program then Add/Remove Windows Components, first, uncheck Internet Information Services (IIS) —-Make sure to backup your Intepub folder just in case

click next to remove it. then . . . → Read More: Installing IIS – issue with staxmem.dll

Coverting a Cisco 7940 SIP to SCCP

I had worked on this for almost two days and finally managed to figure it out… lots of people are having issues converting Cisco 7940 from SIP to SCCP…

Make sure that you have the following files in your TFTP server:

– SIPdefault.cnf: change the first line, which is image_version: “P00307000200”, you might have something like “P003-08-8-00” which . . . → Read More: Coverting a Cisco 7940 SIP to SCCP

sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

in FreePBX sometimes you might get the following error message in you upload an MP3:

Error Processing: “sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

I convert the MP3 file to WAV and it worked ok… make sure that you convert it to 11,025 kHz, 16 Bit, Mono . . . → Read More: sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

How to install Windows Powershell on Windows 2008

Microsoft PowerShell comes as Features under windows 2008. To install Powershell go to Server Manager, Features, click on Add Features, scroll all the way down, select Windows PowerShell. it might take up to 20 minutes for Powershell to be . . . → Read More: How to install Windows Powershell on Windows 2008

I’m sorry, an error has occurred – voice mail – new install

If you get the message: “I’m sorry, an error has occurred”

edit voicemail.conf in /etc/asterisk

under [default] you might find empty [] remove and save the file.. reload asterisk and this should fix it.

i.e:

[general]
#include vm_general.inc
#include vm_email.inc
[default]

[]
221 => 221,,,,attach=yes|=
[]
226 => 226,,,,attach=no|saycid=no|envelope=no|delete=no

remove [] . . . → Read More: I’m sorry, an error has occurred – voice mail – new install

Nagios and NDOutil 1.4b8

Installing NDOutil add-on for Nagios sometimes might be a painful process… for most case it’s just permission issue, specially mysql and NDO sock…

most of the time, you might get the following error message:

ndomod: Error writing to data sink! Some output may get lost…
ndomod: Successfully flushed 73 queued items to data sink.

or
ndomod: Could not open data sink! I’ll keep trying, but some output may get lost…

first of all, make sure that you use unix socket in your config file and not TCP.. it’s recommend to use unix socket…

Continue reading Nagios and NDOutil 1.4b8

Installing Asterisk and Freepbx on Debian 5.0 (lenny)

I have recently installed Asterisk 1.4.23 on Debian Lenny… I’m sure there are lot of people looking for article in regards to Asterisk and Debian… here is a good one:

http://www.corenetworks.com.au/wiki/doku.php?id=install_voip_server

everything is explained pretty good there… There is also script designed that will kind of do A to Z to you… however, you need to pay attention . . . → Read More: Installing Asterisk and Freepbx on Debian 5.0 (lenny)