I am having some difficulty setting up MYSQL usage import. I have installed the 20 day evaluation of NetTools Pro, Running from MYSQL Administrator on the same host I can execute this query. SELECT UserName,count(UserName),sum(AcctSessionTime),sum(AcctOutputOctets) FROM radius.radacct WHERE AcctStartTime >= '05-02-01 00:00:00' AND AcctStartTime <= '05-03-01 00:00:00' GROUP BY UserName I get results formatted like this. USER | 35 | 288381 | 606186035 | I put the same query into Optigold under Maint/Prefs - General Prefs - Usage -SQL Hooks, The USE box is selected for "SQL Statement to Get monthly Usage" and on the General Prefs - Usage screen Usage Type is set to MYSQL. Username/Password and Hostname are correct. WHen I try to do a usage import from optigold it immediately pops up blank screen and asks if the usage data looks good. Any idea where I can look to get this working right?
Turn on the debugger (under My Stuff -> System Info), then run it and check the "Java Companion Log" file.
2005-03-07 14:10:35 Using cacerts file: D:\Program Files\FileMaker\FileMaker Pro 5.5\FileMaker Java Extensions\jssecacerts 2005-03-07 14:10:35 [SSLTransport] Initialization finished. https URLs are enabled. java.sql.SQLException: No suitable driver 2005-03-07 14:11:09 at java.sql.DriverManager.getConnection(Unknown Source) 2005-03-07 14:11:09 at java.sql.DriverManager.getConnection(Unknown Source) 2005-03-07 14:11:09 at com.acmetech.fm.jdbc.FMJDBCPlugin.do(Unknown Source) 2005-03-07 14:11:09 at com.acmetech.fm.jdbc.FMJDBCPlugin.jcDriverConnect(Unknown Source) 2005-03-07 14:11:09 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2005-03-07 14:11:09 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 2005-03-07 14:11:09 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 2005-03-07 14:11:09 at java.lang.reflect.Method.invoke(Unknown Source) 2005-03-07 14:11:09 at com.acmetech.fm.l.a(Unknown Source) 2005-03-07 14:11:09 at com.acmetech.fm.a.a(Unknown Source) 2005-03-07 14:11:09 at com.acmetech.fm.FMPluginBroker.dispatchBytesToExternal(Unknown Source)
yes this is what I have xxx.xx.xxx.xx/radius The IP is correct and radius is the DB Name that's in the space labeled ip address[ort]/database. The username and password are also correct.
where should I send it, I am hesitant to post it publically unless I wipe out the pertinent info which would be useless.
Hmmm... truthfully everything *looks* okay... anyway you could open it to the outside world so I could test a connection to your DB from the outside world?
if you use the username/password/ip address in the screen cap you should be able to get in. If you can't read them let me know and I'll email them directly to you. Thanks Eric
Try applying the OLD_PASSWORD() function to your mysql password. Different versions of MySQL use a different password hashing scheme. That's the only thing I can think of right now... http://dev.mysql.com/doc/mysql/en/application-password-use.html
On a side note, can't wait to see what happens with the MYSQL/PHP rewrite, I understand your reasons for playing it close to the cuff as far as release dates and such but I have to admit the suspense is killing me, are things going well with the rewrite at least? Thanks Eric