Page 1 of 1

VTS connection problem

Posted: Tue 2. Nov 2004, 12:15
by kmoon
OK so I installed VTS 1.3.4 RC1 on phpwcms 1.1 RC4
Installation went good but now all I get is an error:

phpOpenTracker Error: Could not connect to database.

I did the settings in include/inc_ext/phpOpenTracker/phpOpenTracker/conf/phpOpenTracker.php and even tried setting my connection info ther places.

Any ideas?

Database error

Posted: Tue 2. Nov 2004, 17:30
by Neelix
look at this: :!:
- config in phpOpenTracker.php
-------[FIND]---------
// Added by Christian Günther | guenther@emediafabrik.de for VTS-MOD
// Have a look into your include/inc_conf/conf.inc.php

$phpwcms["db_host"] = '...';
$phpwcms["db_user"] = '...';
$phpwcms["db_pass"] = '...';
$phpwcms["db_table"] = 'phpwcms';
$phpwcms["site"] = '...';
$phpwcms["root"] = '';

you shoult be use the values from include/inc_conf/conf.inc.php

- if you use phpmyadmin or the like
in the Database must be tables with starts with "pot_" 4 the tracker

- if not you check please: include/inc_ext/phpOpenTracker/phpOpenTracker/docs/sql/mysql/myisam_merge.sql
or myisam.sql
and paste maybe the statements in phpmyadmin sql-window
-------------------------------
I think it's an simple config-error - my install-test was ok

Posted: Tue 2. Nov 2004, 19:15
by kmoon
The tables are installed correctly in mysql
The cms runs perfectly using the exact same settings as I am trying to apply to phpOpenTracker.php

I tried aplying the sql from myisam_merge.sql

Still the script can't make the connection..
here's the info (password x'ed out)

Code: Select all

$phpwcms["db_host"]	= "mysql01.cliche.dk";
$phpwcms["db_user"]	= "ilbox_dk";
$phpwcms["db_pass"]	= "xxxxxx";
$phpwcms["db_table"]	= "ilbox_dk";
$phpwcms["site"]		= "http://www.ilbox.dk/";
$phpwcms["root"]		= "wcms";

Posted: Wed 3. Nov 2004, 07:22
by kmoon
Oh bugger... the path... the path to the config files... aarrgghhh...

Posted: Wed 3. Nov 2004, 07:24
by kmoon
kmoon wrote:Oh bugger... the path... the path to the config files... aarrgghhh...
Nope.. that wasn't it... tepaths are fine.

Posted: Thu 25. Nov 2004, 07:33
by ohno
well.... i have exactly the same problem!

i still cannot bring vts to connect to the database! :(

Posted: Fri 3. Dec 2004, 16:59
by cchhita
Yes I am trying to get VTS running on my localhost and the same problem as the others!

I have also installed SVG, but cannot get the graph showing up..... Also I only get very minimal info on my screen. i.e. The number of visitors... I cannot get info such as the browser they are using, page hits etc as I have seem in screen shots.

Any ideas?

Posted: Thu 20. Jan 2005, 17:51
by jmeyknecht

I found the trouble... Maybe

Posted: Mon 9. Jan 2006, 23:24
by chAb