Re: SQLCONNECT
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63459
interpreted = N
texte = i guess i'll follow up with the monolog here... my suspicion now is that webcatalog is doing something with the passwordor is not passing it 'as is' to mysql. like i said manually the password works fine and the same password worksfine 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 variablesreach the mysql server... the password does contain #?@ etc... i tried '' "" and [url][/url] butsame 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/
Associated Messages, from the most recent to the oldest:
i guess i'll follow up with the monolog here... my suspicion now is that webcatalog is doing something with the passwordor is not passing it 'as is' to mysql. like i said manually the password works fine and the same password worksfine 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 variablesreach the mysql server... the password does contain #?@ etc... i tried '' "" and [url][/url] butsame 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/
"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:
Bug? (1997)
Feature Request : Separate [search] and [founditems] (2002)
Emailer (1999)
emailer w/F2 (1997)
Month from number (2002)
[WebDNA] TCPConnect assist (2016)
Frames and WebCat (1997)
[OT] Mac Utility Required (2000)
Browser security type (2000)
[WebDNA] Snow Leopard (2009)
MISTAKE in last post: Adding multiple items to Cart (1999)
Limiting user access to .tmpl files (1997)
Searching multiple Databases (1997)
[Solved? - with code] catching WebDNA error messages (2003)
Changes to the List (1997)
Modifying order output (1997)
OT: BulkRegister.com (2002)
refresh (2000)
FTP and [shell] (2003)
Problem (1997)