samba - Sep 2006 - mssql, problem authenticating from stored procedure...

Hello,

running plain samba 3.023c on debian,  I'm trying to connect to a samba
share from within a stored procedure.

This works as long as samba is in "share" mode:

[2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309)
  check_ntlm_password:  guest authentication for user [] -> [] -> [nobody]
succeeded


When I try to attach samba share manually when logged in as the user running
the sqlserver agent, it also works:

[2006/09/30 17:58:43, 2] auth/auth.c:check_ntlm_password(309)
  check_ntlm_password:  authentication for user [sqlserver] -> [sqlserver]
-> [sqlserver] succeeded


But when running the stored procedure, which causes the sqlserver user to
login to the samba server I get this:

[2006/09/30 17:59:28, 2] auth/auth.c:check_ntlm_password(319)
  check_ntlm_password:  Authentication for user [sqlserver] -> [sqlserver]
FAILED with error NT_STATUS_WRONG_PASSWORD

This is extremely strange to me... :(
Any ideas is greatly appreciated... :)

/Kristoffer










but when user authentication is needed

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/30/2006 03:33 PM, Kristoffer Egefelt escreveu:
> Hello,
> 
> running plain samba 3.023c on debian,  I'm trying to connect 
> to a samba share from within a stored procedure.
> 
> This works as long as samba is in "share" mode:
> [2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309)
>  check_ntlm_password:  guest authentication for user [] -> [] ->
[nobody]
> succeeded
> 
> 
> When I try to attach samba share manually when logged in as 
> the user running the sqlserver agent, it also works:
> 
> [2006/09/30 17:58:43, 2] auth/auth.c:check_ntlm_password(309)
>  check_ntlm_password:  authentication for user [sqlserver] ->
[sqlserver]
> -> [sqlserver] succeeded
> 
> But when running the stored procedure, which causes the 
> sqlserver user to login to the samba server I get this:
> 
> [2006/09/30 17:59:28, 2] auth/auth.c:check_ntlm_password(319)
>  check_ntlm_password:  Authentication for user [sqlserver] ->
[sqlserver]
> FAILED with error NT_STATUS_WRONG_PASSWORD
> 
> This is extremely strange to me... :(
> Any ideas is greatly appreciated... :)
	Any chances that your password contains special characters
that are not properly quoted inside SQL?

	This is what I can think about, it does not looks like a
Samba problem, not even something related to NTLM/SMB/CIFS, more
likely that it is just the STORED PROCEDURE code.

> /Kristoffer
> but when user authentication is needed

	Kind regards,

- --
Felipe Augusto van de Wiel <felipe@paranacidade.org.br>
Coordenadoria de Tecnologia da Informa??o (CTI) - SEDU/PARANACIDADE
http://www.paranacidade.org.br/           Phone: (+55 41 3350 3300)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Debian - http://enigmail.mozdev.org

iD8DBQFFITbiCj65ZxU4gPQRAv6aAJ9Z11yX6dCon8BD620FjfvE29fNCQCgjOiF
oJlzHVw3PInggjXItx5zlW4=C9Ya
-----END PGP SIGNATURE-----