Re: [Geoserver-users] SQL Server Store

[Matt Barclay]

Hi Peter,

I just started using SQL Server with GeoServer (2.15.0).  What worked for
me was grabbing the latest MS JDBC driver:

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

Make sure that goes in your webapps/geoserver/WEB-INF/lib directory along
side the gt-jdbc-sqlserver extension.  After a restart, you should see SQL
Server on the "Add new Store" page.

But also check your console log to see if there are any exceptions being
thrown due to missing libraries.  I hit more than a few issues where the MS
JDBC driver wanted some other library installed.

Regards,
Matt


On Thu, Apr 25, 2019 at 1:35 PM Parker, Peter R (OIT) <
peter.par...@alaska.gov> wrote:

> Using GeoServer 2.14.3 running on RedHat Linux. Installed the appropriate
> SQL Server Drivers (sqljdbc42.jar and gt-jdbc-sqlserver-20.3.jar ) but when
> I go to the Stores Admin in the UI I do not see an option for MS SQL
> Server.
>
> I use Oracle as well and  with those driver installed, I see the Vector
> Datasource for Oracle in the Stores – New data source page.
>
> Any ideas why I am not seeing the SQL Server option? Thank you!  Peter
> ___
> 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
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Azure SQL Server Datastore with Active Directory Password Authentication

[Matt Barclay]

Thanks, Andrea.  I'll take this to the geotools-devel list to work on
implementation.

Regards,
Matt

[image: photo]
*Matt Barclay*
Senior Software Engineer
206.250.8960  | growers.ag



On Thu, Apr 11, 2019 at 1:34 AM Andrea Aime 
wrote:

> On Thu, Apr 11, 2019 at 2:22 AM Matt Barclay  wrote:
>
>> In Python-land, the connection string looks like this:
>>
>> Driver={ODBC Driver 17 for SQL
>> Server};Encrypt=yes;TrustServerCertificate=no;ConnectionTimeout=5;
>> *Authentication=ActiveDirectoryPassword*;Server=
>> mydomain-test.database.windows.net;Database=my_database_test;Uid=
>> my-readonly-acco...@mydomain.net;Pwd=XxXxXxX;
>>
>> Is there any way to enable ActiveDirectoryPassword authentication in
>> GeoServer?
>>
>
> Assuming that the JDBC driver can do something similar (you'll have to
> check) it should be possible to get where you want by changing this class:
>
> https://github.com/geotools/geotools/blob/a6d090792de9ff1f77eb4714692c6752338a77b6/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDataStoreFactory.java#L32
>
> If you modify it and the change is of general utility, pull requests are
> welcomed, see here:
> https://github.com/geotools/geotools/blob/master/CONTRIBUTING.md
>
> Cheers
> Andrea
>
> ==
>
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf
> Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa
> (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549
> http://www.geo-solutions.it http://twitter.com/geosolutions_it
> --- *Con riferimento
> alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 -
> Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni
> circostanza inerente alla presente email (il suo contenuto, gli eventuali
> allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i
> destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per
> errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le
> sarei comunque grato se potesse darmene notizia. This email is intended
> only for the person or entity to which it is addressed and may contain
> information that is privileged, confidential or otherwise protected from
> disclosure. We remind that - as provided by European Regulation 2016/679
> “GDPR” - copying, dissemination or use of this e-mail or the information
> herein by anyone other than the intended recipient is prohibited. If you
> have received this email by mistake, please notify us immediately by
> telephone or e-mail.*
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Azure SQL Server Datastore with Active Directory Password Authentication

[Matt Barclay]

Hello,

I am trying to configure GeoServer 2.15.0 to talk to our Azure SQL Server
instance using ActiveDirectoryPassword authentication.  I have installed
the Microsoft SQLJDBC 7.2.1.0 driver, and I can see "Microsoft SQL Server"
as an option in the datastore configuration page.  However, when I
configure my server, I get the following error:

java.lang.RuntimeException: Unable to obtain connection: Cannot create
PoolableConnectionFactory (*Cannot open server "mydomain.net
"* requested by the login.  The login failed.

My configuration looks like:

Host:  mydomain-test.database.windows.net
Port:  1433
Database:  my_database_test
Schema:  dbo
User:  my-readonly-acco...@mydomain.net
Passwd:  XxXxXxX


In Python-land, the connection string looks like this:

Driver={ODBC Driver 17 for SQL
Server};Encrypt=yes;TrustServerCertificate=no;ConnectionTimeout=5;
*Authentication=ActiveDirectoryPassword*;Server=
mydomain-test.database.windows.net;Database=my_database_test;Uid=
my-readonly-acco...@mydomain.net;Pwd=XxXxXxX;

Is there any way to enable ActiveDirectoryPassword authentication in
GeoServer?

Thanks,

Matt
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users