Rick, Try checking in mysql to make sure that the root user has permission (and has the same password) on the database you are trying to connect to (within mysql rather than in witango). Also check your taf settings for development/deployment preferences for datasources.
Jason On 8/17/02 6:12 PM, "Rick Sanders" <[EMAIL PROTECTED]> wrote: > > Hey Robert, > > Thanks for the help! > > I've tried using a different user by specifying the user in the ODBC.ini but > it keeps defaulting to the root user! > > Here's my odbc.ini which is in the /usr/local/tango/etc > > [ODBC Datasources] > bloks=MySQL Database > > [bloks] > Description = bloks database > Driver = /usr/local/lib/libmyodbc-2.5-2.50.38.so > DSN = bloks > ServerName = bloks (Also tried localhost) > Trace = No > user = root (Also tried other users) > password = bloks > port = 3306 > host = bloks (Also tried localhost) > database bloks > > Thanks in advance! > > Rick > >> >> Actually it looks like you're making a connection ot the DB just fine, but >> the problem is that you're trying to access the DB as root and the root user >> of MySQL has a password set, and that's why you're getting rejected. >> >> 2 things: >> 1- use the root password >> 2- use a different user with the proper password (DO THIS NOT THE OTHER IF >> YOU CAN) >> >> R >> On Saturday, August 17, 2002, at 01:54 PM, Rick Sanders wrote: >> >>>>>> Hey List, >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> I've installed WiTango successfully on Linux. Tafs run fine. However, >>>>>>>> when I try to run a taf connecting to a MYSQL DSN, I get: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> [TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: >>>>>>>> NO) >>>>>>>> S1000 >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> If anyone could help me with proper ODBC.ini and permission settings, I >>>>>>>> would greatly appreciate it! >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Thanks in advance. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Rick Sanders >>>>>>>> President, Web Energy >>>>>>>> Tel: (514) 620-3006 >>>>>>>> Fax: (514) 620-3017 > Web: www.webenergy-sw.com >>>>>> -- ____________________________________________________________________ Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com ____________________________________________________________________ Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________ A North American Distributor for Witango (http://www.witango.com) Rapid Web Application Development - XML Execution Engine ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
