Re: [Phpgroupware-users] Bug with Sessions

[Ruben Safir]

If your using Postgres, it would seem you need to use
the PH4 Session handling, or it will just fail.

<shrug>

Everyting seems to work now


Chris Weiss (address@hidden) wrote*:
>
>this is a new error.  The last one was in sessions not setup.
>
>I'm saying that postgres has too small of a default TEXT field size for
>phpGW, I was showing the MySQl longtext as a compaison...16k vs 4Gig.
>
>Ruben I Safir (address@hidden) wrote*:
>>
>>This is not MYSQL
>>
>>It is Postgres
>>
>>This error message:
>>
>>Database error: Invalid SQL: CREATE TABLE phpgw_config (config_app varchar
>(50), config_name varchar(255) NOT NULL, config_value varchar(100), UNIQUE
>(config_name))
>>PostgreSQL Error: 1 (ERROR: Relation 'phpgw_config' already exists )
>>
>>
>>on the setup should be handled more gracefully....
>>
>>Ruben
>>
>>On Thu, Aug 29, 2002 at 01:48:42PM +0000, Chris Weiss wrote:
>>> did you change the default size of the text datatype?
>>>
>>> in mysql the session content field is a longtext, which is L+4 bytes,
>where L
>>> < 2^32 (L being the size fo the content) or a max of 4,294,967,296 bytes
>(4.2
>>> Gig? wow).  Using the email app the session can get quite big because it's
>>> caching your mailbox to greatly improve speed.
>>>
>>> Ruben I Safir (address@hidden) wrote*:
>>> >
>>> >This is the latet pg.
>>> >
>>> >7 something.
>>> >
>>> >i just installed it by hand
>>> >
>>> >Ruben
>>> >
>>> >Should it produce such large sessions
>>> >
>>> >Ruben
>>> >
>>> >On Wed, Aug 28, 2002 at 03:59:42PM +0000, Chris Weiss wrote:
>>> >> Are you using Anglemail?  what version of Postgres?  I recall and old
>bug
>>> >> where postgres's "text" datatype had a very small default size.
>>> >>
>>> >> Ruben I Safir (address@hidden) wrote*:
>>> >> >
>>> >> >I'd like to report the following bug from PHP Groupware
>>> >> >with sessions when using mail
>>> >> >
>>> >> >The sessions is DB
>>> >> >Postgres
>>> >> >Apache 1.3x
>>> >> >
>>> >> >Mail Server qpopper
>>> >> >
>>> >> >PHPGW - latest
>>> >> >Database error: Invalid SQL: INSERT INTO phpgw_app_sessions
>>> >> (sessionid,loginid,app,location,content,session_dla) VALUES
>>> >> >
>>> >>
>>>
>(''4d68f869f2c7447905e131e3c3309a08','12','email','acctnum=0;data_name=msgball
>>> >> _list','a:2:i:1;a:4:
>>> >> {s:6:\"msgnum\";i:1252;s:6:\"folder\";s:5:\"INBOX\";s:7...continued on
>to
>>> one
>>> >> insanely long string
>>> >> >
>>> >> >PostgreSQL Error: 1 (PQsendQuery() -- query is too long. Maximum
>length is
>>> >> 16382 )
>>> >> >
>>> >>
>>File: /home/httpd/html/phpgroupware/phpgwapi/inc/class.sessions_db.inc.php
>>> >> >Line: 801
>>> >> >
>>> >> >Session halted.
>>> >> >Fatal error: Call to undefined function: parse_navbar_end()
>>> >> in /home/httpd/html/phpgroupware/phpgwapi/inc/footer.inc.php on line 62
>>> >> >
>>> >> >
>>> >> >_______________________________________________
>>> >> >Phpgroupware-users mailing list
>>> >> >address@hidden
>>> >> >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>> >> >
>>> >>
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> Phpgroupware-users mailing list
>>> >> address@hidden
>>> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>> >
>>> >
>>> >_______________________________________________
>>> >Phpgroupware-users mailing list
>>> >address@hidden
>>> >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>> >
>>>
>>>
>>>
>>> _______________________________________________
>>> Phpgroupware-users mailing list
>>> address@hidden
>>> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
--
Rosenzwieg and Maffia
Computer Infrastructure