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_chanztc_confno > ztc_confmode flag > 6 50 Zap/2-1 17 2 1023772 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
i checked postgres logfile. it says ERROR: LIMIT #,# syntax not supported. Use separate LIMIT and OFFSET clauses. -Original Message- From: Martin List-Petersen [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 3:53 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Cc: [EMAIL PROTECTED] 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_chanztc_confno > ztc_confmode flag > 6 50 Zap/2-1 17 2 1023772 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
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:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 3:53 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Cc: [EMAIL PROTECTED] > 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_chanztc_confno > > ztc_confmodeflag > > 6 50 Zap/2-1 17 2 1023772 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
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:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 10:38 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Cc: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 3:53 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Cc: [EMAIL PROTECTED] > 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_chanztc_confno > > ztc_confmodeflag > > 6 50 Zap/2-1 17 2 1023772 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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
On Mon, 2004-11-15 at 21:52, Jens Hansen wrote: > 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 > Sorry, i might not have stated it quite clearly: It is probably a but in the Meetme2 Webinterface. Check the queries, that it runs and try to remove the LIMIT part. -- Slán lait, Martin List-Petersen Dublin, Eire (contact info on --> http://www.marlow.dk/) > -Original Message- > From: Martin List-Petersen [mailto:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 10:38 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Cc: [EMAIL PROTECTED] > Subject: RE: [Asterisk-Users] Meetme2 - web interface not working > > Postgresql is correct there :oP. > > LIMIT is a mysql specific SQL statement. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
ahh, i see. but that's too much for me, i am not good in php. thanks anyway jens -Original Message- From: Martin List-Petersen [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 11:02 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Cc: [EMAIL PROTECTED] Subject: RE: [Asterisk-Users] Meetme2 - web interface not working On Mon, 2004-11-15 at 21:52, Jens Hansen wrote: > 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 > Sorry, i might not have stated it quite clearly: It is probably a but in the Meetme2 Webinterface. Check the queries, that it runs and try to remove the LIMIT part. -- Slán lait, Martin List-Petersen Dublin, Eire (contact info on --> http://www.marlow.dk/) > -Original Message- > From: Martin List-Petersen [mailto:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 10:38 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Cc: [EMAIL PROTECTED] > Subject: RE: [Asterisk-Users] Meetme2 - web interface not working > > Postgresql is correct there :oP. > > LIMIT is a mysql specific SQL statement. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Meetme2 - web interface not working
Jens Hansen wrote: ahh, i see. but that's too much for me, i am not good in php. Does the error give you a file name and line number? If so, post the line here and someone will tell you what to change it to. -- Cheers, Matt Riddell ___ http://www.sineapps.com/news.php (Daily Asterisk News - html) http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
no, all i got is posted -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Riddell Sent: Monday, November 15, 2004 11:06 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Meetme2 - web interface not working Jens Hansen wrote: > ahh, i see. > but that's too much for me, i am not good in php. Does the error give you a file name and line number? If so, post the line here and someone will tell you what to change it to. -- Cheers, Matt Riddell ___ http://www.sineapps.com/news.php (Daily Asterisk News - html) http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Meetme2 - web interface not working
On Mon, 2004-11-15 at 22:06, Matt Riddell wrote: > Jens Hansen wrote: > > ahh, i see. > > but that's too much for me, i am not good in php. > > Does the error give you a file name and line number? > > If so, post the line here and someone will tell you what to change it to. He's getting the error in the postgresql logs, not in the Meetme2 interface. Meetme2 just seems to ignore the fact, that it is sending non-compliant SQL queries. I might have a look at it tonight and post, what he has to change, since i have Meetme2 installed (just running it of MySQL, so i don't have that trouble). Slán lait, Martin List-Petersen Dublin, Eire (contact info on --> http://www.marlow.dk/) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Meetme2 - web interface not working
Thanks for your help. I solved it by switching to mysql. Since i got both of them running it was no problem. Jens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin List-Petersen Sent: Monday, November 15, 2004 11:32 PM To: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Meetme2 - web interface not working On Mon, 2004-11-15 at 22:06, Matt Riddell wrote: > Jens Hansen wrote: > > ahh, i see. > > but that's too much for me, i am not good in php. > > Does the error give you a file name and line number? > > If so, post the line here and someone will tell you what to change it to. He's getting the error in the postgresql logs, not in the Meetme2 interface. Meetme2 just seems to ignore the fact, that it is sending non-compliant SQL queries. I might have a look at it tonight and post, what he has to change, since i have Meetme2 installed (just running it of MySQL, so i don't have that trouble). Slán lait, Martin List-Petersen Dublin, Eire (contact info on --> http://www.marlow.dk/) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Meetme2 - web interface not working
Jens Hansen wrote: Thanks for your help. I solved it by switching to mysql. Since i got both of them running it was no problem. Jens Cool. However, we may as well fix it. Who maintains it? -- Cheers, Matt Riddell ___ http://www.sineapps.com/news.php (Daily Asterisk News - html) http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Meetme2 - web interface not working
On Tue, 2004-11-16 at 09:10, Matt Riddell wrote: > Jens Hansen wrote: > > Thanks for your help. > > > > I solved it by switching to mysql. Since i got both of them running it was > > no problem. > > > > Jens > > Cool. However, we may as well fix it. > > Who maintains it? Arezqui Belaïd seems to be the one maintaining it. Download is done from: http://www.areski.net/asterisk-meetme/about.php?s=0 Hi Arezqui, could you please have a look at MeetMe2 ? It seems that the Webinterface is using "LIMIT" in the SQL queries, even when you switch to postgresql (and that of course doesn't work). So Users won't show up in the rooms. Besides that, find attached the patch to make it compile with Asterisk 1.0.2. Slán leat, Martin List-Petersen Dublin, Eire (contact info on --> http://www.marlow.dk/) --- app_meetme2.c 2004-04-07 12:37:18.0 +0100 +++ /home/marlow/app_meetme2.c 2004-11-16 16:10:08.0 + @@ -643,7 +643,7 @@ } *confs; -static ast_mutex_t conflock = AST_MUTEX_INITIALIZER; +AST_MUTEX_DEFINE_STATIC(conflock); #include "enter.h" #include "leave.h" @@ -1545,7 +1545,7 @@ }else{ if (chan->_state != AST_STATE_UP) ast_answer(chan); - res = ast_say_number(chan, cnt, "", chan->language); + res = ast_say_number(chan, cnt, "", chan->language, (char *) NULL); } LOCAL_USER_REMOVE(u); return res; ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users