harry gaillac wrote:
hello,
use database apache serweb logs to find problem --- Chris Mason lists@masonc.com a écrit :
Harry: I found the problem as shown below. The applicication is reuqesting a column that does not exist in the database. I checked the contents of scripts/ser_mysql.sh from ser-0.9.3_src.tar.gz ftp://ftp.berlios.de/pub/ser/0.9.3/src/ser-0.9.3_src.tar.gz and find that column does not exist in the subscriber table. There's no way I can get it to work. Is the ser distribution broken or the serweb?
Chris
Query as executed by user ser
####################################################################### mysql> select phplib_id from subscriber where username='admin' and password='heslo' and perms='admin' and domain='mason.home' -> ; ERROR 1054 (42S22): Unknown column 'perms' in 'where clause'
####################################################################### create table statement from scripts/ser_mysql.sh #######################################################################
# # Table structure for table 'subscriber' -- user database #
CREATE TABLE subscriber ( phplib_id varchar(32) NOT NULL default '', $USERCOL varchar(64) NOT NULL default '', domain varchar(128) NOT NULL default '', password varchar(25) NOT NULL default '', first_name varchar(25) NOT NULL default '', last_name varchar(45) NOT NULL default '', phone varchar(15) NOT NULL default '', email_address varchar(50) NOT NULL default '', datetime_created datetime NOT NULL default '0000-00-00 00:00:00', datetime_modified datetime NOT NULL default '0000-00-00 00:00:00', confirmation varchar(64) NOT NULL default '', flag char(1) NOT NULL default 'o', sendnotification varchar(50) NOT NULL default '', greeting varchar(50) NOT NULL default '', ha1 varchar(128) NOT NULL default '', ha1b varchar(128) NOT NULL default '', allow_find char(1) NOT NULL default '0', timezone varchar(128) default NULL, rpid varchar(128) default NULL, domn int(10) default NULL, uuid varchar(64) default NULL, UNIQUE KEY phplib_id (phplib_id), PRIMARY KEY ($USERCOL, domain), KEY user_2 ($USERCOL) ) $TABLE_TYPE;
What version of serweb are you using ? I would recommend to get it from ftp://ftp.berlios.de/pub/ser/0.9.3/contrib
There is a matching serweb version in that directory.
Jan.
On 09-07-2005 09:09, Chris Mason (Lists) wrote:
harry gaillac wrote:
hello,
use database apache serweb logs to find problem --- Chris Mason lists@masonc.com a écrit :
Harry: I found the problem as shown below. The applicication is reuqesting a column that does not exist in the database. I checked the contents of scripts/ser_mysql.sh from ser-0.9.3_src.tar.gz ftp://ftp.berlios.de/pub/ser/0.9.3/src/ser-0.9.3_src.tar.gz and find that column does not exist in the subscriber table. There's no way I can get it to work. Is the ser distribution broken or the serweb?
Chris
Query as executed by user ser
####################################################################### mysql> select phplib_id from subscriber where username='admin' and password='heslo' and perms='admin' and domain='mason.home' -> ; ERROR 1054 (42S22): Unknown column 'perms' in 'where clause'
####################################################################### create table statement from scripts/ser_mysql.sh #######################################################################
# # Table structure for table 'subscriber' -- user database #
CREATE TABLE subscriber ( phplib_id varchar(32) NOT NULL default '', $USERCOL varchar(64) NOT NULL default '', domain varchar(128) NOT NULL default '', password varchar(25) NOT NULL default '', first_name varchar(25) NOT NULL default '', last_name varchar(45) NOT NULL default '', phone varchar(15) NOT NULL default '', email_address varchar(50) NOT NULL default '', datetime_created datetime NOT NULL default '0000-00-00 00:00:00', datetime_modified datetime NOT NULL default '0000-00-00 00:00:00', confirmation varchar(64) NOT NULL default '', flag char(1) NOT NULL default 'o', sendnotification varchar(50) NOT NULL default '', greeting varchar(50) NOT NULL default '', ha1 varchar(128) NOT NULL default '', ha1b varchar(128) NOT NULL default '', allow_find char(1) NOT NULL default '0', timezone varchar(128) default NULL, rpid varchar(128) default NULL, domn int(10) default NULL, uuid varchar(64) default NULL, UNIQUE KEY phplib_id (phplib_id), PRIMARY KEY ($USERCOL, domain), KEY user_2 ($USERCOL) ) $TABLE_TYPE;
-- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 Cell: 264-235-5670 Yahoo IM: netconcepts_anguilla@yahoo.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
sql file provide in contrib don't match with ser-0.9.3 sql scheme. serweb provide config_data_layer.php that don't match with ser db.
I downloaded ser-0.9.3 serweb-0.9.3 serweb both config_data_layer.php and sql files provide data for table 'preferences_types'
Harry --- Jan Janak jan@iptel.org a écrit :
What version of serweb are you using ? I would recommend to get it from ftp://ftp.berlios.de/pub/ser/0.9.3/contrib
There is a matching serweb version in that directory.
Jan.
On 09-07-2005 09:09, Chris Mason (Lists) wrote:
harry gaillac wrote:
hello,
use database apache serweb logs to find problem --- Chris Mason lists@masonc.com a écrit :
Harry: I found the problem as shown below. The
applicication is reuqesting a
column that does not exist in the database. I
checked the contents of
scripts/ser_mysql.sh from ser-0.9.3_src.tar.gz
ftp://ftp.berlios.de/pub/ser/0.9.3/src/ser-0.9.3_src.tar.gz
and find
that column does not exist in the subscriber
table. There's no way I can
get it to work. Is the ser distribution broken or
the serweb?
Chris
Query as executed by user ser
#######################################################################
mysql> select phplib_id from subscriber where
username='admin' and
password='heslo' and perms='admin' and
domain='mason.home'
-> ; ERROR 1054 (42S22): Unknown column 'perms' in
'where clause'
#######################################################################
create table statement from scripts/ser_mysql.sh
#######################################################################
# # Table structure for table 'subscriber' -- user
database
#
CREATE TABLE subscriber ( phplib_id varchar(32) NOT NULL default '', $USERCOL varchar(64) NOT NULL default '', domain varchar(128) NOT NULL default '', password varchar(25) NOT NULL default '', first_name varchar(25) NOT NULL default '', last_name varchar(45) NOT NULL default '', phone varchar(15) NOT NULL default '', email_address varchar(50) NOT NULL default '', datetime_created datetime NOT NULL default
'0000-00-00 00:00:00',
datetime_modified datetime NOT NULL default
'0000-00-00 00:00:00',
confirmation varchar(64) NOT NULL default '', flag char(1) NOT NULL default 'o', sendnotification varchar(50) NOT NULL default '', greeting varchar(50) NOT NULL default '', ha1 varchar(128) NOT NULL default '', ha1b varchar(128) NOT NULL default '', allow_find char(1) NOT NULL default '0', timezone varchar(128) default NULL, rpid varchar(128) default NULL, domn int(10) default NULL, uuid varchar(64) default NULL, UNIQUE KEY phplib_id (phplib_id), PRIMARY KEY ($USERCOL, domain), KEY user_2 ($USERCOL) ) $TABLE_TYPE;
-- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 Cell: 264-235-5670 Yahoo IM: netconcepts_anguilla@yahoo.com
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
On 11-07-2005 18:45, harry gaillac wrote:
sql file provide in contrib don't match with ser-0.9.3 sql scheme. serweb provide config_data_layer.php that don't match with ser db.
I downloaded ser-0.9.3 serweb-0.9.3 serweb both config_data_layer.php and sql files provide data for table 'preferences_types'
I am not sure I understand this. Could you point out what exactly is missing in ser database that serweb needs ? preferences_types table is created by ser_mysql.sh script in version 0.9.3, you can check the contents of that file on the ftp server.
Jan.
-
Chris Mason (Lists) -
harry gaillac -
Jan Janak