- luv-main - example.com

Test
by Mick 23 Oct '15

23 Oct '15

Can anyone see this? I suspect my emails do not reach the list... -- Mick

1 0

sorry for the downtime
by Russell Coker 21 Oct '15

21 Oct '15

An upgrade of the LUV server from Debian/Wheezy to Debian/Jessie last night didn't go as planned. Sorry for the inconvenience. Everything SHOULD be working correctly now. If anything doesn't work then please let me know. I'll blog about how it happened when I get some spare time. -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/

2 2

Hardware library
by Russell Coker 19 Oct '15

19 Oct '15

The hardware library is getting depleted. Please consider what you can donate. -- Sent from my Samsung Galaxy Note 3 with K-9 Mail.

3 2

Noobieish help request with postgres / sql (copy command to import csv with NULL date)
by h 18 Oct '15

18 Oct '15

Hi, I have set up a postgis database (PostgreSQL 9.3.6 on currently updated open Suse) and am trying to import some third party csv file. I did some basic sql a long time ago, but I was never an expert, and am now rusty :) In my "CREATE TABLE" command I am defining about 50 attributes / columns. Two of them are: ACCIDENT_DATE date, ACCIDENT_TIME time, My csv files generally have date and time values, but there are a number of NULL values represented as --,"",-- I expected / hoped that these would be imported as NULL values, but when I run the copy command, I get the error message - ERROR: invalid input syntax for type time: "" Can someone help me to get the empty double quoted value accepted as a NULL value for date and for time? TIA sql command: copy crashes FROM '/ACCIDENT.CSV' DELIMITER ',' CSV; Data Sample with "" time: "ACCIDENT_NO","ACCIDENT_DATE","ACCIDENT_TIME","ACCIDENT_TYPE","DAY_OF_WEEK","DCA_CODE","LIGHT_CONDITION","NO_PERSONS","NO_PERSONS_KILLED","NO_PERSONS_INJ_2","NO_PERSONS_INJ_3","NO_PERSONS_NOT_INJ","NO_OF_VEHICLES","POLICE_ATTEND","ROAD_GEOMETRY","SEVERITY","SPEED_ZONE","IMAGE_NO_DIGIT","IMAGE_NO_FRAME","IMAGE_RUN_NO","NODE_ID","LOCATION_TYPE","LOCALS_INVOLVED","NODE_ID","NODE_TYPE","LOCATION_TYPE","LOCATED_MIDPOINT","COMPLEX_INT_NO","AMG_X","AMG_Y","ROAD_NAME_1","ROAD_TYPE_1","ROAD_DESC_1","ROAD_ROUTE_1","ROAD_NAME_2","ROAD_TYPE_2","ROAD_DESC_2","ROAD_NAME_3","ROAD_TYPE_3","ROAD_DESC_3","DISTANCE_LOCATION","DIRECTION_LOCATION","NEAREST_KM_POST","OFF_ROAD_LOCATION","DIRECTORY","EDITION","PAGE","GRID_REFERENCE_X","GRID_REFERENCE_Y","LGA_NAME","REGION_NAME","UNKNOWN" "W1990000191","1989-12-19","","5",3,"183","5",1,0,1,0,0,1,"1","5","2","100",1518,1517,1050,18378,"N","Y",18378,"N","N","Y",0,648329.25,5958402,"GREAT ALPINE","ROAD","",4005,"UNNAMED","","","MCILROY RAE","ROAD","",73,"S",,"","VCD","ED7","35","C","9","ALPINE","NORTH EASTERN REGION",0 "P1990028638","1990-07-19","18:00:00","4",5,"183","5",1,0,0,1,0,1,"1","5","3","100",1828,1827,1086,18378,"N","Y",18378,"N","N","Y",0,648329.25,5958402,"GREAT ALPINE","ROAD","",4005,"UNNAMED","","","MCILROY RAE","ROAD","",73,"S",,"","VCD","ED7","35","C","9","ALPINE","NORTH EASTERN REGION",0 "P1990029504","1990-08-15","15:45:00","1",4,"130","1",7,0,0,4,3,2,"1","5","3","60",146,144,1097,18383,"N","N",18383,"N","N","N",0,654588.610512537,5951870.61325035,"MYRTLEFORD-YACKANDANDAH","ROAD","",5467,"MUMMERY","ROAD","","ODONNELL","AVENUE","",36,"SW",,"","VCD","ED7","660","C","3","ALPINE","NORTH EASTERN REGION",0 "P1990039075","1990-10-26","00:15:00","4",6,"181","5",4,0,1,3,0,1,"2","5","2","100",1666,1665,1102,18398,"N","Y",18398,"N","N","N",0,652283.479975146,5950175.41617511,"MERRIANG","ROAD","",177824,"TONIAZZO","LANE","","CRAMERI","LANE","",118,"NW",,"","VCD","ED7","49","D","3","ALPINE","NORTH EASTERN REGION",0

3 3

mailman breaking DKIM
by Russell Coker 18 Oct '15

18 Oct '15

I have found the cause of the DKIM problems. When Mailman unfolds and refolds the DKIM-Signature header it replaces tabs with spaces. This makes the difference between a message that passes according to /usr/bin/dkimproxy-verify (part of the libmail-dkim-perl package) and one that fails. Is anyone here any good at Python who can have a look at this? Some special case code to use tabs for the DKIM-Signature header should solve these problems without causing any other problems. Note that a problem that was reported in the past was Mailman replacing spaces with tabs when folding the Subject header. Obviously we don't want to regenerate that problem so changing the behavior of all headers would be a bad thing. -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/

3 4

MTA training
by Russell Coker 17 Oct '15

17 Oct '15

http://etbe.coker.com.au/2015/10/17/mail-server-training/ If anyone wants to do the MTA training at home the above URL has the notes. -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/

1 0

Beginners sig shell event
by Russell Coker 17 Oct '15

17 Oct '15

Who's interested in hands on training in basic Unix shell commands and sysadmin skills? Similar format to the mail server training but covering more beginner stuff. -- Sent from my Samsung Galaxy Note 3 with K-9 Mail.

1 0

'There Is No Human Right To Patent Protection' -- UN Special Rapporteur
by Andrew Pam 16 Oct '15

16 Oct '15

"There is no human right to patent protection. The right to protection of moral and material interests cannot be used to defend patent laws that inadequately respect the right to participate in cultural life, to enjoy the benefits of scientific progress and its applications, to scientific freedoms and the right to food and health and the rights of indigenous peoples and local communities." <https://www.techdirt.com/articles/20151013/09390532525/there-is-no-human-ri…> Looks like an interesting report. Cheers, Andrew

1 0

Totem couldn't handle H.264; mplayer2 did.
by Erik Christiansen 11 Oct '15

11 Oct '15

I have totem 3.0.1 and libgstreamer0.10-0 installed, and youtube & other videos play fine, but an emailed apple-flavoured clip: $ file Desktop/IMG_8015.MOV Desktop/IMG_8015.MOV: ISO Media, Apple QuickTime movie shows only as grey/green/white diagonal bands, although the audio replays fine. Totem shows the properties of the clip as: Dimensions: 568 x 320 Codec: H.264 / AVC Framerate: 30 frames per second Bitrate: 701 kbps Installing mplayer2 was the first fix which worked. Is totem not up to playing Apple clips, or does it just need a config tweak / plugin ? The totem version might not be the latest - I'm on Debian 7.8.0. Erik

2 2

Non ISP mail servers.... metadata
by Andrew McGlashan 08 Oct '15

08 Oct '15

With the metadata laws.... does anyone here have a good understanding on how we stand running our own mail servers onsite for ourselves and/or for our clients (domains owned by us and also by clients) ? http://blog.fastmail.com/2015/04/09/fastmail-is-not-required-to-implement-t… Kind Regards AndrewM

5 10