PURLZ-Server-1.6.4 does not work with MySQL

[GoogleCodeExporter]

What steps will reproduce the problem?
1. We installed mysql(Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) 
using readline 5.1).
2. We installed PURLZ-Server-1.6.4.
3. We started the netkernel.
4. We cannot login as admin with password 'password'. 

What is the expected output? What do you see instead?

  We got the failed message below. 
 'Invalid login. Either the user id or password were incorrect. '

What version of the product are you using? On what operating system?

 OS: CentOS 6.2
 PURLZ-Server-1.6.4
 mysql(Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1)

Please provide any additional information below.

  PURLZ-Server-1.6.4 works with HSQLDB, so we think PURL will not connect mysql well.

The result of the command is below.

[root@]# mysql -u purl -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| purls              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> use purls;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_purls   |
+-------------------+
| domainmaintainers |
| domains           |
| domainwriters     |
| groupmaintainers  |
| groupmembers      |
| groups            |
| users             |
+-------------------+
7 rows in set (0.00 sec)

mysql> describe users;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| z_id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| admin         | tinyint(1)       | YES  |     | NULL    |                |
| fullname      | varchar(100)     | YES  |     | NULL    |                |
| affiliation   | varchar(100)     | YES  |     | NULL    |                |
| email         | varchar(100)     | YES  |     | NULL    |                |
| userid        | varchar(32)      | YES  | UNI | NULL    |                |
| password      | varchar(100)     | YES  |     | NULL    |                |
| password_hint | varchar(100)     | YES  |     | NULL    |                |
| justification | varchar(300)     | YES  |     | NULL    |                |
| created       | datetime         | YES  |     | NULL    |                |
| lastmodified  | datetime         | YES  |     | NULL    |                |
| status        | smallint(6)      | YES  |     | NULL    |                |
| indexed       | tinyint(1)       | YES  | MUL | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> show grants for purl@localhost
    -> ;
+-------------------------------------------------------------------------------

                                 ------------------------------+
| Grants for purl@localhost                                                     

                                                               |
+-------------------------------------------------------------------------------

                                 ------------------------------+
| GRANT USAGE ON *.* TO 'purl'@'localhost' IDENTIFIED BY PASSWORD 
'*6005FB19F74A                                                                  
                                               7E053531EB077F580A2F6F43FA7C' |
| GRANT ALL PRIVILEGES ON `purls`.* TO 'purl'@'localhost'                       

                                                               |
+-------------------------------------------------------------------------------

                                 ------------------------------+
2 rows in set (0.00 sec)

mysql> select * from users;
Empty set (0.00 sec)

[root@]# ps -ef | grep java
root     18066 18065  0 15:17 pts/0    00:00:28 java -Xmx256m -Xms128m 
-Djava.endorsed.dirs=/usr/local/PURLZ-Server-1.6.4/lib/endorsed 
-Dbootloader.basepath=/usr/local/PURLZ-Server-1.6.4 
-Dbootloader.jarDir=/usr/local/PURLZ-Server-1.6.4/lib/ext 
-Dbootloader.nativeDir=/usr/local/PURLZ-Server-1.6.4/lib/native 
-Djava.protocol.handler.pkgs=com.ten60.netkernel 
-Dsun.net.client.defaultConnectTimeout=20000 
-Dsun.net.client.defaultReadTimeout=20000 -Djava.awt.headless=false 
-Dten60.pid=1 -cp 
/usr/local/PURLZ-Server-1.6.4/lib/1060netkernel-bootloader-1.1.2.jar 
com.ten60.netkernel.bootloader.BootLoader
root     29661 14150  0 17:09 pts/1    00:00:00 grep java
[root@]# ps -ef | grep mysql
root     17839     1  0 15:16 pts/1    00:00:00 /bin/sh /usr/bin/mysqld_safe 
--datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock 
--pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql    17947 17839  0 15:16 pts/1    00:00:01 /usr/libexec/mysqld 
--basedir=/usr --datadir=/var/lib/mysql --user=mysql 
--log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid 
--socket=/var/lib/mysql/mysql.sock

Original issue reported on code.google.com by sa...@biosciencedbc.jp on 3 Apr 2014 at 8:12

[GoogleCodeExporter]

Would you please tell me whether PURLZ-Server-1.6.4 needs higher version than 
mysql-5.1.73?

Original comment by sa...@biosciencedbc.jp on 7 Apr 2014 at 4:29

[GoogleCodeExporter]

PURLZ-Server-1.6.4 does work with MySQL 5.1 series, so this bug report is not 
valid.  However, something is going wrong with this user's configuration.

Please move discussion of deployment problems to the mailing list.  Thank you.

Original comment by piprotot...@gmail.com on 8 Apr 2014 at 12:10

• Changed state: Invalid

[GoogleCodeExporter]

Thank you for the reply.
Would you please tell me the address of the mailing list?

I cannot see the address from following URL.
http://purl.oclc.org/docs/faq.html#toc8.6

Best regards,

Original comment by sa...@biosciencedbc.jp on 15 Apr 2014 at 6:49

[GoogleCodeExporter]

Saito-san,

If you are looking for help with OCLC�s purl.org service, please go to:
  http://www.oclc.org/research/forms/feedback-form.html?urlm=163204

If you want to discuss the PURL software, then use:
  https://groups.google.com/forum/#!forum/persistenturls

Original comment by da...@3roundstones.com on 15 Apr 2014 at 12:23

[GoogleCodeExporter]

Our policy of the google group prevent me to send a new topic to following URL, 
so we send a message from :
 http://www.oclc.org/research/forms/feedback-form.html?urlm=163204

Thanks

Original comment by sa...@biosciencedbc.jp on 16 Apr 2014 at 6:08