9 Mar
2006
9 Mar
'06
7:14 p.m.
Hi all,
Having this error come up after following all of the instructions and troubleshooting.
Function aggregate_methods() doesn't exists. Try install Classkit extension.
http://pecl.php.net/package/classkit
I am running FC4 with php, php-mysql, php-devel, php-pear, and mysql all installed with
yum from the default repositories.
I went ahead and put the serweb folder in my /var/www/html directory to see if I could get
it working with the intent of moving it and setting up an alias later.
Here are some snippets of my many different configuration files.
_php.ini:_
extension_dir = "/usr/lib/php/modules"
extension=classkit.so
-- also the mysql.so files are loaded from the /etc/php directory
_config_data_layer.php_
$config->data_sql->type="mysql"; //type of db host, enter
"mysql" for MySQL or "pgsql" for PostgreSQL
$i=0;
$config->data_sql->host[$i]['host']="localhost"; //database host
$config->data_sql->host[$i]['port']=""; //database port - leave
empty for default
$config->data_sql->host[$i]['name']="ser"; //database name
$config->data_sql->host[$i]['user']="ser"; //database conection
user
$config->data_sql->host[$i]['pass']="******"; //database
conection password
_config_paths.ini_
$config->root_path="/serweb/html/";
/* roo uri of your server */
if (isset($_SERVER['rcsip.myservername.ext']))
$config->root_uri="http://".$_SERVER['rcsip.myservername.ext'];
else
$config->root_uri="";
_php.conf_
LoadModule php5_module modules/libphp5.so
AddHandler php5-script .php .phtml
AddType text/html .php .phtml
DirectoryIndex index.php
_ser.cfg_
debug=3 # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
#alias=tcp:myip:5060
#alias=udp:myip:5060
#check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"
# ------------------ module loading ----------------------------------
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so"
loadmodule "/usr/local/lib/ser/modules/domain.so"
loadmodule "/usr/local/lib/ser/modules/nathelper.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db|domain|uri_db|usrloc", "db_url",
"mysql://ser:******@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("nathelper", "rtpproxy_disable", 0)
modparam("nathelper", "natping_interval", 30)
modparam("usrloc", "db_mode", 2)
modparam("registrar", "nat_flag", 6)
modparam("rr", "enable_full_lr", 1)
9 Mar
9 Mar
11:27 p.m.
try downgrade to php4,
step by step:http://www.mjmwired.net/resources/mjm-php4-fc4.html
~Ofer
On Thu, 2006-03-09 at 11:14 -0700, George Lambson wrote:
Hi all,
Having this error come up after following all of the instructions and troubleshooting.
Function aggregate_methods() doesn't exists. Try install Classkit extension.
http://pecl.php.net/package/classkit
I am running FC4 with php, php-mysql, php-devel, php-pear, and mysql all installed with
yum from the default repositories.
I went ahead and put the serweb folder in my /var/www/html directory to see if I could
get it working with the intent of moving it and setting up an alias later.
Here are some snippets of my many different configuration files.
_php.ini:_
extension_dir = "/usr/lib/php/modules"
extension=classkit.so
-- also the mysql.so files are loaded from the /etc/php directory
_config_data_layer.php_
$config->data_sql->type="mysql"; //type of db host, enter
"mysql" for MySQL or "pgsql" for PostgreSQL
$i=0;
$config->data_sql->host[$i]['host']="localhost"; //database host
$config->data_sql->host[$i]['port']=""; //database port -
leave empty for default
$config->data_sql->host[$i]['name']="ser"; //database name
$config->data_sql->host[$i]['user']="ser"; //database conection
user
$config->data_sql->host[$i]['pass']="******"; //database
conection password
_config_paths.ini_
$config->root_path="/serweb/html/";
/* roo uri of your server */
if (isset($_SERVER['rcsip.myservername.ext']))
$config->root_uri="http://".$_SERVER['rcsip.myservername.ext'];
else
$config->root_uri="";
_php.conf_
LoadModule php5_module modules/libphp5.so
AddHandler php5-script .php .phtml
AddType text/html .php .phtml
DirectoryIndex index.php
_ser.cfg_
debug=3 # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
#alias=tcp:myip:5060
#alias=udp:myip:5060
#check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"
# ------------------ module loading ----------------------------------
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so"
loadmodule "/usr/local/lib/ser/modules/domain.so"
loadmodule "/usr/local/lib/ser/modules/nathelper.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db|domain|uri_db|usrloc", "db_url",
"mysql://ser:******@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("nathelper", "rtpproxy_disable", 0)
modparam("nathelper", "natping_interval", 30)
modparam("usrloc", "db_mode", 2)
modparam("registrar", "nat_flag", 6)
modparam("rr", "enable_full_lr", 1)
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
10 Mar
10 Mar
8:52 a.m.
Hi,
is the classkit extension realy loaded? Are there any errors in php log
or appache log?
Karel
George Lambson napsal(a):
Hi all,
Having this error come up after following all of the instructions and troubleshooting.
Function aggregate_methods() doesn't exists. Try install Classkit extension.
http://pecl.php.net/package/classkit
I am running FC4 with php, php-mysql, php-devel, php-pear, and mysql all installed with
yum from the default repositories.
I went ahead and put the serweb folder in my /var/www/html directory to see if I could
get it working with the intent of moving it and setting up an alias later.
Here are some snippets of my many different configuration files.
_php.ini:_
extension_dir = "/usr/lib/php/modules"
extension=classkit.so
-- also the mysql.so files are loaded from the /etc/php directory
_config_data_layer.php_
$config->data_sql->type="mysql"; //type of db host, enter
"mysql" for MySQL or "pgsql" for PostgreSQL
$i=0;
$config->data_sql->host[$i]['host']="localhost"; //database host
$config->data_sql->host[$i]['port']=""; //database port -
leave empty for default
$config->data_sql->host[$i]['name']="ser"; //database name
$config->data_sql->host[$i]['user']="ser"; //database conection
user
$config->data_sql->host[$i]['pass']="******"; //database
conection password
_config_paths.ini_
$config->root_path="/serweb/html/";
/* roo uri of your server */
if (isset($_SERVER['rcsip.myservername.ext']))
$config->root_uri="http://".$_SERVER['rcsip.myservername.ext'];
else
$config->root_uri="";
_php.conf_
LoadModule php5_module modules/libphp5.so
AddHandler php5-script .php .phtml
AddType text/html .php .phtml
DirectoryIndex index.php
_ser.cfg_
debug=3 # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no # (cmd line: -E)
/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/
#alias=tcp:myip:5060
#alias=udp:myip:5060
#check_via=no # (cmd. line: -v)
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:heslo@localhost/ser"
# ------------------ module loading ----------------------------------
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/uri_db.so"
loadmodule "/usr/local/lib/ser/modules/domain.so"
loadmodule "/usr/local/lib/ser/modules/nathelper.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db|domain|uri_db|usrloc", "db_url",
"mysql://ser:******@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("nathelper", "rtpproxy_disable", 0)
modparam("nathelper", "natping_interval", 30)
modparam("usrloc", "db_mode", 2)
modparam("registrar", "nat_flag", 6)
modparam("rr", "enable_full_lr", 1)
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
12:31 p.m.
New subject: [Serusers] serrweb regex problem
Hello to all
I installed the last serweb, but I had one problem registering users.
When the users receive the confirmation email, they have to go to the
confirmation link, and this confirmation link does this select in the DB:
select max(abs(username)) from aliases where domain='mydomain.pt' and
username REGEXP "[0-9]+$";
ERROR: syntax error at or near "REGEXP" at character 79
LINE 1: ...om aliases where domain='mydomain.pt' and username REGEXP "[0...
^
(the ^ is under REGEXP)
I m using PostgreSQL 8.0.0, and I believe the problem is with the
postgres support of REGEXP...
I googled and googled and I didnt found a solution yet.
Did anyone had this problem too?
Thanks
Joao Pereira
6:24 p.m.
New subject: [Serusers] serrweb regex problem
Hi,
sorry, but support for postgres is only experimental and not working
well in last stable version of serweb.
Real support for postgres will be ready in next version.
regards Karel
Joao Pereira napsal(a):
Hello to all
I installed the last serweb, but I had one problem registering users.
When the users receive the confirmation email, they have to go to the
confirmation link, and this confirmation link does this select in the DB:
select max(abs(username)) from aliases where domain='mydomain.pt' and
username REGEXP "[0-9]+$";
ERROR: syntax error at or near "REGEXP" at character 79
LINE 1: ...om aliases where domain='mydomain.pt' and username REGEXP "[0...
^
(the ^ is under REGEXP)
I m using PostgreSQL 8.0.0, and I believe the problem is with the
postgres support of REGEXP...
I googled and googled and I didnt found a solution yet.
Did anyone had this problem too?
Thanks
Joao Pereira
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
11 Mar
11 Mar
8:14 p.m.
New subject: [Serusers] serrweb regex problem
Ok, then what version of serweb is having less problems with PostgreSQL?
Or I can try changing this query:
select max(abs(username)) from aliases where domain='mydomain.pt' and
username REGEXP "^[0-9]+$"
to something more "postgre like".
But I cant find it in the code... where are the SQL querys in the serweb
code?
Thanks
Joao Pereira
Karel Kozlik wrote:
Hi,
sorry, but support for postgres is only experimental and not working
well in last stable version of serweb.
Real support for postgres will be ready in next version.
regards Karel
Joao Pereira napsal(a):
> Hello to all
> I installed the last serweb, but I had one problem registering users.
> When the users receive the confirmation email, they have to go to the
> confirmation link, and this confirmation link does this select in the DB:
>
> select max(abs(username)) from aliases where domain='mydomain.pt' and
> username REGEXP "[0-9]+$";
>
> ERROR: syntax error at or near "REGEXP" at character 79
> LINE 1: ...om aliases where domain='mydomain.pt' and username REGEXP
> "[0...
>
> ^
>
> (the ^ is under REGEXP)
>
> I m using PostgreSQL 8.0.0, and I believe the problem is with the
> postgres support of REGEXP...
> I googled and googled and I didnt found a solution yet.
> Did anyone had this problem too?
> Thanks
> Joao Pereira
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
13 Mar
13 Mar
8:59 a.m.
New subject: [Serusers] serrweb regex problem
Joao Pereira napsal(a):
Ok, then what version of serweb is having less
problems with PostgreSQL?
You can try version from CVS. But you have to use also SER from CVS. New
serweb is not backward compatible with SER 0.9.x - DB schema has been
changed.
Or I can try changing this query:
select max(abs(username)) from aliases where domain='mydomain.pt' and
username REGEXP "^[0-9]+$"
to something more "postgre like".
But I cant find it in the code... where are the SQL querys in the serweb
code?
The SQL queries are in files in data_layer directory. If you enable
logging in serweb you should see location of query in log file.
But change of this one query do not solve your problem. There are more
queries which not work in postgres.
Karel
Thanks
Joao Pereira
Karel Kozlik wrote:
Hi,
sorry, but support for postgres is only experimental and not working
well in last stable version of serweb.
Real support for postgres will be ready in next version.
regards Karel
Joao Pereira napsal(a):
> Hello to all
> I installed the last serweb, but I had one problem registering users.
> When the users receive the confirmation email, they have to go to the
> confirmation link, and this confirmation link does this select in the
> DB:
>
> select max(abs(username)) from aliases where domain='mydomain.pt' and
> username REGEXP "[0-9]+$";
>
> ERROR: syntax error at or near "REGEXP" at character 79
> LINE 1: ...om aliases where domain='mydomain.pt' and username REGEXP
> "[0...
>
> ^
>
> (the ^ is under REGEXP)
>
> I m using PostgreSQL 8.0.0, and I believe the problem is with the
> postgres support of REGEXP...
> I googled and googled and I didnt found a solution yet.
> Did anyone had this problem too?
> Thanks
> Joao Pereira
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
6838
days inactive
6842
days old
6 comments
4 participants
participants (4)
-
George Lambson -
Joao Pereira -
Karel Kozlik -
O.