9 Jul
2005
9 Jul
'05
3:09 p.m.
harry gaillac wrote:
hello,
use database apache serweb logs to find problem
--- Chris Mason <lists(a)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(a)yahoo.com
11 Jul
11 Jul
6:34 p.m.
New subject: [Serusers] serweb login
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(a)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(a)yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers 
6:45 p.m.
New subject: [Serusers] serweb login
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(a)iptel.org> a écrit :
#######################################################################
#######################################################################
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com
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:
<ftp://ftp.berlios.de/pub/ser/0.9.3/src/ser-0.9.3_src.tar.gz>
harry gaillac wrote:
applicication is reuqesting a
hello,
use database apache serweb logs to find problem
--- Chris Mason <lists(a)masonc.com> a écrit :
Harry:
I found the problem as shown below. The 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
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(a)yahoo.com
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
6:53 p.m.
New subject: [Serusers] serweb login
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.
7081
days inactive
7083
days old
3 comments
3 participants
participants (3)
-
Chris Mason (Lists) -
harry gaillac -
Jan Janak