headers
P.A.J.Saunders | 1 Jul 2003 16:05
Picon
Favicon

mrbs bug and postgresql 7.3 problem

Firstly, i noticed in my php logs i was getting the error 

PHP Notice:  Undefined variable:  twentyfourhourformat in 
/web/cs/docs/mrbs/web/edit_entry_handler.php on line 61

I think the line 

if (!$twentyfourhourformat)

should be

if (!$twentyfourhour_format)

(I've assumed this is supposed to be set from the config.inc)

Secondly, i appear to be having problems getting this to work on postgresql 
7.3.3

When creating the database using the supplied tables.pg.sql i get a few 
notices, followed by this error :

psql:tables.pg.sql:57: NOTICE:  CREATE TABLE will create implicit sequence 
'mrbs_repeat_id_seq' for SERIAL column 'mrbs_repeat.id'
psql:tables.pg.sql:57: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
implicit index 'mrbs_repeat_pkey' for table 'mrbs_repeat'
psql:tables.pg.sql:57: ERROR:  pg_atoi: zero-length string

Unfortuantly, i do not appear to be able to create reoccuring events, and so 
i'm assuming this is the problem. Is there any known solution to this?
(Continue reading)

Permalink | Reply | 9 comments |
headers
Stuart Perryman | 2 Jul 2003 16:10
Picon
Favicon

NT Authentication

Hi,

I have just installed mrbs and had a few problems with authentication. I
finally got the ip auth running but read in the list archives about two
other types namely auth_nt and auth_user

Can anyone tell me where to find these. Someone did mention to search
the archives but I have yet to find where I can perform such a search. I
would be grateful for any help as to the whereabouts of the files and as
to how to search the archives.

Thanks in advance

Stuart

--

Stuart Perryman
Senior Systems Engineer
Spaceflight Engineering Support Services

Tel: +49 (0)8153 28 1530
Fax: +49 (0)8153 28 1451

Mobile: +49 (0)179 5133780
Permalink | Reply | 0 comments |
headers
Markus Flaig | 2 Jul 2003 16:09

ip authentication seems not to work properly

hi there,

i am using mrbs-cvs in our company. we are having 3 showrooms and
everything is quite nice just the adminitrator authentication doesn't
work.

i am using the "ip" authentication method, and i have added some
administrators.

a snipplet from the config file:

# IP authentication allows any user to create bookings.
$auth["realm"]  = "";
$auth["type"]   = "ip";
$auth["prog"]   = "";
$auth["params"] = "";

$auth["admin"][] = "192.168.0.1";
$auth["admin"][] = "192.168.0.3";
$auth["admin"][] = "192.168.6.113";
$auth["admin"][] = "192.168.6.107";
$auth["admin"][] = "192.168.6.123";
$auth["admin"][] = "192.168.6.163";

now my problem is, the 192.168.0.1 and .3 computers are allowed to log
in as administrators but the 6.x computers are not allowed to do so.

what's the reason for this?

i can't change the ips, cause we have 6.x and 7.x ranges in our lan and
(Continue reading)

Permalink | Reply | 1 comment |
headers
Lewis Franklin | 2 Jul 2003 16:35

Updates

To any project developers,

I am a fellow programmer, currently working on another SourceForge 
project (InfoCentral). We are looking at integrating your system into 
our program. I am sure in the process I will have to modify and update 
the program and imagine that some bugfixes will occur. I was wondering 
if you would like for me to interface those changes with you all in any 
way. Thank you for your time.

Sincerely,
Lewis Franklin
lewis <at> franklin.org
Permalink | Reply | 0 comments |
headers
roger koh | 2 Jul 2003 16:36
Picon
Favicon

Re: Advertising Slot Management System available

Hello all,

I wonder if the following method can be used for the
purpose.
room       lab1 lab2 lab3

Time
0720-0755
0800-0825
0830-0855
0900-0925

" case starttime:
     "7:30" : displaystarttime="7:20";
     "8:00" : displaystarttime="7:55";
 end"

Any one have ideas on this .Thank you

regards
roger

--- Steve Purkiss <steve <at> purkiss.com> wrote: > Hi
Roger,
> 
> I just changed the timeslots from half hour ones to
> one for all the day -
> you just change the frequency in the settings. On
> first thinking about it, I
> would say you could change the format of the display
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Beranek | 2 Jul 2003 16:37
Picon
Favicon

Re: mrbs bug and postgresql 7.3 problem

P.A.J.Saunders wrote:
> Firstly, i noticed in my php logs i was getting the error 
> 
> PHP Notice:  Undefined variable:  twentyfourhourformat in 
> /web/cs/docs/mrbs/web/edit_entry_handler.php on line 61
> 
> I think the line 
> 
> if (!$twentyfourhourformat)
> 
> should be
> 
> if (!$twentyfourhour_format)
> 
> (I've assumed this is supposed to be set from the config.inc)

This is fixed in CVS.

> Secondly, i appear to be having problems getting this to work on postgresql 
> 7.3.3
> 
> When creating the database using the supplied tables.pg.sql i get a few 
> notices, followed by this error :
> 
> psql:tables.pg.sql:57: NOTICE:  CREATE TABLE will create implicit sequence 
> 'mrbs_repeat_id_seq' for SERIAL column 'mrbs_repeat.id'
> psql:tables.pg.sql:57: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
> implicit index 'mrbs_repeat_pkey' for table 'mrbs_repeat'
> psql:tables.pg.sql:57: ERROR:  pg_atoi: zero-length string
(Continue reading)

Permalink | Reply | 8 comments |
headers
John Beranek | 2 Jul 2003 16:41
Picon
Favicon

Re: ip authentication seems not to work properly

Markus Flaig wrote:

> hi there,
> 
> i am using mrbs-cvs in our company. we are having 3 showrooms and
> everything is quite nice just the adminitrator authentication doesn't
> work.
> 
> i am using the "ip" authentication method, and i have added some
> administrators.
> 
> a snipplet from the config file:
> 
> # IP authentication allows any user to create bookings.
> $auth["realm"]  = "";
> $auth["type"]   = "ip";
> $auth["prog"]   = "";
> $auth["params"] = "";
> 
> $auth["admin"][] = "192.168.0.1";
> $auth["admin"][] = "192.168.0.3";
> $auth["admin"][] = "192.168.6.113";
> $auth["admin"][] = "192.168.6.107";
> $auth["admin"][] = "192.168.6.123";
> $auth["admin"][] = "192.168.6.163";
> 
> now my problem is, the 192.168.0.1 and .3 computers are allowed to log
> in as administrators but the 6.x computers are not allowed to do so.
> 
> what's the reason for this?
(Continue reading)

Permalink | Reply | 0 comments |
headers
Henrik Edlund | 2 Jul 2003 16:44
Picon
Picon
Picon
Favicon

Re: mrbs bug and postgresql 7.3 problem

On Wed, 2 Jul 2003, John Beranek wrote:

JB> > psql:tables.pg.sql:57: ERROR:  pg_atoi: zero-length string
JB>
JB> Hmm, sorry, I'm not very knowledgeable on Postgresql...don't know what
JB> all of that means...sorry.

Since PostgreSQL 7.3 the empty string is no longer considered the value 0.
This was some ugly thing from the past. MySQL still thinks it is that way.

The default value for one INTEGER column is '' in one place. Change that
to 0 instead and it should work.

What it is trying to do above to convert the ascii string to an integer,
but fails as the string is empty, of zero-length.

I don't know who came up with the stupid idea of using empty string as
default values for integer columns.

Henrik
Permalink | Reply | 7 comments |
headers
John Beranek | 2 Jul 2003 16:44
Picon
Favicon

Re: logout problem

Joseph S Chung wrote:

> Maybe my question looks silly...would somebody please tell me how to logout
> the system?

I did write a logout function for MRBS, but didn't check it in, because 
it's far from flawless. There's a basic problem in getting all browsers 
to logout of a basic authentication realm.

If anyone can tell me the appropriate PHO to make it work (for all 
browsers) then I'll happily try to put it into MRBS... :)

John. (Part-time MRBS admin/developer)

--

-- 
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake
Permalink | Reply | 1 comment |
headers
John Beranek | 2 Jul 2003 16:45
Picon
Favicon

Re: installation

Mister X wrote:

> Hi !
>  
> Is there an installation-guide for MRBS in german available?

Sorry, no. There's only an English installation guide.

John (Part-time MRBS admnin/developer)

--

-- 
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake
Permalink | Reply | 0 comments |

Gmane