This discussion was fascinating ... and I am very glad that Stuart and Darren invited me to be a part of this.
I had an issue a few weeks ago where a Community owner of a Lotus Connections Community deleted the forums widget - realised that deleting it - well actually meant it was gone.
In the user's defence, they wanted to make the forum read only and thought that removing it from the community would mean it would be retained elsewhere. My poor distraught user did actually say that the system warned that it was going to delete it - The user in question is not dumb, They are intelligent, switched on and web-savvy, yet still they managed to delete something that actually warned them it was going to be deleted.
My initial reaction was "how can anyone be so STUPID?" I huffed and puffed and once my initial mood of "muppet" had worn off I thought about it in more detail. Maybe for community widgets the error message needs to be more specific, users need to realise that deleting means not just from the community but GONE - this is not apparent it seems - some work may need to be done here.
The user in question called me in a panic once the widget had been deleted and realised that the information contained in said widget was not available outside of the community. I tried to play the "sorry - it's gone" card, but this was possibly the most important thing ever stored on the Connections environment - Consultation feedback about our Vice Chancellors vision for where the University is heading for the next 5 years,
I started taking a serious look into how I would get this information back - I thought it would be a chore .. but do-able, It wasn't as straight forward as I had hoped.
Communities are a fantastic thing inside connections - having a collection of people collaborating on a certain subject, or a bunch of like minded people just *shooting the breeze* getting ideas out and sharing knowledge. Many of the users here love the fact they can customise their own communities by adding removing and hiding widgets - fabulous for the users .. nightmare for the admins.
On the whole Disaster Recovery isn't an issue - we all have the multi-tier, multi-layed system covered with the DB, AppServer, WebServer, File system, OS covered.
Its the incremental one file, one widget, a wiki page which seems to be the biggest headache - heaven forbid you remove a whole community as that is a whole lot of hurt that you don't want to visit.
The single applications that sit outside connections are pretty hard to restore bits of as it is .. there is the DB to consider - tables for the actual application, things stored in the file system, dependancies, triggers or key to other DB's - which makes it pretty tough to work out exactly what you would need to restore at any given point in time - chances are something is going to be lost in a restore.
Communities brings a whole new level of complexity to the party - as well as the community application there are the 6 or so widgets to add as well leading to some very complex relationships between the DB tables in ways that will make your brain dribble out of your ears, as well as complex relationships to the file system. I personally haven't found any decent documentation on restoring sections of a community or a whole community.
The fact that connections relies so heavily on the database and it's ties to the file system I am really surprised that at least the DB relationships aren't documented.
After working with WebSphere Commerce (on as/400, iSeries) in my previous employer (IBM Premier Business Partner) we had much the same issues. WebSphere Commerce is the only other IBM product that I have come across in my 10 years of being involved with this stuff, which has such a heavy dependancy on it's DB relationships.
We spent about 5 years working with IBM to make the documentation better and assisting with beta programs, testing next versions of WCS and giving IBM all the feedback possible to help with making the product and documentation as great as possible.
One of the best things about the commerce documentation was the reference section - particularly the Database reference section. Each table listed with a description of the table and information on each field there is also index and constraint information and information on which tables and constraints reference the table you are looking at (see images at the end of the post)
By all means just having information about the DB is not going to be enough, but it is a start. Connections is such a complicated piece of software - and as it improves and is easier to customise - it's going to get more complicated. BUT Connections is sold as an enterprise ready application and for it to be totally successful it needs to have enterprise ready documentation on administering the back up and recovery of features and individual files, folders and pages.
Whether this is handled by "soft delete", admin commands, or a 3rd party application - it needs to be looked at as a matter of urgency.
In the end to allow the user to get access to the information deleted it was easier to restore the entire DB to new DB instance, build a stand-alone Connections server to point to the DB, do a small amount of DB manipulating and the user copied the forum questions and responses off in PDF format and has since uploaded them back to the files sections of their community. All in all that took approximately 2 days - just to retrieve 28 pages of information - a pain, a lot of hassle, but that appeared to be the fastest way at the time.
I would be more than happy to discuss my experiences with attempting to restore, and experiences around similar issues seen in Commerce if it will help in anyway. I am sure there are other members of the Connections community that would be happy to assist too. Connections is a fantastic product, lets make it better but helping us poor admins out :)
Issues with Install manager GUI on RHEL 6.3 ?
Wed, Apr 3rd 2013 6:12a Sharon Bellamy If you are attempting to install Connecitons 4.5 on RHEL 6.3 you will have noticed that there is an issue with using the GUI for the IBM Installation Manager with Red Hat Enterprise Linux 6.3
The IM won’t fire up a GUI even though xterm works for other GUI’s on the machine, no errors, no splash screen, no nothing !!
It has been driving both Stuart and I bonkers .. after a lot of digging here is what you need to get it to work :
yum install gtk2.i686 gtk2-engines.i686 PackageKit-gtk-m [read] Keywords: ibm
enterprise
linux
red hat
167
Sorry for the radio silence ….
Wed, Apr 3rd 2013 6:12a Sharon Bellamy I want to apologise for my lack of blogging and tweeting – there has been a lot of ups and downs in my personal life over the last 10 months, serious injury which is still not totally resolved and a bunch of other things that have contributed to not only my lack of blogging – but has stopped me attending and speaking at LUGs.
I would like to think that I may be over the worst of it – I had a fantastic holiday with my daughter Emily in Feb 2013 to Disney World, I am working with [read] Keywords: connections
domino
notes
sametime
blogging
232
Social Connections V – coming soon
Tue, Feb 5th 2013 8:09p Sharon Bellamy The international and independent IBM Connections user group will be visiting beautiful Zurich, Switzerland on June 28th 2013!
IBM Switzerland has graciously offered us the use of their IBM Client Center and it already promises to be a busy day
To register for this event please visit our registration page here, or use the button below: [read] Keywords: connections
ibm
424
Social Connections IV fun in Amsterdam
Wed, Dec 12th 2012 11:15a Sharon Bellamy After months of planning, much panicking by certain members of the SOCCNX team and a small amount of winging it – the 4th Social Connections User Group for IBM Connections Users hit Amsterdam on the 30th of November 2012.
Considering this user group was an idea that Stuart and I had over a coffee in the Uni cafe a couple of years ago, we have gone from 60 attendees at Social Connections I to a massive 203 attendees from 16 countries representing 99 unique organisations at Social Connection [read] Keywords: connections
ibm
lotusphere
community
facebook
linkedin
twitter
389
Mastering metrics and coping with cognos
Wed, Dec 12th 2012 11:15a Sharon Bellamy Here are the slides from out Cognos session from social connections iv – given with the mighty Greg Kutinov
Mastering metrics and coping with cognos from Sharon Bellamy [read] Keywords: connections
207
I’m back .. it’s been a while
Tue, Sep 25th 2012 6:08a Sharon Bellamy Many of you may have noticed that I have been AWOL for a while.
I had much going on in my personal life and I would publicly like to thank my close friends for assisting me through that difficult time.
I am now back .. with a vengeance.
Since mid June 2012 :
I have lost over 36lb in weight – and I feel like a new person
Presented at UKLUG with a trapped nerve in my back – thanks to Bill Mal, Steve Mc D, Wild Bill especially for being so fantastic.
Changed jobs – I am now very [read] Keywords: collaboration
connections
lotusphere
251
Social Connections III – 3 weeks to go
Fri, Jun 1st 2012 10:11a Sharon Bellamy Only a few weeks until the 3rd Social Connections user group, held in the IBM Labs Dublin.
We have a few places left if you are interested in attending this unique user group. We have some fantastic sessions such as:
What’s New in Connections 4?
What Do I Need To Know? Designing A Training Plan For IBM Connections
Using Social Controls in XPages
Connections Administration: Understand the challenge … and find your way how to do it
Using Social for social good – the case for Soc [read] Keywords: admin
administration
connections
ibm
xpages community
201
Customizing Connections Demo Files
Wed, May 23rd 2012 9:12a Sharon Bellamy The demo files that acompany my Customizating Connections Presentation can now be downloaded here
Inside the zip file you will find :
The templates and css files from customizationcommonnav
The custom community thumbnail image from customizationcommunitiesimages
The custom strings required for the twitter profile extention from customizationstrings
The JustNudge profile twitter ear file – LCC_Twitter_EAR-latest.ear
Instructions on how to deploy this and how to extend the profile R [read] Keywords: connections
ibm
community
css
profile
twitter
widget
widgets
xml
249
Customizing IBM Connections – as seen at #NLLUG #socbiz2012
Wed, May 16th 2012 8:12a Sharon Bellamy Yes you can stuff a 2 hour technical jump start into an hour .. and get good feedback ..
Connections customization lite
View more presentations from Sharon Bellamy
I will also share the css and demo files when I get back home .. message me if you are interested.
Next outing for this #soccnx in June [read] Keywords: connections
ibm
css
257
Returning user login issues – fun with the connections databases
Mon, May 14th 2012 7:12a Sharon Bellamy I recently had an issue with a user having issues logging in to certain applications.
The user could log in to some apps but recieved an error on others – for instance profiles, activities, communities and forums the user was fine.
Each applications database holds information regarding the user login and their external / directory / guid id – this guid is unique to the user – I found after extensive investigation that this user had orphaned entries in the other application DB t [read] Keywords: connections
dogear
application
applications
database
sql
