Updating to release

Pirate Praveen Public Seen by 398

I have prepared diaspora-installer-mysql (https://people.debian.org/~praveen/diaspora/) and did some basic testing. I need some help in more through testing, especially for updates as I have done some re-factoring/cleanup of the code. We should test upgrading from 0.5 to 0.6 as well. If someone can review the diaspora-common.postinst, postinst scripts that would be great too.

Repo here https://anonscm.debian.org/cgit/pkg-ruby-extras/diaspora-installer.git

We need to verify backup is working properly (last time I checked, there was some error in slave status). I will check again and announce a downtime to reset replication (we'll have to stop diaspora, copy the database files and restart replication).

Once we verify backup is proper, we can install diaspora-installer


Aurabindo J Mon 29 Aug 2016

I tried installing the diaspora-installer package in debian 8, but failed with a dependency error: http://paste.debian.net/794799/


Pirate Praveen Mon 29 Aug 2016

@jayaura thanks! You need to enable jessie-backports as well.

Add jessie-backports to your sources.list and run
# apt-get -t jessie-backports install diaspora-installer-mysql


Pirate Praveen Tue 30 Aug 2016

Backup server had died a month back (Jul 25 was the modification date on /var/lib/diaspora/rsync-uploads.log). Waiting for it to catch up in the next cron run.

Master status:
File: mysql-bin.000171
        Position: 1281767

Slave status:
 Master_Log_File: mysql-bin.000135
          Read_Master_Log_Pos: 8763817

Last_Errno: 1452
                   Last_Error: Error 'Cannot add or update a child row: a foreign key constraint fails (`pprod`.`notification_actors`, CONSTRAINT `notification_actors_notification_id_fk` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE)' on query. Default database: 'pprod'. Query: 'INSERT INTO `notification_actors` (`notification_id`, `person_id`, `created_at`, `updated_at`) VALUES (127061, 77410, '2016-03-28 01:31:40', '2016-03-28 01:31:40')'

So I'll announce a down time once rsync catches up and we'll reset replication. If anyone wants to learn replication, I'm happy to guide, we can schedule a time and hangout at our xmpp room.


Pirate Praveen Tue 30 Aug 2016

rsync completed and I'll schedule backup for tomorrow 11 am IST.


Pirate Praveen Tue 30 Aug 2016

Posted down time notice https://diasp.in/posts/368361


Pirate Praveen Fri 2 Sep 2016

poddery.com is now running on

I have restarted replication and this is the current status,

Slave is at,
Master_Log_File: mysql-bin.000174
Read_Master_Log_Pos: 1639568

and master is at,
File: mysql-bin.000174
Position: 1643876

It will take a while to catch up.