Re: SQLCONNECT

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63463
interpreted = N
texte = Best is to go to mysql.com. See the following two links:http://dev.mysql.com/doc/refman/4.1/en/application-password-use.h=tmlSince WebDNA MySQL protocols is considered "old_client" you have=20=to follow the instructions here:http://dev.mysql.com/doc/refman/4.1/en/old-client.htmlActually just set the users password with:mysql> SET PASSWORD FOR -> 'some_user'@'some_host' =3D OLD_PASSWORD('newpwd');Hope this helps.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 09:35> To: WebDNA Talk> Subject: Re: SQLCONNECT> > > > Hi> >> > You did not mention what version of MySQL you are running. Be= aware that> > WebDNA can only connect to MySQL in Version 4.x when you set=20=the> password> > of your MySql user to the "old_password" schema.> > mysql 4.1.9...> > can you please elaborate on the '"old_password" schema' thing?> > thank you....> > > >> > Nitai> >> > --> > eContentPark - Enterprise Asset Management System> > Redakto eServices - Professional WebHelpDesk> > eSurvey - Online Questionnaire made easy> > Redakto CMS - Content Management that simply works> >> > ComputerOil=C3=82=C2=AE AG> > Neugutstrasse 66> > 8600 D=C3=83=C2=BCbendorf / Switzerland> > Telefon +41 (0)844 44 55 66> >> > info@computeroil.com> > http://computeroil.com> >> -----Original Message-----> >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] O=n Behalf 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 worki=ng 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/passwo=rd 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 w=ith the> >> password> >> > or is not passing it 'as is' to mysql.> >> > like i said manually the password works fine and the sam=e password> >> works> >> > fine in php scripts. the sql log has the same message - ac=cess> denied.> >> > so it is somehow related to what is the state the uid/pwd=20=variables> >> > 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&sta=tement=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= works> fine.> >> >> webcatalog is 6.0...> >> >>> >> >>> >> >>>> >> >>> hi - i just realized i haven't been getting any emails= from this> >> list> >> >>> for days. but i did get mine.. if somebody is willing=20=to respond> >> to> >> >>> this message can you please cc to kalin@el.net... thank=s......> >> >>>> >> >>>> >> >>>> >> >>>>> >> >>>>> >> >>>>> >> >>>> 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. wh=en i test> it> >> >>>> manuall or within a php script with the same username a=nd password> >> it> >> >>>> works fine but the context returns:> >> >>>>> >> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denie=d for user> >> >>>> 'the_user'@'localhost' (using password: YES)> >> >>>>> >> >>>> is the password unacceptable?!?!?> >> >>>>> >> >>>> thanks....> >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>> --> >> >>>>> >> >>>>> >> >>>>> >> >>>> -------------------------------------------------------=------> >> >>>> This message is sent to you because you are subscribed=20=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.smithmicr=o.com/> >> >>>>> >> >>>> >> >>>> >> >>> --> >> >>>> >> >>>> >> >>>> >> >>> --------------------------------------------------------=-----> >> >>> This message is sent to you because you are subscribed t=o> >> >>> 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> >> > > >> > 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 >> 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/=> >> > > --> > > > -------------------------------------------------------------> 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)

Best is to go to mysql.com. See the following two links:http://dev.mysql.com/doc/refman/4.1/en/application-password-use.h=tmlSince WebDNA MySQL protocols is considered "old_client" you have=20=to follow the instructions here:http://dev.mysql.com/doc/refman/4.1/en/old-client.htmlActually just set the users password with:mysql> SET PASSWORD FOR -> 'some_user'@'some_host' =3D OLD_PASSWORD('newpwd');Hope this helps.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 09:35> To: WebDNA Talk> Subject: Re: SQLCONNECT> > > > Hi> >> > You did not mention what version of MySQL you are running. Be= aware that> > WebDNA can only connect to MySQL in Version 4.x when you set=20=the> password> > of your MySql user to the "old_password" schema.> > mysql 4.1.9...> > can you please elaborate on the '"old_password" schema' thing?> > thank you....> > > >> > Nitai> >> > --> > eContentPark - Enterprise Asset Management System> > Redakto eServices - Professional WebHelpDesk> > eSurvey - Online Questionnaire made easy> > Redakto CMS - Content Management that simply works> >> > ComputerOil=C3=82=C2=AE AG> > Neugutstrasse 66> > 8600 D=C3=83=C2=BCbendorf / Switzerland> > Telefon +41 (0)844 44 55 66> >> > info@computeroil.com> > http://computeroil.com> >> -----Original Message-----> >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] O=n Behalf 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 worki=ng 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/passwo=rd 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 w=ith the> >> password> >> > or is not passing it 'as is' to mysql.> >> > like i said manually the password works fine and the sam=e password> >> works> >> > fine in php scripts. the sql log has the same message - ac=cess> denied.> >> > so it is somehow related to what is the state the uid/pwd=20=variables> >> > 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&sta=tement=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= works> fine.> >> >> webcatalog is 6.0...> >> >>> >> >>> >> >>>> >> >>> hi - i just realized i haven't been getting any emails= from this> >> list> >> >>> for days. but i did get mine.. if somebody is willing=20=to respond> >> to> >> >>> this message can you please cc to kalin@el.net... thank=s......> >> >>>> >> >>>> >> >>>> >> >>>>> >> >>>>> >> >>>>> >> >>>> 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. wh=en i test> it> >> >>>> manuall or within a php script with the same username a=nd password> >> it> >> >>>> works fine but the context returns:> >> >>>>> >> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denie=d for user> >> >>>> 'the_user'@'localhost' (using password: YES)> >> >>>>> >> >>>> is the password unacceptable?!?!?> >> >>>>> >> >>>> thanks....> >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>> --> >> >>>>> >> >>>>> >> >>>>> >> >>>> -------------------------------------------------------=------> >> >>>> This message is sent to you because you are subscribed=20=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.smithmicr=o.com/> >> >>>>> >> >>>> >> >>>> >> >>> --> >> >>>> >> >>>> >> >>>> >> >>> --------------------------------------------------------=-----> >> >>> This message is sent to you because you are subscribed t=o> >> >>> 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> >> > > >> > 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 >> 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/=> >> > > --> > > > -------------------------------------------------------------> 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: