Can't log in to DCM4CHEE Services

[Roger Lawyer]

I followed the installation instructions spelled out here:  http://www.marcilan.com/2012/11/installing-dcm4chee-2-7-2-with-mysql-and-weasis-web-viewer-under-windows-7/.  However I can't log on to http://localhost:8080/jmx-console, nor http://localhost:8080/dcm4chee-web3/. I'm using admin as the username and password.  I added a admin=admin line in every <xxx>-users.properties files and admin=JBossAdmin,HttpInvoker in every <xxx>-roles.properties file, restarted the Windows service and nothing.  Could I get assistance on other areas to check? 

[Alvaro G. [Andor]]

Can you see the login page then?

Can you attach a log?

90% times I cannot login in a new install, is due to incorrect database
connections. DCM4CHEE will deploy, but won't connect to database to
check users and passwords, so it'll tell you "wrong user or password".

Thanks

El 03/06/13 20:37, Roger Lawyer escribi�:

> nothing. Could I get assistance on other areas to check? --
> You received this message because you are subscribed to the Google
> Groups "dcm4che" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to dcm4che+u...@googlegroups.com.
> To post to this group, send email to dcm...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dcm4che?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Roger Lawyer]

Yes I see the login page for both.  Attached are screenshots of both.  What log would you like me to upload?

On Monday, June 3, 2013 2:42:02 PM UTC-4, andor wrote:

Can you see the login page then?

Can you attach a log?

90% times I cannot login in a new install, is due to incorrect database
connections. DCM4CHEE will deploy, but won't connect to database to
check users and passwords, so it'll tell you "wrong user or password".

Thanks

El 03/06/13 20:37, Roger Lawyer escribi�:

[fleetwoodfc]

The server.log file found in the ../server/default/log folder - however the incorrect database configuration/connection is most likely the problem.

[Roger Lawyer]

Thanks.  Attached is the log.  Instruct me on what to check for on the database configuration/connection.

[fleetwoodfc]

You haven't created the pacs database tables:

 Find failed: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'pacsdb.series' doesn't exist

[Roger Lawyer]

Ok.  when I bring up the mysql prompt and type show database I get:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| arrdb              |
| mysql              |
| pacsdb             |
| performance_schema |
| sakila             |
| test               |
| world              |
+--------------------+

 

 

Therefore I created the databases pacsdb and arrdb according to http://www.marcilan.com/2012/11/installing-dcm4chee-2-7-2-with-mysql-and-weasis-web-viewer-under-windows-7/ but there's no mention in these instructions of creating tables.  Is there a preset script that will do this? 

[Alvaro G. [Andor]]

You forgot the last line in point 6:

mysql -upacs -ppacs pacsdb < create.mysql

;) Let us know how it works.

Have a nice day!

El 04/06/13 20:26, Roger Lawyer escribió:

[David Davies]

http://www.dcm4che.org/confluence/display/ee2/MySQL

You received this message because you are subscribed to a topic in the Google Groups "dcm4che" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dcm4che/pEAw4dsBfro/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to dcm4che+u...@googlegroups.com.

[Roger Lawyer]

Ahh, I'm the resident expert on MS SQL server therefore I had to poke around the documentation of MYSQL  and through trial and error figure out the inconsistencies of the Marcilan instructions. Along the way I wound up skipping that last step in point 6.  Thanks for keeping me on track.