My schemes are gone, what to do?

Sebastian · March 26, 2019, 5:53pm

I added a commit with a rebuilder, where you can rebuild the content based on the schemas:

You can enable it in the settings:

Squidex/squidex/blob/master/src/Squidex/appsettings.json#L346


   * The name of the event store database.
   */
  "database": "Squidex"
},
"getEventStore": {
  /*
   * The connection string to your EventStore.
   * 
   * Read Mode: http://docs.geteventstore.com/dotnet-api/4.0.0/connecting-to-a-server/
   */
  "configuration": "ConnectTo=tcp://admin:changeit@localhost:1113; HeartBeatTimeout=500; MaxReconnections=-1",
  /*
   * The host name of your EventStore where projection requests will be sent to.
   */
  "projectionHost": "localhost",
  /*
   * Prefix for all streams and projections (for multiple installations).
   */
  "prefix": "squidex"
},
"cosmosDb": {

See the full commit here:

You can enable it with environment variable: REBUILD__SCHEMAS=true

or you can just run it with dotnet run --Rebuild:Schemas=true (I think)

You can read more about it here:

themisterbondy · March 26, 2019, 10:10pm

Even doing what you gave me can not retrieve the schemas / data, any other suggestions?

Sebastian · March 26, 2019, 10:26pm

You can export your database and send it over to me me, so that I can debug through it and have a look.

themisterbondy · March 26, 2019, 10:36pm

I’ve remade the compose again!

Sebastian · March 27, 2019, 9:15am

And it solved the problem?

themisterbondy · March 27, 2019, 10:57am

No, this is very strange!

Sebastian · March 27, 2019, 11:02am

As I said: Send me your backup and I can have a look. Otherwise it is like a blackbox for me.

themisterbondy · March 27, 2019, 1:07pm

Can I pass you the connection string?

Sebastian · March 27, 2019, 1:29pm

If your mongodb is available from the outside, sure

themisterbondy · March 27, 2019, 2:04pm

Follow the connection string
https://send.firefox.com/download/ded3fb2439da4045/#_LbAQLJOYryMulBMPe27Lw
Password download: DELETED

Sebastian · March 27, 2019, 2:31pm

Thx, please send it as PM the next time

Sebastian · March 27, 2019, 2:34pm

It looks like the whole database has been recreated. I don’t know what has happened but this is basically an empty database + 1 user. There is nothing I can do for you.

themisterbondy · March 27, 2019, 2:35pm

No problem, thanks for the help!

Sebastian · March 27, 2019, 2:40pm

You are welcome. I am 100% sure, that is not Squidex. Because there is nothing that deletes users or events from the database. The whole concept of Squidex is to never delete data.

obivandamme · June 19, 2019, 8:42am

Hey @Sebastian,
I am experiencing the same issue. It looks like after I restart my Docker Container something recreated the Database. I can remember to read something about recreating the Mongo Db on the configured folder even if it is not empty.

Sebastian · June 19, 2019, 8:53am

I am 100% sure that Squidex does not recreate any databases. Do you have a persistence volume for your database?

obivandamme · June 19, 2019, 9:41am

I mapped an szure storage account as described in my Azure Setup Documentation. For some reason they are all empty. It looks like the MongoDb container does not use it to persist the data.

Sebastian · June 19, 2019, 2:45pm

Perhaps the path mapping is just not correct?

obivandamme · June 21, 2019, 7:27am

I found the Problem. It seems like the Azure Linux Hosts for WebApps does not fully support SMB 3.0, which is needed by Azure File Share mounts. So if you have a correct path mapping there will be error messages on Mongo DB startup and if you screw up the path mappings, all files are stored in the container.
I fixed the Issue by setting up the MongoDB in an azure container instance (ACI), which supports SMB 3.0.
@Sebastian I will update the Azure Documentation again with this new insight and send you a Pull Request

Sebastian · June 21, 2019, 7:40am

Awesome, thanks for your contributions