mysql tables, howto...

Hi,

There are currently no SQL scripts to create the tables for MySQL. I could probably create a SQL script from MySQL but there are other things that need to be done to setup the database such as load the configuration.

What happened when you tried to use MetaTraffic setup to configure MySQL? Whatever it was can probably be solved.

~Chad

I dont remember exactly what happens exactly with the setup. But I know that it does not work. As I have a limited quantity of databases on my host to use (2 at the moment, where I use 1 dbase for the shopping card and the second for my future dbase), I would like to append the metatraffic2 tables on this one active database to track the traffic, brecause at the moment there is no possibility for me to effort to pay one more (3rd) database connection. That is why I would prefer to append the generated mySQL tables to my active one. By the way I tried the setup on my "localhost" in both ways with mySQL, once with changing the SQL tables into mySQL tables and disabling auto table generation in the setup(thats the part I might made some errors and why I am asking for a .txt file pf mySQL tables to generate) and the second with the setup from scratch with auto generating tables. Both were without success...
I would apreciate it if you could give me a hand with a mySQL.txt which should contain the tables for it.

NA

...
Looking forward to solve this problem and
buying a licence ASAP !

Thanks !

NA

MetaTraffic does not require its own database. It will co-exist happily with other tables on the same database. Please note the minimum requirements for MetaTraffic if using MySQL is version 4.1.

I don't understand why the setup wouldn't work. If there is a problem with it, I would like to fix it. Please try the setup again and let me know what the problem was, error messages, etc.

Thanks,
~Chad

I get the message below, when I try to setup onto my actual database called "codeblue"...

MetaTraffic Setup
STEP 1: Connecting to new database...

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'aryServer(...)'

/metatraffic2/setup.asp, line 415

NA

What are you entering for the Database Location? This needs to be a hostname or IP address of the MySQL server.

For example:

mysql5.domain.com
50.50.50.50
locahost

~Chad

I am using the local drive path of c:\mysql\data\codeblue where codeblue is the directory of the actual tables
Do you suggest to write http://localhost:3306 or 127.0.0.1:3306 instead ?
Normally I am using mySQL control center to setup the tables into the mysql server on my localhost (at the moment we run/test metatraffic2 online with odbc on our host).
What would be the exact url to type in for localhost ?
Thank you.

You should be able to just enter Localhost as your server location and it will work. 3306 is the default port so this does not need to be specified.

~Chad

Yes and that is what I get:

MetaTraffic Setup
STEP 1: Connecting to new database...SUCCESS

STEP 2: Creating database connection file...SUCCESS

STEP 3: Testing configuration file permissions...SUCCESS

STEP 4: Creating new database tables...FAILED

There was a database error:

Number: -2147217900
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 1

Go back and try again.

???
What now ?

NA

MetaTraffic requires MySQL version 4.1 or greater. You are running version 4.0 so it will not work. Either upgrade MySQL or try using MS Access or SQL Server.

~Chad

Yes, Thanks!
I've found mySQL 4.1.0 GAMMA version and will upgrade...
But for my host I have no chance, they are still using 4.0.13. After evaluation I must think of using Access and licence or deleting it from my host (lack of support).
Do you know any downloadable mySQL 4.1 which is not on alpha, beta or gamma ?
Another question:
Does metatraffic support mySQL 5.0 Beta ?

NA

It has only been tested with MySQL 4.1, but I would guess that 5.0 would work and be backward compatible with the features on 4.1.

Unfortunately, 4.1 has still not been released as a production release. When I first starting integrating MySQL into MetaTraffic almost a year ago, I assumed it would have been released by now.

~Chad

yes baggallery Metatraffic runs perfectly on MySQL 5.0.0 and 5.0.1 i have used it on both! i track my site kickassamd on 5.0.1 (gets about 2500 uniques a day), 4.1 series was slow with bigger queries...

I have purchased the PRO version, but using Access until my host updates its mySQL to 4.1 or higher.
Thanks to all for their kind replies !

NA