On Mon, Feb 11, 2013 at 11:24 AM, Kasun Perera <[email protected]> wrote:
> Hi Shariq > > Thanks for pointing the DB explorer, and I'll use Firefox. > > Here's the exception that I'm getting. http://paste.org/61234 > > As I mentioned previously it runs fine in my local wso2stratos-as-1.5.2, > by connecting to the live-database. So debugging doesn't help me to find > any error. > The issue you are seeing is because we have enabled Security Manager in our setup. Security Manager prevents tenant code from doing privileged operations such as class loading, writing to the file system etc. In your code, it seems ConnectionPool.getConnection() methods is causing the security exception .. I have attached a sample webapp here with that is using RSS .. can you use BasicDataSource approach as seen in the DBManager.java class and try .. this should get rid of the security exception you are seeing .. > > Here is our app, may be you can try it in testing tenant- > > https://docs.google.com/file/d/0B5A0W5SUykQqSHpJTnM0TWxUWE0/edit?usp=sharing > > Thanks > > > > > > On Mon, Feb 11, 2013 at 10:39 AM, Muhammed Shariq <[email protected]> wrote: > >> Hi, >> >> On Mon, Feb 11, 2013 at 9:18 AM, Kasun Perera <[email protected]>wrote: >> >>> H Amila >>> >>> I have activated the the Storage Server, and now I can see the list of >>> databases. >>> But when I click on manage link on a perticuler database, it direct me >>> to the "Attach database users" page. >>> From my previous experience this should direct me to the page where I >>> can login to the database and run SQL queries? >>> I tried to create a new database but the result was same as above >>> mentioned >>> >> >> The DB explorer is in the Data Services Server .. you can find it under >> Tools -> Database Explorer in the Data Services Server and execute your >> queries ... >> >>> >>> The exception occurs when trying to login for the webapp --> I think >>> this is still a problem of database connectivity ?Can you suggest any work >>> around? >>> >> >> Can you send us any exceptions you are seeing so we can further >> investigate ..? >> >>> >>> BTW- Sometimes I'm experiencing some weird behavior on stratoes live >>> It gives me "Authentication Failure" when I'm trying to login for "Data >>> Service Server" and "Storage server" >>> When I click some link instead of going to that page it start >>> downloading the page. e.g when I click upload web application it start >>> downloading the "upload.jsp" page. >>> >> >> The pages being downloaded is an issue we also experience in Google >> Chrome .. you can use Firefox for the moment and it should work fine . >> >>> >>> Thanks >>> >>> >>> On Sun, Feb 10, 2013 at 1:19 PM, Amila Maha Arachchi <[email protected]>wrote: >>> >>>> Hi Kasun, >>>> >>>> On Sun, Feb 10, 2013 at 12:22 PM, Kasun Perera <[email protected]>wrote: >>>> >>>>> >>>>> >>>>> On Sun, Feb 10, 2013 at 10:55 AM, Amila Maha Arachchi <[email protected] >>>>> > wrote: >>>>> >>>>>> When we access your webapp, we can see it loading fine the styles. >>>>> >>>>> >>>>> Yes this is due to changes I did on Friday! >>>>> We had common JSP segment files "header.jspf" "footer.jspf" and >>>>> I merged them with the login page on Friday in-order to see whether it >>>>> works. So basically login was loading with fine styles since Friday. >>>>> >>>>> But I still can't see our MySql databases inside the Data Service >>>>> Server interface. Is this same for your testing tenants? I have another >>>>> testing tenant and situation is same; I can see the databases there too. >>>>> >>>> >>>> Yes, this is the expected behaviour. Your database will be found in >>>> https://storage.stratoslive.wso2.com (Our new storage server product). >>>> So, if you login to your tenant and go to above URL, you will see it under >>>> the databases section (this was earlier included in Data Service Server and >>>> now it is removed from it and included in Storage Server). >>>> >>>> *Note: >>>> >>>> You might not be able to login to storage server in your first attempt. >>>> First, you need to go to Stratos Manager (https://stratoslive.wso2.com) >>>> -> Configure -> Services. There you will see the available services and >>>> then you need to activate the Storage Server for your tenant. After that >>>> you will be able to login to it (this is because this is a new addition to >>>> our product stack). * >>>> >>>> I have tested this for my personal apps which were using old databases. >>>> I'll try your app as well. >>>> >>>>> >>>>> One other thing-> Please upload our .war file to your testing tenant >>>>> and see whether it works >>>>> >>>>> https://docs.google.com/file/d/0B5A0W5SUykQqY0luNVpGSi1vTVU/edit?usp=sharing >>>>> >>>>> Thanks >>>>> >>>>> >>>>> >>>>> >>>>>> Most probably your app is trying some privileged operations in >>>>>> StratosLive. We'll work with Kasun on resolving them too. Most probably >>>>>> there will need a little code change I guess. We'll work on this on >>>>>> Monday. >>>>>> >>>>>> Regards, >>>>>> Amila. >>>>>> >>>>>> >>>>>> On Sun, Feb 10, 2013 at 9:26 AM, Louiqa Raschid < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> >>>>>>> Hi, >>>>>>>>> Sorry about the late response. Yes I did verify with an old tenant >>>>>>>>> of mine too after Prabath confirmed that the migration fix was >>>>>>>>> complete .. >>>>>>>>> now the DB user migration issue is fixed .. >>>>>>>>> Thanks Prabath for looking into it :) >>>>>>>>> >>>>>>>> >>>>>>> Our app is still not working but this is probably because Kasun >>>>>>> needs to >>>>>>> do some post-migration work? >>>>>>> http://appserver.stratoslive.**wso2.com/t/karsha.opensource.** >>>>>>> lk/webapps/KarshaAnnotate/**login<http://appserver.stratoslive.wso2.com/t/karsha.opensource.lk/webapps/KarshaAnnotate/login> >>>>>>> >>>>>>> I understand that we are not tenants with an SLA but ... I think >>>>>>> that there should have been some warnings sent to all tenants before >>>>>>> these >>>>>>> migrations happened? >>>>>>> >>>>>>> Louiqa >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Amila Maharachchi* >>>>>> Technical Lead >>>>>> Member, Management Committee - Cloud & Platform TG >>>>>> WSO2, Inc.; http://wso2.com >>>>>> >>>>>> Blog: http://maharachchi.blogspot.com >>>>>> Mobile: +94719371446 >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> >>>>> Kasun Perera >>>>> >>>> >>>> >>>> >>>> -- >>>> *Amila Maharachchi* >>>> Technical Lead >>>> Member, Management Committee - Cloud & Platform TG >>>> WSO2, Inc.; http://wso2.com >>>> >>>> Blog: http://maharachchi.blogspot.com >>>> Mobile: +94719371446 >>>> >>>> >>> >>> >>> -- >>> Regards >>> >>> Kasun Perera >>> >> >> >> >> -- >> Thanks, >> Shariq. >> Phone: +94 777 202 225 >> > > > > -- > Regards > > Kasun Perera > -- Thanks, Shariq. Phone: +94 777 202 225
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
