Re: [Gusdev-rad-issues] Oci8 and oracle

[Elisabetta M. <man...@pc...>]

As an addition, the user registration form (and mail_user_registration and 
modifyPassword) is mostly to allow external users to submit an account 
request. This form itself doesn't enter data into the db but only creates 
some xml, because before creating a new user account it is assumed that some 
manual verification and approval is needed by those maintaining the db 
instance, in your case you. (The rest of the RADSA forms 
actually enter data in the db). Typically the xml produced by the 
mail_user_registration form will necessitate manual modifications 
by the db maintainers because of this. In the upcoming RADSA 2.1.0 
release (scheduled for January) the code of this form has been 
trimmed and modified.
If you are creating accounts just for yourself to use the RADSA, you are 
better off just creating the xml directly and loading it via the plugin
GUS::Supported::Plugin::LoadGusXml.
For a given user account you can create nested xml to create the contact 
in SRes.Contact, its child in Core.UserInfo and the children of the latter 
in Core.UserProject and Core.UserGroup to link the user to whatever 
projects and groups they belong.
(Project and Groups that you guys want can be created previously using 
LoadGusXml: we typically create a "Testing" project and "Testing" group 
in addition to our regular projects and group, and all data entered under 
these project/group is considered temporary/test only.)
If you nest the UserProject and UserGroup xml within the UserInfo xml and 
the latter within the Contact xml, LoadGusXml will submit all in one 
transaction and create the appropriate foreign keys.
Finally, you should create an entry in Core.ProjectInfo whose name is 
'RAD' and then use the Rad.ProjectLink table to link to this 'RAD' project 
all contacts and other projects and groups that refer or utilize RAD.
Elisabetta

---

On Wed, 30 Nov 2005, Junmin Liu wrote:

> Hi, Juan,
>
>> directly.  When I run on the command line, the web pages seem to work just
>> fine, and I see all the HTML and javascript spit out to STDOUT, BUT I get
>> the following error in my error log:
>> 
>>    [30-Nov-2005 12:08:37] PHP Warning:  ora_getcolumn(): Ora_Fetch failed
>>    (ORA-01002: fetch out of sequence -- while processing OCI function
>>    OFETCH/OFEN) in /usr/local/apache2/htdocs/misc/user_registration.php on
>>    line 153
>> 
>
> This will be due to the bug in the code, ora_fetch will return a record 
> within the results, most likely the code assumes it return many records and 
> try to loop through it, while the correponding table you have in your 
> instance is empty, so the cursoe has o record. Then you got the "out of 
> sequence".
>
>
>> I assume this has something to do with the issues in compiling PHP with 
>> OCI8
>> and with oracle.
>> 
>> When I try to run user_registration.php from the web-browser, I get a blank
>> page, and I get the following in the error log:
>> 
>>    [30-Nov-2005 12:10:22] PHP Warning:
>>    dbConnectionSetup(/home/oracle/RADSA_2.0.0/db-include.inc) [<a
>>    href='function.dbConnectionSetup'>function.dbConnectionSetup</a>]:
>>    failed to open stream: Permission denied in
>>    /usr/local/apache2/htdocs/include/php/db.inc on line 6
>> 
>>    [30-Nov-2005 12:10:22] PHP Fatal error:  dbConnectionSetup() [<a
>>    href='function.require'>function.require</a>]: Failed opening required
>>    '/home/oracle/RADSA_2.0.0/db-include.inc'
>> ---(include_path='.:/usr/local/apache2/htdocs/include/php/:./include/php:..
>> ----/include/php') in /usr/local/apache2/htdocs/include/php/db.inc on line 
>> 6
>
> what is the permission for this file. You should let it owned by apache, set 
> it to 700 for security reason.
>
> /home/oracle/RADSA_2.0.0/db-include.inc
>
> ---junmin
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gusdev-rad-issues mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-rad-issues
>