Re: SQLCONNECT
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63462
interpreted = N
texte = > 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 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® AG > Neugutstrasse 66 > 8600 Dübendorf / 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] On 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 working 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 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 password >> works >> > fine in php scripts. the sql log has the same message - access denied. >> > so it is somehow related to what is the state the uid/pwd 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=sql_db&username=the_user&password=bbbx?#moofoo&statement=SELECT >> >> * >> >> 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 to respond >> to >> >>> this message can you please cc to kalin@el.net... thanks...... >> >>> >> >>> >> >>> >> >>>> >> >>>> >> >>>> >> >>>> hi all... >> >>>> >> >>>> [SQLConnect >> >>>> >> dbType=MySQL&host=localhost&database=sql_db&uid=the_user&pwd=bbbx?#moofoo& >> conn_var=conn1] >> >>>> Connected successfully
>> >>>> [/SQLConnect] >> >>>> >> >>>> >> >>>> something is wromg with this code. i don't see what. when i test it >> >>>> manuall or within a php script with the same username and password >> it >> >>>> works fine but the context returns: >> >>>> >> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denied for 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.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.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/ > -- ------------------------------------------------------------- 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:
> 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 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® AG > Neugutstrasse 66 > 8600 Dübendorf / 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] On 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 working 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 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 password >> works >> > fine in php scripts. the sql log has the same message - access denied. >> > so it is somehow related to what is the state the uid/pwd 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=sql_db&username=the_user&password=bbbx?#moofoo&statement=SELECT >> >> * >> >> 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 to respond >> to >> >>> this message can you please cc to kalin@el.net... thanks...... >> >>> >> >>> >> >>> >> >>>> >> >>>> >> >>>> >> >>>> hi all... >> >>>> >> >>>> [SQLConnect >> >>>> >> dbType=MySQL&host=localhost&database=sql_db&uid=the_user&pwd=bbbx?#moofoo& >> conn_var=conn1] >> >>>> Connected successfully
>> >>>> [/SQLConnect] >> >>>> >> >>>> >> >>>> something is wromg with this code. i don't see what. when i test it >> >>>> manuall or within a php script with the same username and password >> it >> >>>> works fine but the context returns: >> >>>> >> >>>> ERROR: MySQL DATABASE CONNECTION FAILED! - Access denied for 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.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.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/ > -- ------------------------------------------------------------- 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/
"kalin mintchev"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Make sure I understand this??? (1997)
CART question (2004)
Location of Webcat site in folder hierarchy (1997)
WebDNA Solutions ... sorry! (1997)
customizing the color of user's pages (1997)
Proposed FormVariables hierarchy (2000)
problems with 2 tags (1997)
AutoCommit Preference? (1998)
Cart Question: The Epic Saga (1998)
One more try: WebCat for Dummies p2.2 (2000)
test - ignore (2008)
Undeliverable Mail (1997)
FREE Stuff .. (2003)
New Site (1998)
Million product store (2003)
WebCat2 - Getting to the browser's username/password data (1997)
Protecting Files (2005)
[WebDNA] Proper use of [spawn]? (2009)
my price won't move (1997)
Grep Help (2003)