HIDEN.org

Building VPN Connections from any Windows client against IPCop running Zerina is actually very straightforward. Doing that from a Ubuntu client is a little bit tricky since ubuntu’s network manager cannot handle Zerina’s .p12 (pkcs) files.

• Install network-manager-openvpn using synaptic
• I know it’s not linux style – but do a reboot know – just to insure that all services are running. I had no success with the next steps without rebooting. Or I’ve been too lazy searching for the services that needed a restart.
• Download the .p12 file from IPCop or ask someone to do it for you.
• Now you have to extract 3 certificate files out of your .p12 file.
  
openssl pkcs12 -nocerts -in (filename).p12 -out userkey.pem
openssl pkcs12 -nokeys -clcerts -in (filename).p12 -out usercert.pem
openssl pkcs12 -nokeys -cacerts -in (filename).p12 -out userca.pem

  Or download that script and call it with pkcs2certs.sh your-username.p12 and it’ll create the required files for you.
• Now place the files into your vpn configuration and make the settings match your zerina configuration (cipher, compression etc.)

As you might have noticed we stopped the development MyAccess. However there are still people using MyAccess.

• Version 1.6.2beta now exists as a version for Access 2002 and Access 2003.
  If you are using 1.6.1 and everything works then there’s NO need for changing to 1.6.2beta.
  This version only fixes compatipility issues related to MS-Access.
• If you want to make modifications to MyAccess then the current source code file is here.
  Maybe someone would be so nice and test/port it to Access2007- Thanks !
  If you make any modifications then I’d be happy if you share the code.
• If you want to make modifications then please open the .mdb file and keep the <shift> button pressed. Now take a look at the autoexec macro or call from the direct window (ctrl-g) myaccess_start

Before trying MyAccess please make sure that MS-Access talks to your MySQL Server using MyODBC.
Otherwise it's completly useless trying MyAccess!

In case you suffer from a Error 40230 then it's most likeley that you need to run a decompile. How to do that is described here

MyAccess

Caps-Lock is (IMO) the most useless and annoying key. Since there doesn’t seem to be a GUI way for disabling just type the following in a terminal:

xmodmap -e “remove lock = Caps_Lock”

In order to make these changes permanent open your ~/.bashrc using

sudo nano ~/.bashrc

and add the line above

The Kerio Mailserver is a great thing when accessed via Outlook from Windows. When it comes to Linux Clients it get’s a little bit tricky but it can be done.

I’ve setup the email client Thunderbird with its addon Lightning for Calender/Tasks

1. Email via IMAP
   Simply specify your Hostname and Username/Password
2. Calendar/Tasks via calDAV
   Add a new network calendar using calDAV with the address

   http://<hostname>/calendars/<domain>/<user>/Calendar

3. Adressbook via LDAP
   Create a new Adressbook with LDAP
   Name: Your name but can be whatever you like
   Adress: your server’s hostname
   Base-DN:  fn=ContactRoot
   Port: 389
   Bind DN: your emailadress
   The only Drawback is that this Addressbook will be read-only