What would make a database inaccessible from a web client?

[rhoward]

Hi everyone,

I'm building a web/mobile app and I've run into a really frustrating problem. I can't open my database from a preview in my browser, but I can from the app builder and web preview screens? i'm trying to open it on the init of my app and do some manipulation to make sure it's set up properly before the app loads, but I can't even get past the opening part. It works fine with Southwind so I know I've done something wrong in the database itself. For reference the code in my app is:

app init delegate

var initstatus = Lianja.evaluate("appinit()");
Lianja.showNotification(initstatus,true);

appinit.prg

try
    open database mydatabase
catch
    return "unable to open database"
endtry
return "success"

This shows the message "unable to open database", but when I replace mydatabase with southwind it shows "success". Does anyone know what I could have messed up inside my database to cause this?

Oh and yes it's deployed. It's sitting in lianja\cloudserver\tenants\public\data, right next to where I deployed southwind.

Sorry if this is in the wrong forum, it's kind of an overlap between a few different topics.

Thanks for any insight you could give,
Ryan

[barrymavin]

Have a look at strerror( errno() ) which will tell you what the issue is.

[yvonne.milne]

Hi Ryan,

Does your database have a 'dbc_opendata' database open event delegate (empty or containing code)?

This is not currently supported in the Lianja Web Client, so needs to be removed before deployment.



Regards,

Yvonne

[rhoward]

Ah, yes I do have an opendata script! It doesn't do much so I can just put that functionality inside my app. Is there any word on when/if that's planned to be added to the web client?

[barrymavin]

I wasn't aware it wasn't working in the cloud server. Please submit a ticket. It runs on the server when the database is opened not on the client.