Where I can find the ee database


#1

I am a little bit confused.

Currently a site is running on nginx created with ee. But if I ask ee to list all sites this existing site ist not shown (ee site list).

In addition I wanted to create a new site: ee site create abc.com --wpfc, but there was an database error. Therefore I wanted to delete this site. But now it was saying: “Error occurred while deleting database”.

So I thought I can manually correct this issue to get a fresh start, I delete the var/www/abc.com also all logfiles. A nginx reload was not successful.

So, please can you explain what is or where the ee-database is located. And how to initiate a script based reindexing or a manual adjustment.

I need to create the --wpfc site. BTW: If I want to move a WP site from an external hoster to my own nginx server, what are the issues I should be aware of or watch out for?

Not sure if this helps:

2015-05-24 13:09:38,138 (INFO) ee : e[94m[e[91mFailede[94m]e[0m
2015-05-24 13:09:54,249 (DEBUG) ee : logging initialized for 'ee' using LoggingLogHandler
2015-05-24 13:09:54,433 (DEBUG) ee : ['/usr/local/bin/ee', 'site', 'delete', 'abc.com']
2015-05-24 13:09:54,433 (DEBUG) ee : collecting arguments/commands for <ee.cli.controllers.base.EEBaseController object at 0x7f80459c77b8>
2015-05-24 13:09:54,435 (DEBUG) ee : collecting arguments/commands for <ee.cli.plugins.site.EESiteController object at 0x7f80459c7ba8>
2015-05-24 13:09:54,436 (DEBUG) ee : collecting arguments/commands for <ee.cli.plugins.site.EESiteDeleteController object at 0x7f8045956240>
2015-05-24 13:09:54,439 (INFO) ee : Initializing EasyEngine Database
2015-05-24 13:09:56,828 (INFO) ee : e[94mDeleting Database, None, user Nonee[0m
2015-05-24 13:09:56,830 (DEBUG) ee : e[95me[0m
2015-05-24 13:09:56,830 (DEBUG) ee : e[95mdropping user `None`e[0m
2015-05-24 13:09:56,831 (DEBUG) ee : e[95m(1045, "#28000Access denied for user 'root'@'localhost' (using password: YES)")e[0m
2015-05-24 13:09:56,831 (ERROR) ee : e[91mError occured while deleting database

#2

Any feedback, any ideas?


#3

@jochenthomas

you can get it at /var/lib/ee/ee.db


#4

Hi, many thanks!!
Looking plain at the db I can see that there are some sites registered, but not the currently running site abc.com.

But I can see e.g. one site (db-content: …def.comwpwpfc/var/www/def.com2015-05-24) which I wanted to delete: But ee site delete def.com brings the following error - see picture:

Why I can’t delete this site?

In addition:
What happens if I delete the ee.db database completely and create all the sites again (Off course I’ll rename the folders and maybe the WordPress databases before)?

If there is again a DB Error, what would be the procedure to check?


#5

Hi,

I’m having exact same error as @jochenthomas and also curious for solutions.


#6

Hi @jochenthomas, @Ditto_Rahmat

To my knowledge this issue happens in two situations :

  1. Manually editing site information stored in ee database(/var/lib/ee/ee.db) by overwriting the concerned site’s db_user and db_name field values with empty string.

  2. If concerned site’s wp-config.php is missing, while updating your EasyEngine 2.x to 3.x

We will be fixing this issue by informing user that the things have been messed with and also this may be accompanied with suggestions for this situation .


#7

Same problem here. Happens when using sudo with ee site create. Logged in as root I could delete the sites with the ee site delete command.


#8