[Serusers] serweb login

[Jan Janak]

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 at 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 at yahoo.com 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers