debovis / webanno

Automatically exported from code.google.com/p/webanno
Apache License 2.0
0 stars 0 forks source link

no login window appears after update #6

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Follow the upgrade instructions (export existing projects, move /srv/webanno 
to safe location, re-create /srv/webanno with old settings files (I created a 
copy of the original webanno database, named it webanno2, and changed the name 
of the database in settings files), re-start webanno with new 2.0.12.war file, 
re-create users from mysql dump, re-start WebAnno service);
2. Try to connect to WebAnno Server;
3. No login window is shown -- neither in Mozilla nor in Chrome - the displayed 
page is completely blank, there is no HTML source code;

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

What version of the product are you using? On what operating system?
WebAnno: webanno-2.0.12.war
Apache Tomcat/6.0.35
JVM: 1.6.0_32-b32
OS: Linux hebe 3.2.0-57-generic #87-Ubuntu SMP Tue Nov 12 21:35:10 UTC 2013 
x86_64 x86_64 x86_64 GNU/Linux

Please provide any additional information below.

Contents of /opt/webanno/logs/catalina.out after second restart:
Nov 17, 2014 2:31:59 PM org.apache.catalina.startup.ClassLoaderFactory 
validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server/classes], exists: 
[false], isDirectory: [false], canRead: [false]
Nov 17, 2014 2:31:59 PM org.apache.catalina.startup.ClassLoaderFactory 
validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server], exists: [false], 
isDirectory: [false], canRead: [false]
Nov 17, 2014 2:31:59 PM org.apache.catalina.startup.ClassLoaderFactory 
validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared/classes], exists: 
[false], isDirectory: [false], canRead: [false]
Nov 17, 2014 2:31:59 PM org.apache.catalina.startup.ClassLoaderFactory 
validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared], exists: [false], 
isDirectory: [false], canRead: [false]
Nov 17, 2014 2:32:00 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-18080
Nov 17, 2014 2:32:00 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 576 ms
Nov 17, 2014 2:32:00 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Nov 17, 2014 2:32:00 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.35
Nov 17, 2014 2:32:00 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive webanno-2.0.12.war
2014-11-17 14:32:03 ERROR [main] (SchemaUpdate) - HHH000388: Unsuccessful: 
alter table authorities add index FK2B0F1321292E1AC9 (username), add constraint 
FK2B0F1321292E1AC9 foreign key (username) references users (username)
2014-11-17 14:32:03 ERROR [main] (SchemaUpdate) - Can't create table 
'webanno2.#sql-442_1af' (errno: 150)
2014-11-17 14:32:04  INFO [main] (StandaloneShutdownDialog) - Running in: tomcat
2014-11-17 14:32:04  INFO [main] (StandaloneShutdownDialog) - Console: not 
available
2014-11-17 14:32:04  INFO [main] (StandaloneShutdownDialog) - Headless: yes
2014-11-17 14:32:04  INFO [main] (StandaloneShutdownDialog) - Running in server 
environment or from command line: disabling interactive shutdown dialog.
Nov 17, 2014 2:32:05 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-18080
Nov 17, 2014 2:32:05 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 5383 ms

Original issue reported on code.google.com by wlsidore...@gmail.com on 17 Nov 2014 at 1:46

GoogleCodeExporter commented 9 years ago
What version did you upgrade from?

Original comment by richard.eckart on 17 Nov 2014 at 5:43

GoogleCodeExporter commented 9 years ago
version=0.4.0-rc3
groupId=de.tudarmstadt.ukp.clarin.webanno
artifactId=de.tudarmstadt.ukp.clarin.webanno.webapp

Original comment by wlsidore...@gmail.com on 17 Nov 2014 at 5:49

GoogleCodeExporter commented 9 years ago
Do you need database description or any additional logs?

Original comment by wlsidore...@gmail.com on 17 Nov 2014 at 5:51

GoogleCodeExporter commented 9 years ago
You copied the original database. That will not work. You need to start with a 
completely empty database and let WebAnno 2.0.12 recreate the schema from 
scratch.

Original comment by richard.eckart on 17 Nov 2014 at 5:51

GoogleCodeExporter commented 9 years ago
Now, I've DROP'ped the database webanno2, created an empty one, and re-launched 
the WebAnno service twice, but there is still no login window. Here are the 
contents of `webanno2`:
mysql> use webanno2
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_webanno2               |
+----------------------------------+
| annotation_document              |
| annotation_feature               |
| annotation_type                  |
| authorities                      |
| auto_stat                        |
| crowd_job                        |
| crowd_job_gold_document          |
| crowd_job_source_document        |
| mira_template                    |
| mira_template_annotation_feature |
| project                          |
| project_permissions              |
| source_document                  |
| tag                              |
| tag_set                          |
| users                            |
+----------------------------------+
16 rows in set (0.00 sec)

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

Here is /srv/webanno/settings.properties:
database.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/webanno2
database.username=webanno
database.password=....

format.properties is probably not needed.

Original comment by wlsidore...@gmail.com on 17 Nov 2014 at 6:40

GoogleCodeExporter commented 9 years ago
Can you please provide the log you get when starting Tomcat/WebAnno 2.0.12 now?

Are you sure you are entering the correct URL? E.g. if you deploy the WAR under 
the name "webanno.war" into the webapps folder, your URL would be something 
like "http://localhost:8080/webanno". If you use another name, e.g. 
"webanno-2.0.12.war" the URL changes accordingly 
("http://localhost:8080/webanno-2.0.12").

If you are running your Tomcat behind an Apache and you changed the name of the 
WAR, then make sure also to update your proxy configuration in Apache.

Original comment by richard.eckart on 17 Nov 2014 at 7:39

GoogleCodeExporter commented 9 years ago
Sorry, I did not know about the URI change. I tried it yesterday, and the web 
page simply hung, but I could not reproduce this behavior today. Now, the 
website seems to work. You can probably close the issue.

Original comment by wlsidore...@gmail.com on 18 Nov 2014 at 2:29

GoogleCodeExporter commented 9 years ago
Good to hear it works for you now.

Original comment by richard.eckart on 18 Nov 2014 at 3:32