[Gridsphere-users] Gridsphere initial login problem

[Stephen Gordon]

Hamish Carpenter wrote:
> You could try checking the file permissions for the default 
> (hypersonic SQL) database as we have encountered issues where it was 
> owned by root but gridsphere was running as the tomcat user. I don't 
> know if this will help though as you've tried with another database.
>
> The file will be: 
> $CATALINA_HOME/webapps/gridsphere/WEB-INF/CustomPortal/database/gridsphere 
>
>
> To answer a question in your original email, it is possible to use the 
> following commands to browse a hsql database:
>
> java -cp $CATALINA_HOME/shared/lib/hsqldb-1.7.1.jar 
> org.hsqldb.util.DatabaseManager
>
> then log in with the details in the hibernate.properties file from the 
> webapp:
> * full path to the database.script file (eg 
> jdbc:hsqldb:/net/dev/tomcat/webapps/gridsphere/WEB-INF/CustomPortal/database/gridsphere) 
>
> * user: sa
> * password: [blank]
>

Thanks for the quick reply Hamish. I encountered those permissions 
errors on my first attempt also, I rectified them though and I am 
unfortunately now absolutely sure that the data is making it to the DB 
(as evidenced by the fact that I can reset the password on the account 
successfully, but still not login).

Now that You've showed me how to browse the HSQL db (and that it's 
looking like that isn't the cause of my problem) I might re-deploy again 
and switch back to it.

Cheers,

Steve

>
> Stephen Gordon wrote:
>> Stephen Gordon wrote:
>>
>>> Hi,
>>>
>>> I'm trying to setup a Gridsphere installation for (eventually) 
>>> development purposes. I successfully setup and installed Apache 1.3 
>>> (including the mod_jk connector), Tomcat 5 and Gridsphere 2.2.7. On 
>>> browsing to the Gridsphere page for the first time I also 
>>> successfully created my admin account when prompted. As you can 
>>> probably guess there is a 'but' coming. After creating the account I 
>>> was re-directed to the login page, when entering the details for the 
>>> newly created account the response returned by Gridsphere was 'User 
>>> does not exist'.
>>>
>>> I re-tried several times, I didn't make a typo. I also went back and 
>>> started the entire process from scratch (reinstalling tomcat and 
>>> redeploying gridsphere) only to encounter the same error. I am using 
>>> the default database engine which appears to store its information 
>>> in 
>>> /usr/share/tomcat5/webapps/gridsphere/WEB-INF/CustomPortal/database 
>>> (on my system anyway) and the data for the account *appears* to be 
>>> there (as near as I can tell, I'm not entirely sure how one is 
>>> intended to go about reading this type of DB directly but in the 
>>> gridsphere.script there are queries that contain the data I provided 
>>> to setup the account).
>>>
>>> Any suggestions on where I might have gone wrong are more than 
>>> welcome. I've been butting heads with it all morning and I'm sure it 
>>> is one of those simple things resulting from me making an incorrect 
>>> assumption somewhere or something like that.
>>>
>>> Cheers,
>>>
>>> Steve
>>>
>>
>> I am still having problems with this. I have tried redeploying 
>> several times, I even tried redeploying using mysql instead of the 
>> default database engine. When I first browse to the gridsphere 
>> install it lets me create the initial user and this information *is* 
>> visible in the database, to the point that the functionality for 
>> resetting forgotten passwords actually works. Despite this every time 
>> I login I am presented with 'User not found'.
>>
>> Software versions in use are:
>>
>> - Gridsphere 2.2.7
>> - Tomcat 5.0.30
>> - Java 1.5.0
>>
>>
>> Any help would once again be greatly appreciated.
>>
>> Cheers,
>>
>> Steve
> _______________________________________________
> Gridsphere-users mailing list
> Gridsphere-users at gridsphere.org
> http://lists.gridsphere.org/mailman/listinfo/gridsphere-users
>