[Dart] admin login error [table USERS does not exist]

[David Blado]

Update: problem solved.

 

My issue was in realm.properties.  I had changed my dart directory form
dart1.0.7 to just 'dart'...the realm.properties was still looking for
the database in dart1.0.7.

 

Lesson learned.  Do not move dart directories around after the
server/project was created :-)

 

Cheers,

David

 

________________________________

From: dart-bounces+dblado=decarta.com at public.kitware.com
[mailto:dart-bounces+dblado=decarta.com at public.kitware.com] On Behalf Of
David Blado
Sent: Wednesday, January 09, 2008 1:38 PM
To: dart at public.kitware.com
Subject: [Dart] admin login error [table USERS does not exist]

 

Hi All,

 

I'm experimenting w/ Dart's ability to allow users to login.  I have in
the passed been able to login as the 'admin' user...but not anymore.

 

Here is my output from querying the server database directly ('deCarta'
is the name of my dart server on the filesystem):

 

-bash-3.00$ ./ij.ksh

ij version 10.1

ij> connect 'jdbc:derby:/home/dblado/dart/deCarta/Database/deCarta';

ij> select * from users;

USERID     |EMAIL
|PASSWORD                                |FIRSTNAME
|LASTNAME                                |ACTIVE

------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-------------------------------

1          |admin
|password                                |Dart
|Administrator                           |1

 

As you can see admin/password is a valid user.  The USERID 1 is in ROLE
1 which his Dart.Administrator.

 

The error on the command line when I attempt to login is:

 

<09 Jan 2008 13:23:45,737> [SocketListener0-1] INFO dart.server.Server

        User "admin" logging in.

<09 Jan 2008 13:23:45,739> [SocketListener0-1] WARN
org.mortbay.http.JDBCUserRealm

        UserRealm Dart could not load user information from database

ERROR 42X05: Table 'USERS' does not exist.

        at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)

-----------CLIP--------

<09 Jan 2008 13:23:45,740> [SocketListener0-1] WARN dart.server.Server

        User "admin" could not be authenticated.

 

 

Can anyone shed some light on why I can't login?  My server URL's are
setup like this:

 

http://dart <http://dart/> 

            productX/

                        dependencyA

                        dependencyB

                        dependencyC

 

productX is just a directory I use on the file system so that I can
organize dart projects that belong together under one directory.  If a
new dependency is introduced, I would create it's projects using: java
-jar DartServer.jar -create productX/dependencyD.

 

So my full URL to a project dashboard ends up being
http://dart/productX/dependancyA

And for user authentication:
http://dart/productX/dependancyA/User/UserLogin

 

Thanks in advance.

 

Cheers,

David

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://public.kitware.com/pipermail/dart/attachments/20080109/a48c505e/attachment-0001.html