Clément, the hsqldb script uses that URL to connect to the hsql instance but does not specify a listener configuration when launching the hsql server. Therefore the hsql server starts up and binds to the default port on every address available to the host including localhost. This makes the hsql instance available to a remote client. It's really weird that the hsqldb script connects perfectly but hsql shuts down when LSC attempts to connect.
-Jon C. Kidder American Electric Power Middleware Services Email: [email protected]<mailto:[email protected]> Phone: 614-716-4970 From: [email protected] [mailto:[email protected]] On Behalf Of Clément OUDOT Sent: Thursday, March 10, 2016 11:58 AM To: [email protected] Subject: Re: [lsc-users] problem with hsql and lsc on same host This is an EXTERNAL email. STOP. THINK before you CLICK links or OPEN attachments. ________________________________ Le 10/03/2016 17:40, Jon C Kidder a écrit : I'm trying to import a csv file into an OpenLDAP instance using LSC. I'm running into some rather strange behavior. When I run hsql and lsc on the same host the hsql instance shuts down without any explanation as soon as lsc attempts to connect to it. I can run the hsqldb -status, hsqldb -import, and hsqldb -show commands from the same host just fine without incident. I can connect to the hsql instance from a remote sql client without incident and lsc can connect to the hsql database as long as they aren't on the same host. I have a dedicated "sync" server and I would prefer for all of these processes to run on the same host. I can't spend a whole lot of time diagnosing this and may have to move forward with an alternative or workaround. Has anyone else encountered this? Any thoughts on what might be happening or how to quickly troubleshoot this? Hi John, when you use the hsqlb utility provided by LSC (http://lsc-project.org/wiki/documentation/howto/hsqldb), the database is run on localhost (jdbc:hsqldb:hsql://localhost/lscdb). So I don't understand how you manage to connect to the base from another host. You are maybe using an HSQLDB instance outside LSC? -- Clément OUDOT Consultant en logiciels libres, Expert infrastructure et sécurité Savoir-faire Linux
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
