Docs (software), Not Linux but FLOSS & survival, Security, Linux, Programming, DB, Drupal, PHP, Python, Tools, Administration, Apache, DB & PostgreSQL, Friendly programming environment, Install & HW woes, Mail, General, Search engines

PostgreSQL inheritance surprises

Posted Tue, 2010-06-08 19:03 by ivan

I've been trying t exploit inherits in PostgreSQL in a OO way with no success at this moment, meanwhile I came out with this code that underline the "surprises" you may have when you use inherits.

ODBC, FreeTDS and Microsoft SQL (and php)

Posted Tue, 2010-06-08 19:01 by ivan

What is it all about

I had to connect to a MS SQL server from php from a Linux box. First I tried with php mssql_* functions, but they are not compiled nor the php MS SQL support is available through deb packages.
So I tried to use odbc_* functions but after specifying everything I thought reasonable for the connection I was still havign this error:

Warning: odbc_pconnect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /home/ivan/Documents/kerberos/work/gorilla/scripts/cover_note/dbconn.php on line 11
no connection

I googled and I discovered I had to install ODBC drivers... at my surprise installing unixodbc was not enough.

mainly SUSE fetchmail-postfix-spamassassin-procmail impatient-HOWTO

Posted Tue, 2010-06-08 18:59 by ivan

Ripubblico questo documento anche se datato, forse poco attuale e difficile da supportare in quanto sono passato a Debian.

In Debian dpkg rende tutto molto più facile e le modifiche che forse rimangono attuali sono quelle a mailbox_command e a ulteriori configurazioni antispam di postfix

La parte generale può essere utile per farsi un idea generale di come funzioni la posta e a districarsi tra un po' di acronimi

L'augurio è di avere il tempo di dividere questo documento in documenti più compatti e più attuali.

La catena di montaggio delle email in un server non pubblico

Posted Tue, 2010-06-08 18:58 by ivan

Micro riassunto

Acronimi e vari passaggi della vostra posta da e per il resto del mondo

different results for "link:" vs "link: " in Google

Posted Tue, 2010-06-08 18:57 by ivan

Looking for:

link: www.webthatworks.it

in Google display different (generaly more) results than looking for
link:www.webthatworks.it

What happens is that in the first case Google is looking for "link" + "www.webthatworks.it" and in the second case it is looking for links to www.webthatworks.it, maybe even in the form window.location('http://www.webthatworks.it').

Apache2 + PAM

Posted Tue, 2010-06-08 18:43 by ivan

PAM setup

I'd like to use PAM for authentication but till now I haven't succedeed to make it work in a reasonable way. The only working solution have serious security drawbacks.

Apache2 SSL setup

Posted Tue, 2010-06-08 18:42 by ivan

package nedded: apache2 openssl ssl-cert

Ruby on Rails on Debian sarge

Posted Tue, 2010-06-08 18:42 by ivan

You may get into some errors trying to make Ruby on Rails work on sarge. I came across a solution.
It seems to work... but I just got the demo server app. working but didn't test it enough to say it really work.

Subversion on WebDAV

Posted Tue, 2010-06-08 18:41 by ivan

Create a subversion repository

I keep things that risk to be overwritten/deleted by package managers in /usr/local and I put all my local config in /usr/local/etc/ and then symlink to the main /etc (I'm open to suggestions).

Autosigned cert (apache, imapd, etc...)

Posted Tue, 2010-06-08 18:40 by ivan

openssl req -new -x509 -nodes -keyout imapd.pem -out imapd.pem -days 365 -newkey rsa:2048

Of course you could generate certificates for imaps as well as Apache, postfix etc... with the same system.

Syndicate

Syndicate content