[Asterisk-Users] Meetme2 - web interface not working

[Jens Hansen]

yes, i have set

define ("DB_TYPE", "postgres"); // mysql or postgres

in defines.php

and i have set 

dbtype=postgres

in meetme2.conf.

and the entry is showing up in my postgres db

-----Original Message-----
From: Martin List-Petersen [mailto:martin+asterisk at list-petersen.net] 
Sent: Monday, November 15, 2004 10:38 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Cc: mailinglists at eminenz.ath.cx
Subject: RE: [Asterisk-Users] Meetme2 - web interface not working

Postgresql is correct there :oP.

LIMIT is a mysql specific SQL statement. 

-- 
Slán lait,
Martin List-Petersen
Dublin, Eire 
(contact info on --> http://www.marlow.dk/)

On Mon, 2004-11-15 at 21:20, Jens Hansen wrote:
> i checked postgres logfile. it says
> 
> ERROR:  LIMIT #,# syntax not supported.
>         Use separate LIMIT and OFFSET clauses.
> 
> -----Original Message-----
> From: Martin List-Petersen [mailto:martin+asterisk at list-petersen.net] 
> Sent: Monday, November 15, 2004 3:53 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Cc: mailinglists at eminenz.ath.cx
> Subject: Re: [Asterisk-Users] Meetme2 - web interface not working
> 
> On Mon, 2004-11-15 at 08:45, Jens Hansen wrote:
> > I got the asterisk-part working, when i join a conference, i can see the
> > entry created in my pgsql database using webmin.
> > it looks like:
> > 
> > -------
> > Table meetme_user in database meetme
> > user_id 	confno 	chan_name 	fd 	ztc_chan 	ztc_confno
> > ztc_confmode 	flag
> > 	6 	50 	Zap/2-1 	17 	2 	1023 	772 	0
> > ---------
> > 
> > but when enter conference room 50 in web interface (did setup
defines.php
> of
> > course) - i always get "No user in this conference room." - no error or
> > whatsoe
> > 
> > apache 2
> > PHP Version 4.3.3
> > register_globals = on
> > Asterisk 1.0.2-BRIstuffed-0.2.0-RC2
> > 
> > What can i try?
> 
> I would check the connection between your asterisk and the database. 
> 
> I've got MeetMe2 running on the exact same version, just with mysql
> instead of postgresql and saw the same thing in the beginning. In the
> end MeetMe2 just never got a connect to the database due to a typo in
> the configuration.
> 
> Check if MeetMe2 is sending queries at all to the SQL server.
> 
> Kind regards,
> Martin List-Petersen
> Dublin, Eire