I am using James 2.0a2.
I did the trace, it looks like I am getting several lines of white space being sent
with the SQL parameter.
----------------- Sample Trace Output (slightly abbreviated)
declare @P1 int
set @P1=1
exec sp_prepexec @P1 output, N'@P1 char(8000)', N'
SELECT username, pwdHash, pwdAlgorithm, useForwarding,
forwardDestination, useAlias, alias
FROM users
WHERE lower(username) = @P1
', 'fred
'
select @P1
-----------------
I am not sure if the above is normal. I also noticed that the SELECT and INSERT
statements run, but I did not see a
DELETE statement when I issues a "deluser" command. I am not sure how to confirm that
the proper data was returned to
James from the Query.
Also, I downloaded and tried the Microsoft JDBC beta driver, but when I try to start
James with this driver, it just
hangs after outputting the "Phoenix 3.1a1-dev" line. I know the drivers are at least
semi-functional, since I tried
them with some other code I have.
I guess I'll try downloading the demo of the inet drivers.
Does the above give you any ideas towards a solution?
-----Original Message-----
From: Serge Knystautas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 4:43 PM
To: James Users List; [EMAIL PROTECTED]
Subject: Re: Problem with User Repository in MS SQL Server Database
What version of James are you using? There might be an issue using the
JDBC/ODBC bridge, although I'm not sure why. I'm using James 2.0.pre-alpha
w/SQL Server using the inet software JDBC driver and haven't had a problem.
Can you open SQL Profiler and watch what SQL commands are getting sent to
the users table? Maybe a statement is getting messed up in James or by the
JDBC driver.
Serge Knystautas
Loki Technologies - Unstoppable Websites
http://www.lokitech.com/
----- Original Message -----
From: "Chris Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 4:29 PM
Subject: Problem with User Repository in MS SQL Server Database
> Hello,
>
> I have configured James to use JDBCODBC bridge to connect to a SQL server
> fir the user repository. The connection functions successfully, and I am
> able to add users to the database by telneting to port 4555. My first
> problem comes when I attempt to connect with POP3 and authenticate with an
> earlier created account. I always get authentication failed (I have also
> telneted to port 110 and not been able to authenticate, though I do get
> connected). My second problem is this; if I attempt to remove an account
> through telnet, I get a "successfully removed" message, but when I check
the
> database tables the account is still there. If I "verifyuser", I am told
> the account does not exist, if I "listuser" the account appears on the
list,
> if I try to re-add the user I get an error.
>
> It appears to me that some of the commands are successfully accessing the
> database, while others are not. Checking the log files seems to show that
> everything is functioning properly (no glaring errors). The only
> non-standard thing I have changes in the config.xml, is the table names
for
> the user and list tables within the DB.
>
> Any help is appreciated.
>
> Thanks,
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
