[Webcom] Service Provider Fix/Upgrade

Ian Edwards iedwards.pub at gmail.com
Wed Jul 31 01:06:06 PDT 2013 

Frank's made a patch using old code from the database and updated
#1105<http://trac.osgeo.org/osgeo/ticket/1105>.
He says first signs look good. Well done Frank!

I'm not able to test or review at the moment, can some one else take a
quick look?

- Frank, could you send a quick note on how you think the backup is/isn't
working - do you think the SQL dump you're looking at was made manually or
ran from cron?
- Adam, you were right that we should really be using views to do this in
the long term. I need to read through our WebCom
pages<http://wiki.osgeo.org/wiki/Website_Committee> and
old minutes, and also get more familiar with the workings of the server,
but perhaps around FOSS4G we need to be think about our roadmap?



On Wed, Jul 31, 2013 at 4:52 AM, Frank Warmerdam <warmerdam at pobox.com>wrote:

> Ian,
>
> Sweet, it seems to have worked!  I had to do a bunch of work unescaping
> and otherwise fixing up the php code from the sql insert statement, but it
> seems to work reasonably well now.
>
> Best regards,
> Frank
>
>
> On Tue, Jul 30, 2013 at 2:52 PM, Ian Edwards <iedwards.pub at gmail.com>wrote:
>
>> Good work. To start with I'd be tempted just to paste it into a new node
>> making sure the filter is set to PHP mode and setting the node's url to
>> edit_profile<http://www.osgeo.org/edit_profile?UID=150&SET=1&MUL_COUNTRY%5B%5D=00048&MUL_TECH%5B%5D=00016>.
>> That may be enough to get it working without have to edit the live
>> database.
>>
>>
>> On Tue, Jul 30, 2013 at 10:40 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:
>>
>>> Folks,
>>>
>>> Good news!  Digging around in that backup I found the contents of
>>> node/326.  I'll try to figure out how to reincorporate it tonight.
>>>
>>> Best regards,
>>> Frank
>>>
>>>
>>>
>>> On Tue, Jul 30, 2013 at 1:49 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:
>>>
>>>> Ian,
>>>>
>>>> Sorry, I'm not sure.   I don't see any of the old backup stuff I
>>>> vaguely recall from years ago when I tried to be involved in osgeo1 backups
>>>> now in /root or root's "crontab -l" output.
>>>>
>>>> I do see a backup in /root/MySQL-Dumps/ that might be helpful.  It is
>>>> from Jan 5, 2013.  I'm guessing this was before the last attempt at a
>>>> drupal migration?
>>>>
>>>> Hmm, I'm going to dig around a bit in that and see if I can find
>>>> something helpful.
>>>>
>>>> Best regards,
>>>> Frank
>>>>
>>>>
>>>>
>>>> On Tue, Jul 30, 2013 at 1:29 PM, Ian Edwards <iedwards.pub at gmail.com>wrote:
>>>>
>>>>> Okay - I've read the ticket now. I did see this go past a few weeks
>>>>> ago (but back then it was someone else's problem!)
>>>>>
>>>>> Frank - do we have database backups anywhere? - it's real easy to pull
>>>>> the missing code from the backup. We need a backup from before
>>>>> 2013-01-21...
>>>>>
>>>>>
>>>>> On Tue, Jul 30, 2013 at 9:11 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:
>>>>>
>>>>>> For the sake of completeness, I'm copying this reply from Ian here:
>>>>>>
>>>>>> """
>>>>>>
>>>>>> Hi Adam,
>>>>>>
>>>>>> If we throw away what we currently have and start from scratch then I agree
>>>>>> that views would be the obvious way to go.
>>>>>>
>>>>>> As far as I can see, your suggestion doesn't allow an institution to log in
>>>>>> and edit their own profile - instead someone with the correct role can edit
>>>>>> all 'service provider' nodes?
>>>>>>
>>>>>> Is your plan for migrating the exiting profile information to cut and
>>>>>> paste?  We'd then remove the old pages and allow external search engines to
>>>>>> reindex?
>>>>>>
>>>>>> The new guidelines would be to contact WebCom to get pages added or updated?
>>>>>>
>>>>>> I haven't had a proper look, but the custom PHP code does not look that
>>>>>> complicated - but it's proper legacy code and presumably would require live
>>>>>> editing and testing to fix.  I also don't currently understand our LDAP
>>>>>> integration.  I'm happy to test and document what we currently have and
>>>>>> suggest a fix. It's obvious that we'll need to replace this at some stage
>>>>>> in the future, but that probably applies to many other areas of the site
>>>>>> and we'll want approach any redesign in a well thought our and consistent
>>>>>> way.
>>>>>>
>>>>>> Ian
>>>>>>
>>>>>> """
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jul 30, 2013 at 11:37 AM, Frank Warmerdam <
>>>>>> warmerdam at pobox.com> wrote:
>>>>>>
>>>>>>> Folks,
>>>>>>>
>>>>>>> I'm opening a new thread to discuss Adam Włodarkiewicz's suggested
>>>>>>> plan to fix the Service Provider Directory which is currently broken due to
>>>>>>> the mysterious loss of a page of PHP code, described in:
>>>>>>>
>>>>>>>   http://trac.osgeo.org/osgeo/ticket/1105
>>>>>>>
>>>>>>> Adam has suggested:
>>>>>>> """
>>>>>>> I propose introducing a 'service provider' content type. This would
>>>>>>> give it
>>>>>>> the advantage of customizable permissions and easy integration with
>>>>>>> views
>>>>>>> among other Drupal goodness. Permissions can be configured to give
>>>>>>> editing
>>>>>>> rights not just to osgeo.org maintainers, but any user with the
>>>>>>> correct
>>>>>>> role (again, configurable in Drupal). Such role can be given to
>>>>>>> users who
>>>>>>> are representatives of the service providers. Views module allows
>>>>>>> creation
>>>>>>> of different kinds of lists and displays of content. A list
>>>>>>> containing only
>>>>>>> the service provider content type would be trivial to create, much
>>>>>>> like
>>>>>>> creating filters to limit the list to only service provider from a
>>>>>>> given
>>>>>>> country, etc. Further more, this filter can be exposed to the user
>>>>>>> (for
>>>>>>> example as a select box) and ajax can be used to refresh the list.
>>>>>>> As far
>>>>>>> as I understand, this pretty much covers the current functionality
>>>>>>> and
>>>>>>> more, in addition to being drupalish. All of the above mentioned
>>>>>>> configuration can be done via clicking in the administration menu.
>>>>>>>
>>>>>>> Importing existing entries can be easily done via a proper import
>>>>>>> module,
>>>>>>> assuming it would not be too difficult to export the current data
>>>>>>> in, for
>>>>>>> example, csv format.
>>>>>>> """
>>>>>>>
>>>>>>> I'm slightly concerned that the filtering may be more clumsy than the
>>>>>>> service provider directory.  Adam, can you point me at something
>>>>>>> similar
>>>>>>> done with Drupal so I have a sense of what it might look like and
>>>>>>> interact
>>>>>>> like?
>>>>>>>
>>>>>>> I will note that the existing service provider directory is in a
>>>>>>> mysql table
>>>>>>> - the same one as the drupal content.
>>>>>>>
>>>>>>> Ian has also expressed interest in helping with this issue - Ian, do
>>>>>>> you
>>>>>>> have thoughts on this approach?
>>>>>>>
>>>>>>> Personally, it sounds pretty good to me.  I'm wondering if it is
>>>>>>> something
>>>>>>> we could start prototyping on Drupal now and just not link to it
>>>>>>> from
>>>>>>> anywhere prominent on the web site.  If there are no immediate
>>>>>>> concerns
>>>>>>> I would be interesting in starting an experiment on this new content
>>>>>>> type
>>>>>>> and filtering interaction and could arrange appropriate access for
>>>>>>> Adam.
>>>>>>> Perhaps a motion covering the experiment would be appropriate to
>>>>>>> gauge support.  I'd also include adding Adam to Webcom.
>>>>>>>
>>>>>>> Best regards,
>>>>>>> --
>>>>>>>
>>>>>>> ---------------------------------------+--------------------------------------
>>>>>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>>>>>> warmerdam at pobox.com
>>>>>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>>>>>> and watch the world go round - Rush    | Geospatial Software
>>>>>>> Developer
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> ---------------------------------------+--------------------------------------
>>>>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>>>>> warmerdam at pobox.com
>>>>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>>>>> and watch the world go round - Rush    | Geospatial Software Developer
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> ---------------------------------------+--------------------------------------
>>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>>> warmerdam at pobox.com
>>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>>> and watch the world go round - Rush    | Geospatial Software Developer
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> ---------------------------------------+--------------------------------------
>>> I set the clouds in motion - turn up   | Frank Warmerdam,
>>> warmerdam at pobox.com
>>> light and sound - activate the windows | http://pobox.com/~warmerdam
>>> and watch the world go round - Rush    | Geospatial Software Developer
>>>
>>
>>
>
>
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Software Developer
>

More information about the Webcom mailing list