Install Ubuntu - Invalid login

[Glen Bal]

Hi All,

I just installed PURLZ-Server-1.6.4 on a Ubuntu server (no GUI).

sudo java -jar PURLZ-Server-1.6.3.jar /path/to/purlz-install.xml

When I run it with start.sh it runs like expected, but when i run it as a service:

sudo adduser dexter
sudo cp /path/to/PURLZ-Server-1.6.3/bin/netkernel /etc/init.d/
sudo update-rc.d netkernel defaults
sudo service netkernel start
Then I am unable to login with the default admin, it seems like the hsqldb does not start.
Invalid login. Either the user id or password were incorrect.
Thanks for you help,
Glen

[David Wood]

Hi Glen,

I’m sorry to say that I have no idea, based on this information…

You might try it with MySQL to see whether that addresses your issue (it should). If you specifically want to use hsqldb, then you might check /var/log/messages and the /path/to/PURLZ-Server-1.6.3/log to look for error messages.

Regards,
Dave
--

http://about.me/david_wood

--
You received this message because you are subscribed to the Google Groups "persistenturls" group.
To unsubscribe from this group and stop receiving emails from it, send an email to persistenturl...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Glen Bal]

I looked into the log file and found the problem, but not yet the solution.

<id>java.sql.SQLException</id>

<message>The database is already in use by another process: org.hsqldb.persist.NIOLockFile@a0ccd605[file =/purl.lck, exists=false, locked=false, valid=false, fl =null]: java.io.FileNotFoundException: /purl.lck (Permission denied)</message>

<stack>

<level>org.hsqldb.jdbc.Util.sqlException()</level>

<level>org.hsqldb.jdbc.jdbcConnection.&lt;init&gt;()</level>

<level>org.hsqldb.jdbcDriver.getConnection()</level>

<level>org.hsqldb.jdbcDriver.connect()</level>

</stack>

The problem is that it has no permission to write to the root of the server. Can I change the location for the .lck somehow or turn this off?

Regards,

Glen

[David Wood]

Hi Glen,

Um, are you running the service from the root directory? I have never seen this before…

What is your PATH?

Regards,
Dave
--

http://about.me/david_wood

[Glen Bal]

Hi Dave,

My installpath is /opt/purl/ and is added to the PATH variable.

But now I tried to install it with MySQL and this also gives me errors.

I've attached net kernel.out. Do you see what i'm missing from your experience?

Thanks in advance.

Glen

 

[David Wood]

Hi Glenn,

Sorry for the late response.  Your log file shows this message:

[[

<message>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=innodb' at line 11</message>

]]

…which suggests that the MySQL instance you are using is not using a database type of innodb. You can change that in your MySQL configuration.

It is difficult to figure out what is really happening in your environment, though, because there are so many ways to set up Unix-like systems. 

As for your troubles using hsqldb, I looked back at your error message that read:

[[

java.io.FileNotFoundException: /purl.lck (Permission denied)

]]

Did you happen to check to see if that file was actually present, and what permissions it had?

I have checked a couple of Linux machines running the current version of PURLZ, and I don’t see either of these problems. I suppose you might run into problems with a version of Java more recent than 1.6. Can you check your Java version (by running ‘java -version’) and let me know what you see?

Regards,
Dave
--

http://about.me/david_wood

--
You received this message because you are subscribed to the Google Groups "persistenturls" group.
To unsubscribe from this group and stop receiving emails from it, send an email to persistenturl...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<netkernel.out>

[Glen Bal]

Hi Dave,

Thanks for your reply.

For MYSQL I changed the default engine to InnoDB. When I looked into database 'purls' no tables where created yet. I tested the installation by creating a table, when I checked the type for the table it was set to InnoDB. With this all set I restarted all services, but I still get the same error in the log.

As for the hsqldb i checked and the file was not present and i got the error. The next thing I did was manually creating this file on the root and i set the permissions of the file to 777. But then the error change to 'the file is in use by another process'.

ubuntu-version: 14.04.1

Java version: 1.7.0_75

Regards,

Glen

[Glen Bal]

Hi Dave,

I solved the problem for mysql. From mysql 5.1 type=innodb is no longer available and is changed into engine=innodb.

I change the file modules\mod-purl-storage\db\mysql\createDB.idoc (changed file attached) and after the restart of netkernel all works fine.

But it gave me a null pointer exception for another sql-statement. Strangely i only found a problem for hsqldb in the file modules\mod-purl-storage\db\hsqldb\solr-data-config.xml. (changed file also attached)

All the quotes are in the wrong position:

select &quot;z_id&quot; as z_id from users where &quot;lastmodified&quot; &gt;= '${dataimporter.last_index_time}'

only returns a 'z_id' and not an id, so i changed all strange 

select z_id as &quot;z_id&quot; from users where &quot;lastmodified&quot; &gt;= '${dataimporter.last_index_time}'

So I checked all the sql-statements with quotes and came up with the file attached.

I hope this can help someone else sometime.

Thanks for your time, Dave!

Kind regards,

Glen

[David Wood]

Hi Glen,

Good work. Thank you very much.

I’m not sure what we should do about this. The PURLz codebase will be officially migrating to Callimachus [1] following the Callimachus 1.5 release, which is expected in May. However, I’m tempted to release a new version of the old code base to address these issues for modern versions of hsqldb and mysql.

I’ll look into that shortly. Thanks again.

Regards,
Dave
--

http://about.me/david_wood

--
You received this message because you are subscribed to the Google Groups "persistenturls" group.
To unsubscribe from this group and stop receiving emails from it, send an email to persistenturl...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<createDB.idoc><solr-data-config.xml>