[rt-users] MySQL odbc connections to RT

[Joseph Spenner]

Robert:
  Thanks for the tip!  I got it to work with the
following:

mysql -uroot -p

mysql> grant all privileges on rt2.* to rt_user@'%'
identified by 'rt_mypass' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on rt2.* to
rt_user@'localhost' identified by 'rt_mypass' with
grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> 


--- Robert  Joost <rob.joost at knowledgenet.com> wrote:
> Right off the bat, so, sorry if I missed your
> meaning,
> it sounds like you just need to ensure you got
> permissions correct:
> 
> mysql>grant all privileges on rt2.* to
> rt_user at myrtbox identified by
> 'your-password';
> 
> mysql>flush privileges;
> 
> 
> 
> On Mon, 2003-07-14 at 11:04, Joseph Spenner wrote:
> > I'm trying to use the Windows MySQL ODBC 3.51
> driver
> > to connect to the mysql database behind my RT
> 2.0.15
> > (linux).   From the windows box I hope to
> eventually
> > use Crystal Reports to query and generate reports.
> > Upon installing the ODBC driver on the Windows box
> and
> > testing, I get an error in Windows:
> > 
> > [MySQL][ODBC 3.51 Driver] Access denied for user:
> > rt_user at myrtbox' (Using Password: YES)
> > 
> > In the ODBC driver configuration, I used the
> following
> > info:
> > 
> > db name: rt2
> > db user: rt_user
> > db pass: <pass from the config.pm>
> > 
> > Is there some special way mysql needs to be
> started,
> > or some command line flag somewhere preventing my
> > connection from working?
> > Currently, it appears that mysql only permits
> > connections from the IP of the host itself.  For a
> > quick test, I built a local ssh redirect on the
> box
> > with the mysql to satisfy mysql (it thinks the
> > connection came from localhost) and pointed my
> odbc
> > driver to this new port.  So, tcp 3306 is covered.
> 
> > But udp 3306 is not.  Perhaps this is my problem?
> > 
> > If anyone else is using Crystal Reports to query
> RT,
> > I'd be interested in how you did this, or what I'm
> > doing wrong.
> > 
> > Thanks!
> > 
> > 
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> > Have you read the FAQ? The RT FAQ Manager lives at
> http://fsck.com/rtfm
> -- 
> Rob Joost
> Unix Administrator
> 
> KnowledgeNet
> 14624 N. Scottsdale Road, #300
> Scottsdale, AZ  85254
> Phone:   (480) 315-4841
> Cell:    (602) 920-6113
> Email: rob.joost at knowledgenet.com
> Web:   <http://www.knowledgenet.com/>
> 
> Why KnowledgeNet? Listen and learn from top
> customers -- Cisco, US
> Postal Service, and EMC, to name a few!
> <http://www.knowledgenet.com/onlineevents/>
> 
> 


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com