Daily Archives: August 25, 2005

Meget enklere…

Ja min hjemmeside var efterhånden ved at bliver alt for tungt, så jeg har fundet dette utrolige simple system, der har dog vist sig at være et par fejl, i det. Som jeg forsøger at løse.

Men ellers er hjemmesiden bygget op omkring mine nyhed/blogs. Håber i syntes det er bedre end den gamle hjemmeside.

mySQL kommandoer i PHP

Lidt kommandoer til at arbejde med mySQl
Koble sig til en mySQL server
$mysql_server = “localhost”;
$mysql_bruger = “bruger”;
$mysql_password = “password”;
$mysql_database = “database”;
if (!mysql_connect(“$mysql_server”,”$mysql_bruger”,”$mysql_password”)) {
echo(“Kunne ikke oprette en forbindelse til MySQL.”);
exit;
}
if(!mysql_select_db(“$mysql_database”)) {
echo(“Kunne ikke vælge databasen: $database”);
exit;
}

Hente data ud fra en mySQL
$sql = mysql_query(“SELECT * FROM table”);
while ($rs = mysql_fetch_array($sql)) {
}

Qmail: Vpopmail & SSL

Mini howto’s about putting ssl on Vpopmail.
My Qmail is running after this guide:
http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm

apt-get install stunnel4
mkdir -p /var/log/qmail/pop3d-ssl/
chown -R qmaill.nofiles /var/log/qmail/pop3d-ssl/

mkdir -p /var/qmail/supervise/qmail-pop3d-ssl
mkdir -p /var/qmail/supervise/qmail-pop3d-ssl/log

/var/qmail/supervise/qmail-pop3-ssl/run

#!/bin/sh
exec /usr/local/bin/softlimit -m 4000000
/usr/local/bin/tcpserver -H -R -v -l annsofie.dumdidum.dk -c100 0 995
/usr/sbin/stunnel4 /var/qmail/control/pop3s.conf 2>&1

/var/qmail/supervise/qmail-pop3d-ssl/log/run

#!/bin/sh
# Keep 30 logs of max 10Mb each
# They will get rotated when they reach 10Mb in size,
# or at midnight when our crontab script fires (whichever event comes 1st)
exec /usr/local/bin/setuidgid qmaill /usr/local/bin/multilog t s10000000 n30 /var/log/qmail/pop3d-ssl

/var/qmail/control/pop3s.conf

debug = 1
output = /var/log/qmail/stunnel.log
cert = /var/qmail/control/servercert.pem
exec = /var/qmail/bin/qmail-popup
execargs = /var/qmail/bin/qmail-popup annsofie.dumdidum.dk /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir

cd /var/qmail/control/
openssl req -new -x509 -nodes -out servercert.pem -days 3650 -keyout servercert.pem

ln -s /var/qmail/supervise/qmail-pop3d-ssl/ /service/
svc -u /service//qmail-pop3d-ssl

Åbne exe attachment i outlook

Har i oplevet at i ikke kan åbne .exe, .mdb og andre filer i en nyere Outlook dette skyldtes et filter Microsoft har sat ind, man kan dog overstyrer dette filter. Se mere her omkring hvordan i gør.
(Always make a backup before editing the registry.) To use this key:
1. Run Regedit, and go to this key:

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security (change 10.0 to 9.0 for Outlook 2000 SP3 or to 11.0 for Outlook 2003)
2. Under that key, add a new string value named Level1Remove.
3. For the value for Level1Remove, enter a semicolon-delimited list of file extensions. For example, entering this:

.mdb;.url

would unblock Microsoft Access files and Internet shortcuts. Note that the use of a leading dot was not previously required, however, new security patches may require it. If you are using “mdb;url” format and extensions are blocked, add a dot to each extension. Note also that there is not a space between extensions.