[prev in list] [next in list] [prev in thread] [next in thread]
List: dart
Subject: RE: [Dart] admin login error [table USERS does not exist]
From: "David Blado" <dblado () decarta ! com>
Date: 2008-01-09 23:46:11
Message-ID: 6C5C1804772DB944BA88A0DC48D338DA0198000D () dct-mail ! sanjose ! telcontar ! com
[Download RAW message or body]
--===============0789408539==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C85319.D26F2526"
This is a multi-part message in MIME format.
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@public.kitware.com
[mailto:dart-bounces+dblado=decarta.com@public.kitware.com] On Behalf Of
David Blado
Sent: Wednesday, January 09, 2008 1:38 PM
To: dart@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
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Update: problem \
solved.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Lesson learned. Do not move dart
directories around after the server/project was created </span></font><font
size=2 color=navy face=Wingdings><span style='font-size:10.0pt;font-family:
Wingdings;color:navy'>J</span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Cheers,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>David<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
dart-bounces+dblado=decarta.com@public.kitware.com
[mailto:dart-bounces+dblado=decarta.com@public.kitware.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>David Blado<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, January 09, 2008
1:38 PM<br>
<b><span style='font-weight:bold'>To:</span></b> dart@public.kitware.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Dart] admin login error
[table USERS does not exist]</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi All,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Here is my output from querying the server database directly
(‘deCarta’ is the name of my dart server on the \
filesystem):<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>-bash-3.00$ ./ij.ksh<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ij version 10.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ij> connect
'jdbc:derby:/home/dblado/dart/deCarta/Database/deCarta';<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ij> select * from users;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>USERID
> EMAIL & \
> nbsp; & \
> nbsp; & \
> nbsp; & \
> nbsp; & \
> nbsp;
>
> PASSWORD &nbs \
> p;
>
> FIRSTNAME &nb \
> sp;
>
> LASTNAME &nbs \
> p;
>
> ACTIVE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>------------------------------------------------------------------- \
-------------------------------------------------------------------------------------- \
----------------------------------------------------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>1
|admin &n \
bsp; &nbs \
p; \
&n \
bsp; &nbs \
p; \
|password &nbs \
p;
|Dart &n \
bsp;
|Administrator   \
; \
|1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>As you can see admin/password is a valid user. The
USERID 1 is in ROLE 1 which his Dart.Administrator.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The error on the command line when I attempt to login \
is:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><09 Jan 2008 13:23:45,737> [SocketListener0-1] INFO
dart.server.Server<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> User
"admin" logging in.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><09 Jan 2008 13:23:45,739> [SocketListener0-1] WARN
org.mortbay.http.JDBCUserRealm<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> UserRealm Dart
could not load user information from database<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>ERROR 42X05: Table 'USERS' does not \
exist.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> at
org.apache.derby.iapi.error.StandardException.newException(Unknown \
Source)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>-----------CLIP--------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><09 Jan 2008 13:23:45,740> [SocketListener0-1] WARN
dart.server.Server<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> User
"admin" could not be authenticated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Can anyone shed some light on why I can’t login?
My server URL’s are setup like this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><a \
href="http://dart/">http://dart</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
productX/<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
dependencyA<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
dependencyB<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>
dependencyC<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>So my full URL to a project dashboard ends up being <a
href="http://dart/productX/dependancyA">http://dart/productX/dependancyA</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And for user authentication: <a
href="http://dart/productX/dependancyA/User/UserLogin">http://dart/productX/dependancyA/User/UserLogin</a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks in advance.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Cheers,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>David<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
_______________________________________________
Dart mailing list
Dart@public.kitware.com
http://public.kitware.com/mailman/listinfo/dart
--===============0789408539==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic