Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge Download Epesi BIM Free & Open Source CRM

My server was hacked yesterday and the hacker got into the cpanel, file manager and did a select all and delete opporation, they also manager to delete all backups made by cpanel.

Thankfully they did delete my sql databases.

Problem im having now is getting epesi back up and running. I was running 1.3 fine, i dont have a backup of the the install unfortantly.

I have tried uploading a fresh 1.3 copy to server and creating a the config file from an older backup to match the database but all i get is an error.

Unable to read Base/Box/default.ini file! Please create one, or change theme.

please help

  • MediaMan,

    In order to restore your EPESI installation you must have:
    - a working database or a backup
    - /data directory from EPESI or a backup

    If you have them the procedure is quite simple:
    - keep your old /EPESI/data directory and dump of your database in a safe place for now (for example /backup folder)
    - download the version you were running - in this case 1.3. While it is possible to get the latest version I would not recommend this as you are doing disaster recovery and you should try to get the same version running and then - after making sure that it works - proceed with the upgrade.
    You can get the necessary version from here: https://sourceforge.net/projects/epesi/files/epesi/
    - After the installation file is downloaded unzip it and place on the web server.
    - Create new database - for example epesi_new and proceed with clean installation - pointing to epesi_new database, not the old one.
    - Verify that this clean EPESI installation is working - that you can login, create new contact etc.

    Recovery:
    - Make a directory: backup_new and copy there your /data directory from newly installed EPESI - in case you need to troubleshoot your installation
    - Now empty your /data directory in a working installation of EPESI
    - copy a backup of your /data directory from your failed EPESI installation
    - edit /data/config.php file and make sure you are pointing to the old EPESI database
    You should be able to open your EPESI and see old data.

    However this is assuming that you have a good and working database containing your old EPESI data. You should inspect this database using some utility like phpmyadmin or other GUI MySQL administration tools. Check if you can open tables and see content. Most of these utilities allow you to run some check and repairs to verify data integrity. If your database is corrupted there is not much you can do - the only option is to restore the database from the backup.

    If your old database is fine and you already tested clean installation of EPESI as outlined above - after switching the database you may encounter some errors with templates.

    EDIT: Admin tools are now included with every version of epesi.

    Download ADMIN tools: http://sourceforge.net/projects/epesi/f ... p/download
    These tools are placed in /admin directory and you can access them via http://your_epesi_address/admin
    Once there use option 3 to rebuild the common cache and default theme to fix any templates errors.
    Don't worry about copying old theme files from old installation - they will be recreated as needed.

    admin-tools.png

    Post here results of your work if you can.

i have also tried adding themes from older 1.2 version i have backed up locally but when i add these files to the data folder i get the following error

Hide
Fatal: Call to undefined method Base_BoxCommon::update_version_check_indicator() in /home/public_html/epesi/modules/Base/Box/Box_0.php on line 153

ive tied only uploading the theme folders, Base_Lang, Base_MainModuleIndicator, Base_Setup, Base_Theme & Base_Theme_Administrator from the older 1.2 version and this gets me to the login screen and i can login, but from there i get loads of missing items and loading for ever on poages etc etc and no admin menu dropdown etc.

looks like im missing something for 1.3 in the data foilder but not sure what or where to get it from.

MediaMan,

In order to restore your EPESI installation you must have:
- a working database or a backup
- /data directory from EPESI or a backup

If you have them the procedure is quite simple:
- keep your old /EPESI/data directory and dump of your database in a safe place for now (for example /backup folder)
- download the version you were running - in this case 1.3. While it is possible to get the latest version I would not recommend this as you are doing disaster recovery and you should try to get the same version running and then - after making sure that it works - proceed with the upgrade.
You can get the necessary version from here: https://sourceforge.net/projects/epesi/files/epesi/
- After the installation file is downloaded unzip it and place on the web server.
- Create new database - for example epesi_new and proceed with clean installation - pointing to epesi_new database, not the old one.
- Verify that this clean EPESI installation is working - that you can login, create new contact etc.

Recovery:
- Make a directory: backup_new and copy there your /data directory from newly installed EPESI - in case you need to troubleshoot your installation
- Now empty your /data directory in a working installation of EPESI
- copy a backup of your /data directory from your failed EPESI installation
- edit /data/config.php file and make sure you are pointing to the old EPESI database
You should be able to open your EPESI and see old data.

However this is assuming that you have a good and working database containing your old EPESI data. You should inspect this database using some utility like phpmyadmin or other GUI MySQL administration tools. Check if you can open tables and see content. Most of these utilities allow you to run some check and repairs to verify data integrity. If your database is corrupted there is not much you can do - the only option is to restore the database from the backup.

If your old database is fine and you already tested clean installation of EPESI as outlined above - after switching the database you may encounter some errors with templates.

EDIT: Admin tools are now included with every version of epesi.

Download ADMIN tools: http://sourceforge.net/projects/epesi/f ... p/download
These tools are placed in /admin directory and you can access them via http://your_epesi_address/admin
Once there use option 3 to rebuild the common cache and default theme to fix any templates errors.
Don't worry about copying old theme files from old installation - they will be recreated as needed.

admin-tools.png

Post here results of your work if you can.

all i have a the mysql database which is working, all the other files are gone! the b***ard manager to kill all my backups! Grrrrrr

can I...

create a fresh install of 1.3 and then import all the data from my old intact 1.3 database??

yeah fresh install works fine, installed 1.3 on a new database on the server and all hunky dory

- copy a backup of your /data directory from your failed EPESI installation

dont have a copy :-( of this

sorted it, all i did was change the new installs config to the old database and hay presto all working and all info back

MediaMan,

I am glad you got it working. I am afraid you will not be able to read all of your data 🙁
The database - which apparently is working - stores data like users, all recordsets including text stored in e-mails, notes etc. But not all objects used by EPESI are stored in the database. Instead of using BLOBs http://en.wikipedia.org/wiki/Binary_large_object - which will cause the database to grow like crazy - we store large objects - like attached files, e-mail attachments and the like in /data directory.
Therefore if you have a note with attached file I am afraid you will be able to read the note but not the attachment unless you restore somehow the structure of the old /data directory.

we only really use about 1/4 of its potentian TBH

all we use is the companies section and input there info etc, then add notes when we call them and talk to them, then add tasks for call backs etc. nothing more than that and all that info seem to be store in the DB
its not linked to out emails, no attachemtns added etc, just the basics.

Well - in that case you should be able to find all your data. I am glad to hear it worked and the recovery process was not long or painfull 🙂

that part of the recovery wasn't paintful, but resorting our wordpress website is now a nightmare!!!

with over 500 images missing now and many images are submitted by outside users... think thats going to be a headache!

7 years later
Write a Reply...