Re: SQLCONNECT

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63461
interpreted = N
texte = HiYou did not mention what version of MySQL you are running. Be awa=re that WebDNA can only connect to MySQL in Version 4.x when you=20=set the password of your MySql user to the "old_password" schema.=Nitai--eContentPark - Enterprise Asset Management SystemRedakto eServices - Professional WebHelpDeskeSurvey - Online Questionnaire made easyRedakto CMS - Content Management that simply works ComputerOil=C2=AE AGNeugutstrasse 668600 D=C3=BCbendorf / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B=ehalf Of> kalin mintchev> Sent: Mittwoch, 23. November 2005 06:20> To: WebDNA Talk> Subject: Re: SQLCONNECT> > > > i was right. different uid/pwd - a bit more 'gay' is working=20=fine... a> bit slower than expected but it works...> > un saludo muy fuerte a smithmicro...> > if somebody hacks my mysql setup with this new user/password=20=my people> will be talking to their people.... :)> > give'em thanks... thus the season... or something...> > > >> >> > i guess i'll follow up with the monolog here...> >> > my suspicion now is that webcatalog is doing something with= the> password> > or is not passing it 'as is' to mysql.> > like i said manually the password works fine and the same p=assword> works> > fine in php scripts. the sql log has the same message - acces=s denied.> > so it is somehow related to what is the state the uid/pwd var=iables> > reach the mysql server...> > the password does contain #?@ etc... i tried '' "" and [url=][/url] but> > same result...> >> > any comments on this?> >> > thanks...> >> >> >> >>> >>> >> i also tried:> >>> >> [SQL> dsn=3Dsql_db&username=3Dthe_user&password=3Dbbbx?#moofoo&statem=ent=3DSELECT> >> *> >> from that_table]> >> Found [NumFound] items
> >> [FoundItems]> >> [au_lname], [au_fname], [title]
> >> [/FoundItems]> >> [/SQL]> >>> >> and i got:> >>> >> Error: SQL not supported..> >>> >> fun... now what?...> >>> >> the server i'm testing is bsd machine and evreything alse wo=rks fine.> >> webcatalog is 6.0...> >>> >>> >>>> >>> hi - i just realized i haven't been getting any emails fr=om this> list> >>> for days. but i did get mine.. if somebody is willing to=20=respond to> >>> this message can you please cc to kalin@el.net... thanks..=.....> >>>> >>>> >>>> >>>>> >>>>> >>>>> >>>> hi all...> >>>>> >>>> [SQLConnect> >>>>> dbType=3DMySQL&host=3Dlocalhost&database=3Dsql_db&uid=3Dthe_use=r&pwd=3Dbbbx?#moofoo&> conn_var=3Dconn1]> >>>> Connected successfully
> >>>> [/SQLConnect]> >>>>> >>>>> >>>> something is wromg with this code. i don't see what. when=20=i test it> >>>> manuall or within a php script with the same username and=20=password it> >>>> works fine but the context returns:> >>>>> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denied f=or user> >>>> 'the_user'@'localhost' (using password: YES)> >>>>> >>>> is the password unacceptable?!?!?> >>>>> >>>> thanks....> >>>>> >>>>> >>>>> >>>>> >>>> --> >>>>> >>>>> >>>>> >>>> ----------------------------------------------------------=---> >>>> This message is sent to you because you are subscribed to> >>>> the mailing list .> >>>> To unsubscribe, E-mail to: > >>>> To switch to the DIGEST mode, E-mail to> >>>> > >>>> Web Archive of this list is at: http://webdna.smithmicro.c=om/> >>>>> >>>> >>>> >>> --> >>>> >>>> >>>> >>> -----------------------------------------------------------=--> >>> This message is sent to you because you are subscribed to> >>> the mailing list .> >>> To unsubscribe, E-mail to: > >>> To switch to the DIGEST mode, E-mail to> >>> > >>> Web Archive of this list is at: http://webdna.smithmicro.co=m/> >>>> >>> >>> >> --> >>> >>> >>> >> ------------------------------------------------------------=-> >> This message is sent to you because you are subscribed to> >> the mailing list .> >> To unsubscribe, E-mail to: > >> To switch to the DIGEST mode, E-mail to> >> > >> Web Archive of this list is at: http://webdna.smithmicro.com=/> >>> >> >> > --> >> >> >> > -------------------------------------------------------------=> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to> > > > Web Archive of this list is at: http://webdna.smithmicro.com/=> >> > > --> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
Re: SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
Re: SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLCONNECT ( "kalin mintchev" 2005)
SQLCONNECT ( "kalin mintchev" 2005)
Re: SQLConnect to Oracle database ( Brian Fries 2004)
SQLConnect to Oracle database ( edwin@hoevers.com 2004)

HiYou did not mention what version of MySQL you are running. Be awa=re that WebDNA can only connect to MySQL in Version 4.x when you=20=set the password of your MySql user to the "old_password" schema.=Nitai--eContentPark - Enterprise Asset Management SystemRedakto eServices - Professional WebHelpDeskeSurvey - Online Questionnaire made easyRedakto CMS - Content Management that simply works ComputerOil=C2=AE AGNeugutstrasse 668600 D=C3=BCbendorf / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B=ehalf Of> kalin mintchev> Sent: Mittwoch, 23. November 2005 06:20> To: WebDNA Talk> Subject: Re: SQLCONNECT> > > > i was right. different uid/pwd - a bit more 'gay' is working=20=fine... a> bit slower than expected but it works...> > un saludo muy fuerte a smithmicro...> > if somebody hacks my mysql setup with this new user/password=20=my people> will be talking to their people.... :)> > give'em thanks... thus the season... or something...> > > >> >> > i guess i'll follow up with the monolog here...> >> > my suspicion now is that webcatalog is doing something with= the> password> > or is not passing it 'as is' to mysql.> > like i said manually the password works fine and the same p=assword> works> > fine in php scripts. the sql log has the same message - acces=s denied.> > so it is somehow related to what is the state the uid/pwd var=iables> > reach the mysql server...> > the password does contain #?@ etc... i tried '' "" and [url=][/url] but> > same result...> >> > any comments on this?> >> > thanks...> >> >> >> >>> >>> >> i also tried:> >>> >> [SQL> dsn=3Dsql_db&username=3Dthe_user&password=3Dbbbx?#moofoo&statem=ent=3DSELECT> >> *> >> from that_table]> >> Found [NumFound] items
> >> [founditems]> >> [au_lname], [au_fname], [title]
> >> [/FoundItems]> >> [/SQL]> >>> >> and i got:> >>> >> Error: SQL not supported..> >>> >> fun... now what?...> >>> >> the server i'm testing is bsd machine and evreything alse wo=rks fine.> >> webcatalog is 6.0...> >>> >>> >>>> >>> hi - i just realized i haven't been getting any emails fr=om this> list> >>> for days. but i did get mine.. if somebody is willing to=20=respond to> >>> this message can you please cc to kalin@el.net... thanks..=.....> >>>> >>>> >>>> >>>>> >>>>> >>>>> >>>> hi all...> >>>>> >>>> [SQLConnect> >>>>> dbType=3DMySQL&host=3Dlocalhost&database=3Dsql_db&uid=3Dthe_use=r&pwd=3Dbbbx?#moofoo&> conn_var=3Dconn1]> >>>> Connected successfully
> >>>> [/SQLConnect]> >>>>> >>>>> >>>> something is wromg with this code. i don't see what. when=20=i test it> >>>> manuall or within a php script with the same username and=20=password it> >>>> works fine but the context returns:> >>>>> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denied f=or user> >>>> 'the_user'@'localhost' (using password: YES)> >>>>> >>>> is the password unacceptable?!?!?> >>>>> >>>> thanks....> >>>>> >>>>> >>>>> >>>>> >>>> --> >>>>> >>>>> >>>>> >>>> ----------------------------------------------------------=---> >>>> This message is sent to you because you are subscribed to> >>>> the mailing list .> >>>> To unsubscribe, E-mail to: > >>>> To switch to the DIGEST mode, E-mail to> >>>> > >>>> Web Archive of this list is at: http://webdna.smithmicro.c=om/> >>>>> >>>> >>>> >>> --> >>>> >>>> >>>> >>> -----------------------------------------------------------=--> >>> This message is sent to you because you are subscribed to> >>> the mailing list .> >>> To unsubscribe, E-mail to: > >>> To switch to the DIGEST mode, E-mail to> >>> > >>> Web Archive of this list is at: http://webdna.smithmicro.co=m/> >>>> >>> >>> >> --> >>> >>> >>> >> ------------------------------------------------------------=-> >> This message is sent to you because you are subscribed to> >> the mailing list .> >> To unsubscribe, E-mail to: > >> To switch to the DIGEST mode, E-mail to> >> > >> Web Archive of this list is at: http://webdna.smithmicro.com=/> >>> >> >> > --> >> >> >> > -------------------------------------------------------------=> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to> > > > Web Archive of this list is at: http://webdna.smithmicro.com/=> >> > > --> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Nitai @ ComputerOil"

DOWNLOAD WEBDNA NOW!

Re: SQLCONNECT

2005

Top Articles:

Related Readings: