Unable to decipher ODBC trace log

------=_Part_3863_2275934.1195053789022
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Trying to use ODBC (windows) to connect to MySQL (Linux). The trace file
shows the following:

odbcad32 cec-dc8 ENTER SQLDriverConnectW
HDBC 00A215E8
HWND 00000000
WCHAR * 0x74329A38 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 0

odbcad32 cec-dc8 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 00A215E8
HWND 00000000
WCHAR * 0x74329A38 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 0

DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user 'sac'@'
nnn.nnn.nnn' (using password: NO) (1045)


I have verified that the grants are setup properly (have tried a number of
variations as well), the Linux firewall is open, and all appropriate names
can be resolved. What does the odbc trace log tell me?

--
Charles Schultz

------=_Part_3863_2275934.1195053789022--

Re: Unable to decipher ODBC trace log

Charles,

There are two type of grants: localhost and others. Did you issue a
GRANT ALL statement for both? Refer to
http://kb.synametrics.com/FrontController?operation=1&id=49


Best regards,
Imran.

Charles Schultz wrote:
> Trying to use ODBC (windows) to connect to MySQL (Linux). The trace file
> shows the following:
>
> odbcad32 cec-dc8 ENTER SQLDriverConnectW
> HDBC 00A215E8
> HWND 00000000
> WCHAR * 0x74329A38 [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x74329A38
> SWORD 2
> SWORD * 0x00000000
> UWORD 0
>
> odbcad32 cec-dc8 EXIT SQLDriverConnectW with return code -1
> (SQL_ERROR)
> HDBC 00A215E8
> HWND 00000000
> WCHAR * 0x74329A38 [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x74329A38
> SWORD 2
> SWORD * 0x00000000
> UWORD 0
>
> DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user 'sac'@'
> nnn.nnn.nnn' (using password: NO) (1045)
>
>
> I have verified that the grants are setup properly (have tried a number of
> variations as well), the Linux firewall is open, and all appropriate names
> can be resolved. What does the odbc trace log tell me?
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Unable to decipher ODBC trace log

------=_Part_4065_16519961.1195057242707
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Yes, I tried localhost, %, ip numbers, remote host, with and without
password. I can connect locally fine (on the server), but not from the
client. Hence I did the trace to see if that would help. I do not know
enough about mySQL for it to be of any assistance to me, so I was hoping
some gurus out there would drop a little nugget for me.

On Nov 14, 2007 10:15 AM, Imran Abizar wrote:

> Charles,
>
> There are two type of grants: localhost and others. Did you issue a
> GRANT ALL statement for both? Refer to
> http://kb.synametrics.com/FrontController?operation=1&id=49
>
>
> Best regards,
> Imran.
>
> Charles Schultz wrote:
> > Trying to use ODBC (windows) to connect to MySQL (Linux). The trace file
> > shows the following:
> >
> > odbcad32 cec-dc8 ENTER SQLDriverConnectW
> > HDBC 00A215E8
> > HWND 00000000
> > WCHAR * 0x74329A38 [ -3] "******\ 0"
> > SWORD -3
> > WCHAR * 0x74329A38
> > SWORD 2
> > SWORD * 0x00000000
> > UWORD 0
> >
> > odbcad32 cec-dc8 EXIT SQLDriverConnectW with return code -1
> > (SQL_ERROR)
> > HDBC 00A215E8
> > HWND 00000000
> > WCHAR * 0x74329A38 [ -3] "******\ 0"
> > SWORD -3
> > WCHAR * 0x74329A38
> > SWORD 2
> > SWORD * 0x00000000
> > UWORD 0
> >
> > DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user
> 'sac'@'
> > nnn.nnn.nnn' (using password: NO) (1045)
> >
> >
> > I have verified that the grants are setup properly (have tried a number
> of
> > variations as well), the Linux firewall is open, and all appropriate
> names
> > can be resolved. What does the odbc trace log tell me?
> >
> >
>



--
Charles Schultz

------=_Part_4065_16519961.1195057242707--

Re: Unable to decipher ODBC trace log

------=_Part_4258_27416714.1195059808664
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

After doing a little more reading, I think I may have resolved this. I had
multiple entries in "user" for my various tests, not realizing that there
was an order of precedence. After dropping the user and regranting, I was
able to connect properly.

thx

On Nov 14, 2007 10:20 AM, Charles Schultz wrote:

> Yes, I tried localhost, %, ip numbers, remote host, with and without
> password. I can connect locally fine (on the server), but not from the
> client. Hence I did the trace to see if that would help. I do not know
> enough about mySQL for it to be of any assistance to me, so I was hoping
> some gurus out there would drop a little nugget for me.
>
>
> On Nov 14, 2007 10:15 AM, Imran Abizar wrote:
>
> > Charles,
> >
> > There are two type of grants: localhost and others. Did you issue a
> > GRANT ALL statement for both? Refer to
> > http://kb.synametrics.com/FrontController?operation=1&id=49
> >
> >
> > Best regards,
> > Imran.
> >
> > Charles Schultz wrote:
> > > Trying to use ODBC (windows) to connect to MySQL (Linux). The trace
> > file
> > > shows the following:
> > >
> > > odbcad32 cec-dc8 ENTER SQLDriverConnectW
> > > HDBC 00A215E8
> > > HWND 00000000
> > > WCHAR * 0x74329A38 [ -3] "******\ 0"
> > > SWORD -3
> > > WCHAR * 0x74329A38
> > > SWORD 2
> > > SWORD * 0x00000000
> > > UWORD 0
> > >
> > > odbcad32 cec-dc8 EXIT SQLDriverConnectW with return code
> > -1
> > > (SQL_ERROR)
> > > HDBC 00A215E8
> > > HWND 00000000
> > > WCHAR * 0x74329A38 [ -3] "******\ 0"
> > > SWORD -3
> > > WCHAR * 0x74329A38
> > > SWORD 2
> > > SWORD * 0x00000000
> > > UWORD 0
> > >
> > > DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user
> > 'sac'@'
> > > nnn.nnn.nnn' (using password: NO) (1045)
> > >
> > >
> > > I have verified that the grants are setup properly (have tried a
> > number of
> > > variations as well), the Linux firewall is open, and all appropriate
> > names
> > > can be resolved. What does the odbc trace log tell me?
> > >
> > >
> >
>
>
>
> --
> Charles Schultz




--
Charles Schultz

------=_Part_4258_27416714.1195059808664--