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... 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQLCONNECT ( "kalin mintchev" 2005)
  2. Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
  3. Re: SQLCONNECT ( "kalin mintchev" 2005)
  4. Re: SQLCONNECT ( "Nitai @ ComputerOil" 2005)
  5. Re: SQLCONNECT ( "kalin mintchev" 2005)
  6. Re: SQLCONNECT ( "kalin mintchev" 2005)
  7. Re: SQLCONNECT ( "kalin mintchev" 2005)
  8. Re: SQLCONNECT ( "kalin mintchev" 2005)
  9. SQLCONNECT ( "kalin mintchev" 2005)
  10. Re: SQLConnect to Oracle database ( Brian Fries 2004)
  11. SQLConnect to Oracle database ( edwin@hoevers.com 2004)
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 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)