Friday, July 1, 2011

OS X Snow Leopard sync calendar & contacts Exchange 2003

Davmail app acts as a proxy between client software and Exchange web access including 2003.

To sync iCal:

To sync Address Book:
Type = CardDav
Name = username
Server = localhost:1080
(allow a few minutes for contacts to sync)

GAL can also be searched:
Type = LDAP
Name = username
Server = localhost:1389

Saturday, April 30, 2011

Autofs mount Samba shares on Linux Mint Debian Squeeze

There is a problem with autofs on Linux Mint Debian (Squeeze?) - the auto.smb file does not cater for the credentials file.  To fix you can download an updated auto.cifs file, see:
http://forums.fedoraforum.org/showthread.php?t=240811

Also edit the /etc/auto.master file to include the line:
/media/smb     /etc/auto.cifs  --ghost

----------
Error observed in /var/log/syslog before this file was corrected:
*Enter root's password

Friday, April 22, 2011

Linux get resolution in VNC/XRDP

Trying to get the resolution in a virtual display on Debian Squeeze, xrandr returns error:
 "extension missing on display"

Instead, use the xwininfo program:

width=`xwininfo -root | grep Width | awk '{ print $2}'`
height=`xwininfo -root | grep Height | awk '{ print $2}'`



Ref: http://www.debian-administration.org/articles/121

Sunday, April 10, 2011

Asterisk GUI on Debian Squeeze

Installation of FreePBX has many dependencies and is a very involved install.  An alternative is to use Digium's Asterisk-GUI, which doesn't seem to install by default in Debian.

cd /usr/src
svn co http://svn.digium.com/svn/asterisk-gui/branches/2.0 asterisk-gui
cd asterisk-gui
./configure
make
make install
make checkconfig

*Need to fix http location:
mv /usr/share/asterisk/static-http /usr/share/asterisk/static-http_orig
ln -s /var/lib/asterisk-gui/static-http /usr/share/asterisk/static-http


*Need to enable Asterisk HTTP:
nano /etc/asterisk/http.conf
    -> enable, bind, enable static, etc.
nano /etc/asterisk/manager.conf
  [admin]
  secret=password
  read=system,call,log,verbose,command,agent,user,config,originate,read,write
  write=system,call,log,verbose,command,agent,user,config,originate,read,write


*Need to fix permissions on folders
  cd /var/lib
    chown asterisk asterisk -R
    chgrp asterisk asterisk -R

/etc/init.d/asterisk restart

http://localhost:8088/static/config/index.html
*password reset forced (hack /etc/asterisk/manager.conf & set to *not* "password" if necessary)

Wednesday, April 6, 2011

Internet Explorer (IE) can't access HTTPS websites

Occurred on a Terminal Server after copying user profiles after a migration.  Internet Explorer (IE7 & IE8) were unable to browse any SSL HTTPS website, "Unable to load the page", if logged in as an ordinary user.  Okay if logged in as a local administrator.

Displaying the local SBS CA certificate as the user also showed an error that the certificate could not be validated.

The cause of the problem was a registry permission on HKCU\Software\Policies\Microsoft
- because this is where Group Policy gets applied the user only has explicit Read access; because the profile had been copied the explicit permission on the registry was incorrect.  To fix use regedit to load the hive and add the correct user with Read access.

Monday, March 7, 2011

Access Runtime error: There was an error executing the command

Check that the ODBC link to database has been configured.

Sunday, February 20, 2011

SBS 2003 shrink SBSMonitoring database

Execute the following commands to shrink the databases (suggest backing up beforehand):

osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKFILE (SBSMonitoring, 1)"


osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKFILE (SBSMonitoring_log, 1)"


osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKDATABASE (SBSMonitoring, 10)"