1. 

   myDBR Team, Key Master

   Hi,
   myDBR Team is happy to announce the availability of myDBR 1.7.0, a maintenence release for myDBR.

   The version concentrates on improving overall usability, customization and integration support.

   New features include:
   

   • Added user preferences
   • SSO protocol now supports user groups
   • Reports can now auto refresh itself
   • Autologin feature re-enabled
   • Included Geo-extension to locate IP addresses
   
   

   Improvements:
   

   • Reduced network traffic
   • Theme improvements
   • Firefox UI cleanup
   • Improved SQL Editor
   • Improved error handling for misconfigured servers
   
   

   As always, you can update to new version using the myDBR's automated updater.

   Happy reporting,
   --
   myDBR Team
2. 

   brad@foreverybody, Blocked

   for the record the ExpiresActive and ExpiresDefault directives in .hataccess causes an error 500 on my server. I have removed them in order to get myDBR working.
3. 

   myDBR Team, Key Master

   ExpiresActive and ExpiresDefault require that the Apache module mod_expires is enabled. (You might in some occasions get the error 500 with invalid permissions in the .htaccess.)

   By enabling this module and using the .htaccess file greatly reduces the network traffic. You'll see the advantage especially on slow lines/devices like using myDBR with mobile phones.

   --
   myDBR Team
4. 

   brad@foreverybody, Blocked

   indeed i assumed it was something simple like installing and loading a new module. i just didn't know which one. all better now.

   thanks
5. 

   aescripts, Member

   Any demos or docs on the new Geo-extension?
6. 

   myDBR Team, Key Master

   Geo-extension was included as an example for extra functionality that can be added through extensions. (It was not originally meant to be a public extension, but someone might find it useful). You are free to modify it any way you like.

   Geo-extension uses MaxMind's (http://www.maxmind.com) web-services to convert IP-numbers to locations (country / city / longitude / latitude), which you can then use with Google Maps -extension. An example use case would be that you would like to show your visitors in the Google Maps.

   You need to have a license key from MaxMind ($geo_license_key) and you need to implement two stored procedures: sp_Geo_ip_getnew which gets the IP-numbers to be searched for and sp_Geo_location_add which will store the location results to the database to your own table.

   Extension has one command 'dbr.geoupdate', which will run the IP-address lookup sequence.

   A sample report using the service would be like this:

   
   
   /* select-clause causes Geo-extension to run and update coordinates in 'visitors'-table */
   
   select 'dbr.geoupdate';
   
   select 'just run it';
   
   /* Show the results on  Google Maps */
   
   select 'dbr.googlemaps', 'coordinates', 'Visitors';
   
   select latitude, longitude, users
   
   from visitors;
   
   

   As a result, you would have a nice Google Maps showing all your visitors.

   --
   myDBR Team
7. 

   aescripts, Member

   Does it work with GeoLite City? http://www.maxmind.com/app/geolitecity
8. 

   myDBR Team, Key Master

   The Geo-extension uses the MaxMind GeoIP service where the MaxMind's IP geolocation data is utilized using their web service. This means that the GeoIP database is hosted by MaxMind. This will provide you accurate and always updated information.

   GeoLite City is a free downloadable database that you can install into your own server. If you opt to do this, you can use it in directly myDBR reports without the need of Geo-extension.

   --
   myDBR Team
9. 

   abhishek.srivastava, Member

   Hi myDBR Team,

   Firstly, I would appreciate myDBR team efforts for creating such a useful and efficient Reporting Tool.

   I am wondering, can I integrate myDBR tool with my PHP website?
   OR
   Can I integrate my complete site with myDBR Source Code?

   Waiting for your quick response,

   Abhishek
10. 

    myDBR Team, Key Master

    myDBR allows variety of integration options.

    You can choose if you use myDBR UI for report execution or if you fully integrate myDBR into your website / application by hiding all myDBR related activity (logins, UI etc),

    --
    myDBR Team

Reply

You must log in to post.