Re: SQLCONNECT
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63460
interpreted = N
texte = i was right. different uid/pwd - a bit more 'gay' is working fine... abit slower than expected but it works... un saludo muy fuerte a smithmicro... if somebody hacks my mysql setup with this new user/password my peoplewill 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
i was right. different uid/pwd - a bit more 'gay' is working fine... abit slower than expected but it works... un saludo muy fuerte a smithmicro... if somebody hacks my mysql setup with this new user/password my peoplewill 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 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:
[WebDNA] Email Send Errors (2014)
BUG?- .html extention and not working. (2000)
HTML Editors (1997)
cookie length (1998)
Possible to reset Linux file permissions w/in webcat [shell] ? (2000)
Separate SSL Server (1997)
WebDNA Solutions ... sorry! (1997)
ups quickcost [repost] (1999)
pc (1997)
Bug Report, maybe (1997)
Size limit for tmpl editor ? (1997)
RAM crash (1998)
Netscape (1997)
Configuring E-mail (1997)
WebMerchant 1.6 and https (1997)
RE: PIXO support (1997)
PIXO support (1997)
WebMerchant? (1998)
I give up!! (1997)
Running 2 two WebCatalog.acgi's (1996)