unknown ticket on server for all sites

[BlueShadow]

Hi all my sites show an unknown ticket on my production site.
So I got my backup and it worked for 2-3days.
than it started again
... repeat about 3 times.
So I reinstalled my entire server new ubuntu 14.04
ngninx uswgi web2py
my coppied app (I use sqlite as db so it should work)
and now I get the welcome app.
the appadmin but my app still shows an unknown ticket for all sites.
when I copied my app to a localhost web2py I get the following ticket

<class 'sqlite3.DatabaseError'> file is encrypted or is not a database

Version

 

web2py™	Version 2.10.3-stable+timestamp.2015.04.02.21.42.07
Python	Python 2.6.4: C:\Python26\pythonw.exe (prefix: C:\Python26)

Traceback

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25.

Traceback (most recent call last):   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\restricted.py", line 227, in restricted     exec ccode in environment   File "F:/Dateien/Programmieren/testweb2py/web2py/applications/MA/models/menu.py", line 79, in <module>     _()   File "F:/Dateien/Programmieren/testweb2py/web2py/applications/MA/models/menu.py", line 52, in _     if auth.has_membership('Author'):   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\tools.py", line 3542, in has_membership     group_id = self.id_group(group_id)  # interpret group_id as a role   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\tools.py", line 3512, in id_group     rows = self.db(self.table_group().role == role).select()   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\objects.py", line 2093, in select     return adapter.select(self.query,fields,attributes)   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\adapters\sqlite.py", line 125, in select     return super(SQLiteAdapter, self).select(query, fields, attributes)   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1239, in select     return self._select_aux(sql,fields,attributes)   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1204, in _select_aux     self.execute(sql)   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1326, in execute     return self.log_execute(*a, **b)   File "F:\Dateien\Programmieren\testweb2py\web2py\gluon\packages\dal\pydal\adapters\base.py", line 1320, in log_execute     ret = self.cursor.execute(command, *a[1:], **b) DatabaseError: file is encrypted or is not a database

Error snapshot
 
   
   
 

 
 
    <class 'sqlite3.DatabaseError'>(file is encrypted or is not a database

I know it is an old version of web2py I got on my local system but the only thing I have right now.
I really need some help I got no clue what to do.
On my production server the newest web2py version is running. installed today with the nginx script.

[Alfonso Serra]

Hmm looks bad, ransomware on your server? Do you have a copy of your database?, It would also happen if you are editing on windows and have the bitlocker service enabled. You will be uploading an encrypted database.
Try to open your database directly, Firefox has a plugin for it.

[BlueShadow]

I tried accessing my database from my backup on my local pc. it opens just fine with the firefox extension no password or anything.
I checked a couple tables and they look fine.
if it were ransomware I would have gotten a demand somewhere.
My server should be pretty secure ssh with key, ...

[Alfonso Serra]

Still, what operating system are you running? Does it have bitlocker or similar enabled? I dont know how bitlocker works but you could be uploading an encrypted file to your server. Easy to check If you try any other text file and it works.

[BlueShadow]

I am running windows 7 on my home pc and ubuntu 14.04 on my server. On my server I get unknown ticket as an error. on my home pc I updated web2py and I get the database locked error.
I don't know what bitlocker is so I guess I don't have it. I uploaded everything with filezilla.
Sry that I don't have more informations but I just have no clue how to get more if I get an unknown ticket.

[Alfonso Serra]

Bit locker is a windows feature that encrypts your harddrive so no one can read your files. It might be this, you can read your files but the uploaded ones are encrypted, readable only by your windows machine.
You can try this
https://technet.microsoft.com/en-us/library/ee424315%28v=ws.10%29.aspx
and this
https://www.youtube.com/watch?v=0npTlOq6q_0

An easy way to read tickets from your server is:
Goto the errors folder within your local app web2py/myapp/errors and delete everything
Use filezilla to download the errors from the server to this folder
Now you can read the errors from your server on your local app. visiting http://localhost:xxx/myapp/admin

[Kevin Bethke]

So I checked bitlocker is of for all devices. So it can't be bitlocker.

Is there a log somewhere where I can get more informations on the unknown ticket?

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/n4rm0YhL5xg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Anthony]

On Sunday, May 15, 2016 at 11:58:50 AM UTC-4, Alfonso Serra wrote:

Bit locker is a windows feature that encrypts your harddrive so no one can read your files. It might be this, you can read your files but the uploaded ones are encrypted, readable only by your windows machine.

With Bitlocker, files are automatically decrypted whenever they leave the machine (via copying, email attachment, FTP, etc.), so this wouldn't be the issue.

Anthony