Mysql ruining my life - please help

Asterisk Asterisk Support
1

[b]Short version:

I get on today and asterisk, asteriskcdrdb, and ampusers sql databases are all gone.
halp![/b]

opening up PBX tab gives me:
FATAL ERROR
SELECT username, password_sha1, extension_low, extension_high, deptname, sections FROM ampusers WHERE username = 'asteriskuser’
DB Error: no such table

Opening up reports gives me:

(internal) Failed to count CDRs - Error de conexion al preparar peticion - Array ( [0] => 42S02 [1] => 1146 [2] => Table ‘asterisk.ringgroups’ doesn’t exist )

All hell has broken loose and this server receives over 2000 calls a day for a consulate, I don’t know what to do!

I tried backup up config and running elastix-firstboot but I get this:

Applying MySQL script /var/spool/elastix-mysqldbscripts/meetme_update.sql …
ERROR 1049 (42000) at line 1: Unknown database ‘meetme’

2

First: this is a elastix-question. You 'll get better support in an specific elastix forum then in this general asterisk forum.

I guess you don’t have a backup of your mysql-databases yourself? Don’t know if Elastix makes backups itself.

If not… they are probably gone for good.
Try to figure out how that came.

Was your Elastix up to date? I remember sometime ago that there was a security flaw in Elastix. Maybe you just got hacked.

I feel sorry for you, but making backups is also a responsability.