In a previous post<\/a>, I went through how to build a calendar sever using DAViCal – created by fellow kiwi Andrew McMillan<\/a>.<\/p>\n The server has run perfectly since the day I built it, and it was only recently (read: last year) that I noticed I was no longer getting my event reminders on my iPhone. I had recently upgraded to iOS7 and assumed that maybe the authentication information had probably got scambled during the upgrade, so I deleted and re-added the user information but failed to rectify the problem. It still worked fine on my first gen iPad using iOS6 so I knew it had to be related to the upgrade.<\/p>\n After scouring the web for a solution, I discovered I wasn’t the only person having problems… and it wasn’t just with DAViCal. There was a lot of finger pointing and wringing of hands, but at the time I couldn’t find any solution to fix it.<\/p>\n I keep checking the author’s website, the DAViCal website and hoped there would be a package update but alas nothing appeared. As time marched on my interest waned until one day I forgot all about it.<\/p>\n The other day I got to thinking about my iPhone (in particular iOS7) and the how the various revisions to the iOS software had failed to fix my calendar problems. Armed with renewed vigor I jumped on the web and had a look to see if there were any fixes… and to my joy, discovered this post here <\/a>(well, found a forum which ultimately linked to that location).<\/p>\n I copied the files, updated the database, and… success! Cross-platform access to read\/write calendar entries!! For anyone else looking for the similar steps, here’s what I did.<\/p>\n If you want a fallback option, it might be worth backing up the existing files for both davical and awl. I’m using mine on an Ubuntu server so my files are located in \\usr\\share\\davical<\/strong> and \\usr\\share\\awl<\/strong>.<\/p>\n Note:<\/strong><\/span><\/p>\n When I originally created the database I must have used the ‘postgres<\/strong>‘ superuser. This meant that when I tried to update the database using the user ‘davical_dba<\/strong>‘ I got a permission error. The original command in the sql file was: For good measure I restarted the server, but one restarted I had no problems adding calendar entries on my iPhone, and viewing others I’d created on other calendar applications (namely Thunderbird+Lightning).<\/p>\n If you’re like me and the ravages of time play havoc with your memory (i.e. you forgot your postgres<\/strong> user password) don’t panic: you can reset it using the following steps…<\/p>\n change the line for the postgres user to read<\/p>\n then restart the server.<\/p>\n Log into PostgreSQL and at the postgres prompt (postgres=#) change the password…<\/p>\n where secure-password<\/em><\/span> is a password of your choice.<\/p>\n Change the pg_hba.conf<\/strong> file back…<\/p>\n then restart the server.<\/p>\n Log in to psql<\/strong> to make sure the new password is effective.<\/p>\n Are we speaking the same language? In a previous post, I went through how to build a calendar sever using DAViCal – created by fellow kiwi Andrew McMillan. The server has run perfectly since the day I built it, and it was only recently (read: last year) that I noticed I was no longer getting… Read more »<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[66,65,110,107,108,106,111,67,109],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","category-technical-resource","tag-calendar","tag-davical","tag-davical_dba","tag-ios","tag-ios7","tag-iphone","tag-pg_hba-conf","tag-postgresql","tag-psql"],"_links":{"self":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=133"}],"version-history":[{"count":5,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":168,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=\/wp\/v2\/posts\/133\/revisions\/168"}],"wp:attachment":[{"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/templesoft.co.nz\/journal\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}A fix found…<\/h2>\n
Step one: Get the update<\/h3>\n
sudo wget http:\/\/www.inf-it.com\/fixes\/DAViCal_GIT-latest.tgz\r\nsudo tar -zxvf DAViCal_GIT-latest.tgz\r\ncd DAViCal_GIT-latest\/davical<\/pre>\n
Step two: Copy the files<\/h3>\n
sudo cp -vR \/davical\/* \/usr\/share\/davical\/\r\nsudo cp -vR \/awl\/* usr\/share\/awl\/<\/pre>\n
Step three: Update the database<\/h3>\n
sudo cd \/usr\/share\/davical\/dba\r\nsudo wget http:\/\/www.inf-it.com\/fixes\/caldav_functions-fix2.sql\r\npsql -U postgres davical < caldav_functions-fix2.sql<\/pre>\n
\n
\n<\/span><\/p>\npsql -U davical_dba davical < caldav_functions-fix2.sql<\/pre>\n<\/blockquote>\n
Step four: Restart the server<\/h3>\n
Notes on the PostgreSQL superuser<\/h2>\n
sudo vi \/etc\/postgresql\/8.4\/main\/pg_hba.conf<\/pre>\n
local\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/span><\/pre>\nsudo \/etc\/init.d\/postgresql restart<\/pre>\n
psql -U postgres\r\n\r\npostgres=# ALTER USER postgres with password '<\/strong>secure-password<\/em>'<\/strong><\/span>;<\/span><\/pre>\nsudo vi \/etc\/postgresql\/8.4\/main\/pg_hba.conf\r\n\r\nlocal\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/span><\/pre>\nsudo \/etc\/init.d\/postgresql restart<\/pre>\n
psql -U postgres<\/pre>\n","protected":false},"excerpt":{"rendered":"