Forum .LRN Q&A: user tracking installation problem

Collapse
Posted by Alberto Garcia on
Hi,

I'm trying to get e-lane's user tracking package up and running in dotlrn, but i'm not able since an installation error ocurred while installing from ACS repository.

This is the message i got:
Server Error
The requested URL cannot be accessed due to a system error on this server.

After the dotlrn server initializes, the user tracking is not visible from the dotlrn menus (it seems like it's not installed), but i'm able to see the package using this direct url: http://server:8000/user-tracking/

Anyway, i thing the installation was not completed since i'm not able to generate any statistics. When click on "actualizar datos" (update data) i allwais get "No hay datos para este mes" (no data for this month).

Am i doing something wrong?

Here is what the error.log file shows:

[26/Jan/2006:08:56:56][10722.3065842608][-conn:test::0] Notice: Installing user-tracking
[26/Jan/2006:08:56:56][10722.3065842608][-conn:test::0] Notice: <li>Downloading https://openacs.org/repository/5-1/user-tracking-0.1d3.apm...
[26/Jan/2006:08:57:37][10722.3059526576][-sched:16-] Notice: dbdrv: opening database 'postgres:localhost::test'
[26/Jan/2006:08:57:37][10722.3059526576][-sched:16-] Notice: Opening test on localhost
[26/Jan/2006:08:57:37][10722.3059526576][-sched:16-] Notice: Ns_PgOpenDb(postgres):  Openned connection to localhost::test.
[26/Jan/2006:08:57:40][10722.3065842608][-conn:test::0] Notice: <li>Done. Archive is 423.8KB, with 703 files.<li>
[26/Jan/2006:08:57:40][10722.3065842608][-conn:test::0] Notice: Extracting the .info file (<tt>user-tracking/user-tracking.info</tt>)...
[26/Jan/2006:08:57:41][10722.3065842608][-conn:test::0] Notice: <li>Extracting files into the filesytem.
[26/Jan/2006:08:57:41][10722.3065842608][-conn:test::0] Notice: <li>User Tracking 0.1d3 ready for installation.
[26/Jan/2006:08:57:41][10722.3065842608][-conn:test::0] Notice: <h3>Installing User Tracking 0.1d3</h3>
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loading packages/user-tracking/tcl/apm-callback-procs.tcl...
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loaded packages/user-tracking/tcl/apm-callback-procs.tcl.
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loading packages/user-tracking/tcl/filters-procs.tcl...
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loaded packages/user-tracking/tcl/filters-procs.tcl.
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loading packages/user-tracking/tcl/user-tracking-procs.tcl...
[26/Jan/2006:08:57:42][10722.3065842608][-conn:test::0] Notice: Loaded packages/user-tracking/tcl/user-tracking-procs.tcl.
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: <p><li>Installing data model for User Tracking 0.1d3...
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: <ul>
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: <li>Loading data model /var/lib/aolserver/test/packages/user-tracking/sql/postgresql/user-tracking-create.sql... <blockquote><pre>
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice:  DAVEB pghost = '' pgport = '' pguser = '-U test'
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: CREATE TABLE
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: </pre></blockquote>
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: </ul><p>
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: reading /var/lib/aolserver/test/packages/user-tracking/catalog/user-tracking.en_US.ISO-8859-1.xml in ISO-8859-1
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: encoding: loaded: iso8859-1
[26/Jan/2006:08:57:43][10722.3065842608][-conn:test::0] Notice: Loading messages in file /var/lib/aolserver/test/packages/user-tracking/catalog/user-tracking.en_US.ISO-8859-1.xml
[26/Jan/2006:08:57:48][10722.3065842608][-conn:test::0] Notice: reading /var/lib/aolserver/test/packages/user-tracking/catalog/user-tracking.es_ES.ISO-8859-1.xml in ISO-8859-1
[26/Jan/2006:08:57:48][10722.3065842608][-conn:test::0] Notice: Loading messages in file /var/lib/aolserver/test/packages/user-tracking/catalog/user-tracking.es_ES.ISO-8859-1.xml NOTICE:  adding missing FROM-clause entry for table "acs_object_id_seq" CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at select into variables PL/pgSQL function "apm__register_parameter" line 18 at assignment
[26/Jan/2006:08:57:52][10722.3065842608][-conn:test::0] Notice: <p>Installed User Tracking, version 0.1d3.</p>
[26/Jan/2006:08:57:52][10722.3065842608][-conn:test::0] Notice: <p>Package enabled.
[26/Jan/2006:08:57:52][10722.3065842608][-conn:test::0] Notice: apm_invoke_callback_proc: invoking callback after-install with command user-tracking::apm_callbacks::package_install
[26/Jan/2006:08:57:52][10722.3065842608][-conn:test::0] Error: Ns_PgExec: result status: 7 message: ERROR:  duplicate key violates unique constraint "site_nodes_un" CONTEXT:  PL/pgSQL function "site_node__new" line 32 at SQL statement
[26/Jan/2006:08:57:52][10722.3065842608][-conn:test::0] Notice: <p> Mounted an instance of the package at /user-tracking </p>
[26/Jan/2006:08:57:53][10722.3064789936][-conn:test::1] Error: invalid command name "log_user_id" invalid command name "log_user_id"    while executing "log_user_id preauth"
[26/Jan/2006:08:57:53][10722.3063737264][-conn:test::2] Error: invalid command name "log_user_id" invalid command name "log_user_id"    while executing "log_user_id preauth"
[26/Jan/2006:08:58:16][10722.3062684592][-conn:test::3] Error: invalid command name "log_user_id" invalid command name "log_user_id"    while executing "log_user_id preauth"
[26/Jan/2006:08:58:16][10722.3061631920][-conn:test::4] Error: invalid command name "log_user_id" invalid command name "log_user_id"    while executing "log_user_id preauth"

Thanks in advance.

Collapse
Posted by David Ortega on
Hi Alberto,

You can find more info about user-tracking in the next thread:

http://www.openacs.org/forums/message-view?message_id=341098

There's a link to a pdf document in which you can see how you can solve some common problems with the installation of the package

Regards,

David

Collapse
Posted by Alberto Garcia on
Hi David,

Thank you for your answer. It really helped.
Now the user-trackig package is working fine. The only "problem" is that i have type the direct url (http://server:8000/user-tracking) to access atatistics, because i can't find any menu to access this page. Perphaps something was missing in the the installation.

Regards, Alberto.

Hi again,

Have you already installed the packages: dotlrn-user-tracking and user-tracking-portlet?

Regards,

David

Hi David,

No, i don't.
Where are those packages?
i installed the package from:

* Main Site »
* Site-Wide Administration »
* Install Software

and -> install from repository.

When the list of available packages appears, i can't find those packages you are talking about. I guess i have to download them manually. is'n it?

Where can i find those packages?

Regards, alberto.

Collapse
Posted by David Ortega on
Since they are services, once you have selected "install from repository" you should click in the

Type-->Service option

Then you should see the two packages:

dotLRN UserTracking Management Applet 0.1d2
UserTracking Portlet 0.1d2

Hope it helps. Regards,

David

Collapse
Posted by Alberto Garcia on
No, i can't see any of the two services in the list. i've been looking for them in "services" and in "application" type. is it possible to download and install them manually? Regards, Alberto.
Hi Alberto:

You can install the dotlrn-user-tracking manually by the cvs:

cvs -d :pserver:mailto:anonymous@cvs.openacs.org/cvsroot co -r oacs-5-2 dotlrn-user-tracking

Regards,

Veronica