Re: SQLCONNECT
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63464
interpreted = N
texte = > > Hope this helps. thanks... it does.. i remember now... > > 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 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 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 > 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:
> > Hope this helps. thanks... it does.. i remember now... > > 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 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 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 > 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:
[authenticate] (1999)
user/password validation (1998)
View order not right (1997)
[WebDNA] version 7.1 on ubuntu apache2 virtual host config (2014)
Error: Permision deny. Unable to append to (2002)
Webcatalog and foreign languages (1998)
Bug - 4.5 (2002)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
[WebDNA] Nested Search (2008)
WebMerchant and PCAuthorize (1998)
random images (1997)
WCf2 and nested tags (1997)
Webcat OSX (2001)
HELP-1!!! (1998)
E-Commerce site for Canadian and US customers (1998)
Error: Missing c in orderfile???? (2005)
[WebDNA] WebDNA 7 (2011)
SKU lookup (1997)
Searching for (field1 OR field2) AND field3 (2000)
'does not contain' operator needed ... (1997)