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://%22.$_SERVER%5B%27rcsip.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)
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://%22.$_SERVER%5B%27rcsip.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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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://%22.$_SERVER%5B%27rcsip.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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers