JCIFS SmbException Login failure |
Juan |
2010-10-29 08:20:15.0 |
I have a strange situation and very much appreciate your guidance.
The dbf files are hosted on a WinXP machine. I can access those files OK using the smbclient from my Linux computer. But if I try to execute a query from the same machine, I receive the following exception:
jcifs.smb.SmbException: Logon failure: the user has not been granted the requested logon type at this computer.
Any idea?
Thanks.
Juan
|
Re:JCIFS SmbException Login failure |
Juan |
2010-10-29 13:45:55.0 |
I want to clarify that the SQL query is sent using to the XP machine through a connection using the HTTX DBF driver.
|
Re:Re:JCIFS SmbException Login failure |
HXTT Support |
2010-10-29 17:04:34.0 |
>jcifs.smb.SmbException: Logon failure: the user has not been granted
>the requested logon type at this computer.
What's your jdbc url or sql? You need to use your user/password in jdbc url or UNC path.
|
Re:Re:Re:JCIFS SmbException Login failure |
Juan |
2010-10-30 06:09:03.0 |
I am using the same user name and password that I use with the smbclient utility.
However, I am not including those on the URL but rather on the login box of the SQL utility, should this work?
The url is jdbc:dbf:smb://winpaq/adminpaq/ml
Thanks.
|
Re:Re:Re:Re:JCIFS SmbException Login failure |
HXTT Support |
2010-10-30 06:25:50.0 |
>The url is jdbc:dbf:smb://winpaq/adminpaq/ml
Try jdbc:dbf:smb://username:password6@winpaq/adminpaq/ml
|
Re:JCIFS SmbException Login failure |
Juan |
2010-10-30 09:41:23.0 |
The connection works using the method you suggested.
The question remains, does this mean that connecting passing parameters (like user name and password) to the Connection class is not supported by the DBF driver or is this a JCIFS issue?
Juan
|
Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure |
HXTT Support |
2010-10-30 18:27:14.0 |
>does this mean that connecting passing parameters (like user name and password)
>to the Connection class is not supported by the DBF driver
Supports. But that user/password in connection properties are used for database connection, not for SAMBA connection.
|
Re: JCIFS SmbException Login failure |
Juan |
2010-11-03 15:49:44.0 |
As far as I know, there is no such thing as a database connection when dealing with a DBF (its only a file), am I right?
If the above is true, wouln't it make sense to pass the user name and password to the JIFS driver for jdbc:dbf:smb URLs?, maybe only when it is not supplied as part of the URL (as in jdbc:dbf:smb://username:password@machine)?
Juan
|
Re:Re:Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure |
HXTT Support |
2010-11-03 16:07:47.0 |
>As far as I know, there is no such thing as a database connection when dealing
>with a DBF (its only a file), am I right?
Sorry. HXTT DBF supports server/client mode also, and will use user/password for remote login/remote control.
|
Re:JCIFS SmbException Login failure |
Juan |
2010-11-04 06:44:20.0 |
Even so, wouldn't it be possible/desirable to also pass the user/password to the JIFS driver (when not supplied in the URL)?
|
Re:Re:Re:Re:Re:Re:Re:Re:JCIFS SmbException Login failure |
HXTT Support |
2010-11-04 06:54:12.0 |
>Even so, wouldn't it be possible/desirable to also pass the user/password to the
> JIFS driver (when not supplied in the URL)?
We can. But it will give away user/password to samba server since samba url an use in jdbc url or sql. It will faile for anomyous samba access when provided wrong unnecessary user/pasword.
|
Re:JCIFS SmbException Login failure |
Juan D��az |
2010-11-04 07:48:06.0 |
I understand. Maybe it would be good to state this on the documentation (the difference on samba vs connection user/name password). It took me some time to figure it out. If it is already stated, then I skipped it.
Thanks again.
|