This is somewhere in WEB-IN/web.xml I presume?
Kind regards,
Steve Omondi
On Fri, Nov 24, 2017 at 1:09 PM, Niels Charlier <ni...@scitus.be> wrote:
> Hi Steve,
>
> You need to add a
>
> <context:component-scan base-package="package.of.the.class" />
>
> to the spring context for it to work.
>
> Regards
> Niels
>
>
> On 24-11-17 09:20, Steve Omondi wrote:
>
> So I temporarily removed security for the /rest/* chain in Authentication
> and using http://host:port/geoserver/rest/jdbcexport just returns the
> default geoserver/rest result.
>
> Any pointers are welcome.
>
> Kind regards,
> Steve Omondi
>
> On Fri, Nov 24, 2017 at 10:51 AM, Steve Omondi <steve.omo...@ramani.co.ke>
> wrote:
>
>> Hi Niels,
>>
>> So I was trying out the Java class you shared. Here is what I did;
>> -> copied theJDBCexport into geoserver/WEB-INF/classes/
>> -> restarted the Tomcat
>> -> Tried to invoke the class on the browser with the following URLs;
>>
>> http://host:port/geoserver/jdbcexport resulted into 404 Not Resource not
>> found
>> http://host:port/geoserver/rest/jdbcexport resulted into 403 Error
>> (Forbidden) Note that I'm logged into Geoserver as Admin
>>
>> Is this the correct procedure I should use with this class?
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>> Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>
>> Kind regards,
>> Steve Omondi
>>
>> On Wed, Nov 15, 2017 at 5:02 PM, Niels Charlier <ni...@scitus.be> wrote:
>>
>>> Steve,
>>>
>>> Sorry for the confusion. This was not in response to you, but Andrea
>>> about dropping the module from geoserver altogether. I understand your
>>> decision because I have also found that jdbcconfig is a problematic bottle
>>> neck (but as I mentioned, mostly because of the poor cache support and the
>>> unnecessarily repetitive queries).
>>>
>>> In the attachment you can find the code for exporting jdbc to hard
>>> drive. The file needs to be temporarily added to the class path and scanned
>>> by the spring appcontext, then when you are logged in as an admin you can
>>> call /jdbcexport from the browser to force the caching of the catalog. I
>>> hope you can use this somehow.
>>>
>>> Kind Regards
>>> Niels
>>>
>>>
>>> On 15-11-17 12:51, Steve Omondi wrote:
>>>
>>> Oh really, drop it? I thought jdbcconfig was the recommended way for
>>> clustering and is particularly useful when you are working with huge
>>> catalogs. I assumed it was actually being used in production by people.
>>>
>>> Our intention is not to drop it entirely. But to run more or less a
>>> catalog that is based on XML for some specific workspaces that we really
>>> need to be performant urgently.
>>>
>>>
>>> While we have found jdbcconfig to be an excellent solution for
>>> clustering, it
>>> also
>>>
>>> has made *3 Load balanced Geoserver 2.11.2 to be 6 times slower than 1
>>> Geoserver 2.9* all other configurations kept constant.
>>> And this is an issue that we can't ignore in PROD for our case.
>>>
>>> We intent to move a few of the workspaces and layers especially complex
>>> LayerGoups fron the JDBC catalog to achieve better performance over
>>> convenience of the DB Catalog.
>>>
>>> *Otherwise, JDBCConfig is an excellent module in use*.
>>>
>>>
>>>
>>>
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>> Virus-free.
>>> www.avast.com
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>
>>> Kind regards,
>>> Steve Omondi
>>>
>>> On Wed, Nov 15, 2017 at 1:30 PM, Niels Charlier <ni...@scitus.be> wrote:
>>>
>>>> Oh really, drop it? I thought jdbcconfig was the recommended way for
>>>> clustering and is particularly useful when you are working with huge
>>>> catalogs. I assumed it was actually being used in production by people.
>>>>
>>>> The main problem seems to be the performance issues though, as this
>>>> email also proves, as well as both of the two PR's that are open who are
>>>> related to the same thing. But I believe this is rather solvable and would
>>>> make a huge difference.
>>>>
>>>> I can review these PRs no problem, since they are actually related to
>>>> the work I am doing for this module.
>>>>
>>>> Perhaps these improvements there can blow some new life into it.
>>>>
>>>> Regards
>>>>
>>>> Niels
>>>>
>>>> On 14-11-17 20:10, Andrea Aime wrote:
>>>>
>>>> Hi Niels,
>>>> today during the PSC meeting the topic came out of whether we should
>>>> just drop
>>>> JDBCConfig, since:
>>>>
>>>> - mails related to it are not really getting answered
>>>> - pull requests related to it are sitting there not getting reviewed
>>>>
>>>> We still have to see if there is some interested, but we need someone
>>>> to champion the module
>>>> just enough to make it worth keeping around (I'm not talking about
>>>> immediate answers, it's
>>>> a community/unsupported module, but at least some presence).
>>>> I'm also going to ping the people making pull requests.
>>>>
>>>> Cheers
>>>> Andrea
>>>>
>>>>
>>>> On Tue, Nov 14, 2017 at 5:24 PM, Niels Charlier <ni...@scitus.be>
>>>> wrote:
>>>>
>>>>> Hello Steve,
>>>>>
>>>>> First I'd like to say I have been doing some work on considerable
>>>>> performance improvements for jdbcconfig. It happens to be the case that
>>>>> jdbcconfig doesn't take good use of its cache and repeatedly sends the
>>>>> same
>>>>> queries over and over again. It looks promising but I still need to do
>>>>> some
>>>>> improvements and write some tests and I had other work coming on top of
>>>>> it.
>>>>> But this is definitely coming.
>>>>>
>>>>> Also, I wrote some code in geoserver for myself to conveniently export
>>>>> the jdbc catalog back to the file system. I found a way to do this easily
>>>>> by firing a bunch of catalog change events to the file system catalog.
>>>>> However, I am not sure to make it easily available to end users at this
>>>>> point, I assume that just giving you the code won't be very helpful for
>>>>> you. Perhaps we can work something out if you are interested.
>>>>>
>>>>> Regards
>>>>>
>>>>> Niels
>>>>>
>>>>>
>>>>>
>>>>> On 09-11-17 11:02, Steve Omondi wrote:
>>>>>
>>>>> Hi guys,
>>>>>
>>>>> I have *JDBCConfig* enabled and connected to a Postgres DB. I have
>>>>> over 500 layers spread across different workspaces and layergroups.
>>>>>
>>>>> After running performance tests for GetMap requests against this
>>>>> configuration versus XML Catalog based geoserver I really need to revert
>>>>> my
>>>>> catalog back to XML in GEOSERVER DAT DIR and probably share it using NFS.
>>>>>
>>>>> *Is their a method to export the Database Catalog (based on
>>>>> JDBCConfig) back to XML Catalog?*
>>>>>
>>>>> Kind regards,
>>>>> Steve Omondi
>>>>>
>>>>>
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>>> Virus-free.
>>>>> www.avast.com
>>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Check out the vibrant tech community on one of the world's most
>>>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>>>>
>>>>> _______________________________________________
>>>>> Geoserver-users mailing list
>>>>>
>>>>> Please make sure you read the following two resources before posting to
>>>>> this list:
>>>>> - Earning your support instead of buying it, but Ian Turton:
>>>>> http://www.ianturton.com/talks/foss4g.html#/
>>>>> - The GeoServer user list posting guidelines:
>>>>> http://geoserver.org/comm/userlist-guidelines.html
>>>>> Geoserver-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Check out the vibrant tech community on one of the world's most engaging
>>>>> tech sites, Slashdot.org! http://sdm.link/slashdot
>>>>> _______________________________________________ Geoserver-users
>>>>> mailing list Please make sure you read the following two resources before
>>>>> posting to this list: - Earning your support instead of buying it, but Ian
>>>>> Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer
>>>>> user list posting guidelines: http://geoserver.org/comm/user
>>>>> list-guidelines.html Geoserver-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>>
>>>> --
>>>>
>>>> Regards,
>>>>
>>>> Andrea Aime
>>>>
>>>> == GeoServer Professional Services from the experts! Visit
>>>> http://goo.gl/it488V for more information. == Ing. Andrea Aime
>>>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>>>> @geowolf
>>>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa+%3Chttps://maps.google.com/?q%3DVia%2Bdi%2BMontramito%2B3/A%2B55054%2B%25C2%25A0Massarosa%26entry%3Dgmail%26source%3Dg%3E&entry=gmail&source=g>Technical
>>>> Lead GeoSolutions S.A.S. Via di Montramito 3/A
>>>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>>>> 55054
>>>> Massarosa
>>>> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
>>>> (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
>>>> http://www.geo-solutions.it http://twitter.com/geosolutions_it
>>>>
>>>> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
>>>>
>>>> Le informazioni contenute in questo messaggio di posta elettronica e/o
>>>> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
>>>> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
>>>> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
>>>> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
>>>> darcene notizia via e-mail e di procedere alla distruzione del messaggio
>>>> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
>>>> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
>>>> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
>>>> principi dettati dal D.Lgs. 196/2003.
>>>>
>>>> The information in this message and/or attachments, is intended solely
>>>> for the attention and use of the named addressee(s) and may be confidential
>>>> or proprietary in nature or covered by the provisions of privacy act
>>>> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
>>>> Code).Any use not in accord with its purpose, any disclosure, reproduction,
>>>> copying, distribution, or either dissemination, either whole or partial, is
>>>> strictly forbidden except previous formal approval of the named
>>>> addressee(s). If you are not the intended recipient, please contact
>>>> immediately the sender by telephone, fax or e-mail and delete the
>>>> information in this message that has been received in error. The sender
>>>> does not give any warranty or accept liability as the content, accuracy or
>>>> completeness of sent messages and accepts no responsibility for changes
>>>> made after they were sent or for other risks which arise as a result of
>>>> e-mail transmission, viruses, etc.
>>>>
>>>>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
