New WP Install missing wp-config file and mysql database


#1

hi i have problem when install a new site using easy engine in my droplet digitalocean when i execute ee site create domain.com --wp all run well but seems its not complete installataion because i dont find any database in phpmyadmin and wp-config.php file in a root directory

hope i could get help to solve it

tyvm


#2

EasyEngine create wp-config.php file at following location

/var/www/example.com/wp-config.php

If you don’t file wp-config.php file in above location then give us output of following command

cat /var/log/easyengine/*

#3

yes, i have check it carefully, as i already have 3 sites installed before. and no wp-config. i got this massage for each new installation : ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) [ Wed Aug 27 16:53:30 WITA 2014 ] Unable to create testkota_com database, exit status = 1


#4

Seems like your MySQL login credential issue. can you give me complete output of following command so we can guide you further

ee site create test.com --wp
cat ~/.my.cnf
cat /root/.my.cnf

#5

ee site create test.com --wp :

Creating test.com, please wait… Creating symbolic link for test.com Creating htdocs & logs directory Downloading WordPress, please wait… ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) [ Wed Aug 27 21:46:47 WITA 2014 ] Unable to create test_com database, exit status = 1

cat ~/.my.cnf [client] user=root password=shown well

cat /root/.my.cnf : the pass same as in cat ~/.my.cnf

what should i do please?


#6

can you check whether you can login to mysql shell.

use this command

mysql -u root -pMYSQL_PASSWD

Replace MYSQL_PASSWD with your original mysql password.


#7

Try switching to root with sudo su first. Worked for me.


#8

I’m having the same/similar issue. I ran the following command:

ee site create wetakeitlive.com --wp

The setup seemed to run as it should until this:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[ Sun Jan 25 21:05:50 UTC 2015 ] Unable to create wetakeitlive_com database, exit status =  1

The output of…

cat /var/log/easyengine/*

is:

EasyEngine (ee) 2.2.2 execution started [Sun Jan 25 21:05:32 UTC 2015]
EasyEngine (ee) command: /usr/local/sbin/ee site create wetakeitlive.com --wp
nginx-full					install
php5-fpm					install
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
php5-fpm					install
Downloading WP-CLI, please wait...
EasyEngine (ee) 2.2.2 execution started [Sun Jan 25 21:05:35 UTC 2015]
EasyEngine (ee) command: /usr/local/sbin/ee stack install postfix
Executing apt-get update, please wait...
Executing apt-get update, please wait...
Hit http://gce_debian_mirror.storage.googleapis.com wheezy Release.gpg
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates Release.gpg
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-backports Release.gpg
Hit http://security.debian.org wheezy/updates Release.gpg
Hit http://gce_debian_mirror.storage.googleapis.com wheezy Release
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates Release
Hit http://security.debian.org wheezy/updates Release
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-backports Release
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/main Sources
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/contrib Sources
Hit http://security.debian.org wheezy/updates/main Sources
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/non-free Sources
Hit http://security.debian.org wheezy/updates/contrib Sources
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/main amd64 Packages
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/contrib amd64 Packages
Hit http://security.debian.org wheezy/updates/non-free Sources
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/non-free amd64 Packages
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/contrib Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/main Translation-en
Hit http://security.debian.org wheezy/updates/main amd64 Packages
Hit http://gce_debian_mirror.storage.googleapis.com wheezy/non-free Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/main Sources
Hit http://security.debian.org wheezy/updates/contrib amd64 Packages
Hit http://security.debian.org wheezy/updates/non-free amd64 Packages
Hit http://http.debian.net wheezy Release.gpg
Hit http://security.debian.org wheezy/updates/contrib Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/contrib Sources
Hit http://security.debian.org wheezy/updates/main Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/non-free Sources
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/main amd64 Packages/DiffIndex
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/contrib amd64 Packages
Hit http://security.debian.org wheezy/updates/non-free Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/non-free amd64 Packages
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/contrib Translation-en
Hit http://http.debian.net wheezy-backports Release.gpg
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/main Translation-en/DiffIndex
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-updates/non-free Translation-en
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-backports/main Sources/DiffIndex
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-backports/main amd64 Packages/DiffIndex
Hit http://gce_debian_mirror.storage.googleapis.com wheezy-backports/main Translation-en/DiffIndex
Hit http://http.debian.net wheezy Release
Hit http://http.debian.net wheezy-backports Release
Hit http://http.debian.net wheezy/main Sources
Hit http://http.debian.net wheezy/main amd64 Packages
Hit http://http.debian.net wheezy/main Translation-en
Hit http://http.debian.net wheezy-backports/main Sources/DiffIndex
Hit http://http.debian.net wheezy-backports/main amd64 Packages/DiffIndex
Hit http://http.debian.net wheezy-backports/main Translation-en/DiffIndex
Reading package lists...
Installing Postfix, please wait...
Installing Postfix, please wait...
Reading package lists...Reading package lists...

Building dependency tree...Building dependency tree...
Reading state information...
Reading state information...

The following extra packages will be installed:
  ssl-cert
The following extra packages will be installed:
  ssl-cert
Suggested packages:
  procmail postfix-mysql postfix-pgsql postfix-ldap postfix-pcre sasl2-bin
  libsasl2-modules dovecot-common resolvconf postfix-cdb ufw postfix-doc
  openssl-blacklist
Suggested packages:
  procmail postfix-mysql postfix-pgsql postfix-ldap postfix-pcre sasl2-bin
  libsasl2-modules dovecot-common resolvconf postfix-cdb ufw postfix-doc
  openssl-blacklist
The following NEW packages will be installed:
  postfix ssl-cert
The following NEW packages will be installed:
  postfix ssl-cert
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 1,611 kB of archives.
After this operation, 3,653 kB of additional disk space will be used.
Get:1 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main ssl-cert all 1.0.32 [19.5 kB]
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 1,611 kB of archives.
After this operation, 3,653 kB of additional disk space will be used.
Get:1 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main ssl-cert all 1.0.32 [19.5 kB]
Get:2 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main postfix amd64 2.9.6-2 [1,591 kB]
Get:2 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main postfix amd64 2.9.6-2 [1,591 kB]
Preconfiguring packages ...
Preconfiguring packages ...
Fetched 1,611 kB in 0s (3,519 kB/s)
Fetched 1,611 kB in 0s (3,519 kB/s)
Selecting previously unselected package ssl-cert.
Selecting previously unselected package ssl-cert.
(Reading database ... 26520 files and directories currently installed.)
(Reading database ... 26520 files and directories currently installed.)
Unpacking ssl-cert (from .../ssl-cert_1.0.32_all.deb) ...
Unpacking ssl-cert (from .../ssl-cert_1.0.32_all.deb) ...
Selecting previously unselected package postfix.
Unpacking postfix (from .../postfix_2.9.6-2_amd64.deb) ...
Selecting previously unselected package postfix.
Unpacking postfix (from .../postfix_2.9.6-2_amd64.deb) ...
Processing triggers for man-db ...
Processing triggers for man-db ...
Setting up ssl-cert (1.0.32) ...
Setting up ssl-cert (1.0.32) ...
Setting up postfix (2.9.6-2) ...
Setting up postfix (2.9.6-2) ...
Adding group `postfix' (GID 107) ...
Adding group `postfix' (GID 107) ...
Done.
Done.
Adding system user `postfix' (UID 104) ...
Adding new user `postfix' (UID 104) with group `postfix' ...
Adding system user `postfix' (UID 104) ...
Adding new user `postfix' (UID 104) with group `postfix' ...
Not creating home directory `/var/spool/postfix'.
Not creating home directory `/var/spool/postfix'.
Creating /etc/postfix/dynamicmaps.cf
Creating /etc/postfix/dynamicmaps.cf
Adding tcp map entry to /etc/postfix/dynamicmaps.cf
Adding tcp map entry to /etc/postfix/dynamicmaps.cf
Adding sqlite map entry to /etc/postfix/dynamicmaps.cf
Adding sqlite map entry to /etc/postfix/dynamicmaps.cf
Adding group `postdrop' (GID 108) ...
Adding group `postdrop' (GID 108) ...
Done.
Done.
setting myhostname: lemp-aiof.c.decoded-academy-834.internal
setting myhostname: lemp-aiof.c.decoded-academy-834.internal
setting alias maps
setting alias maps
setting alias database
setting alias database
changing /etc/mailname to lemp-aiof.c.decoded-academy-834.internal
setting myorigin
changing /etc/mailname to lemp-aiof.c.decoded-academy-834.internal
setting myorigin
setting destinations: lemp-aiof.c.decoded-academy-834.internal, localhost.c.decoded-academy-834.internal, localhost
setting destinations: lemp-aiof.c.decoded-academy-834.internal, localhost.c.decoded-academy-834.internal, localhost
setting relayhost: 
setting relayhost: 
setting mynetworks: 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
setting mynetworks: 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
setting mailbox_size_limit: 0
setting mailbox_size_limit: 0
setting recipient_delimiter: +
setting recipient_delimiter: +
setting inet_interfaces: all
setting inet_interfaces: all
/etc/aliases does not exist, creating it.
/etc/aliases does not exist, creating it.
WARNING: /etc/aliases exists, but does not have a root alias.
WARNING: /etc/aliases exists, but does not have a root alias.

Postfix is now set up with a default configuration.  If you need to make 
changes, edit

Postfix is now set up with a default configuration.  If you need to make 
changes, edit
/etc/postfix/main.cf (and others) as needed.  To view Postfix configuration
values, see postconf(1).

After modifying main.cf, be sure to run '/etc/init.d/postfix reload'.

/etc/postfix/main.cf (and others) as needed.  To view Postfix configuration
values, see postconf(1).

After modifying main.cf, be sure to run '/etc/init.d/postfix reload'.

Running newaliases
Running newaliases
[ ok [ ok ..] Stopping Postfix Mail Transport Agent: postfixStopping Postfix Mail Transport Agent: postfix.
.
[ ok ] [....] Starting Postfix Mail Transport Agent: postfixStarting Postfix Mail Transport Agent: postfix.
.
Executing service postfix restart, please wait...
Executing service postfix restart, please wait...
Stopping Postfix Mail Transport Agent: postfix.
Starting Postfix Mail Transport Agent: postfix.
Initialized empty Git repository in /etc/postfix/.git/
Git commit on /etc/postfix/, please wait...
Git commit on /etc/postfix/, please wait...
[master (root-commit) 42f1029] Initialize Git
 6 files changed, 1797 insertions(+)
 create mode 100644 dynamicmaps.cf
 create mode 100644 main.cf
 create mode 100644 master.cf
 create mode 100755 post-install
 create mode 100644 postfix-files
 create mode 100755 postfix-script
postfix successfully installed
postfix successfully installed
PHP binary:	/usr/bin/php5
PHP version:	5.4.36-0+deb7u3
php.ini used:	/etc/php5/cli/php.ini
WP-CLI root dir:	phar://wp-cli.phar
WP-CLI global config:	
WP-CLI project config:	
WP-CLI version:	0.17.1
EE_DOMAIN_CHECK = wetakeitlive.com 
EE_SITE_CREATE_OPTION = --wp 
EE_SITE_CACHE_OPTION = --basic 
EE_NETWORK_ACTIVATE =  
EE_WP_SUBDOMAIN =  
EE_NGINX_CONF = wp/basic.conf
Creating wetakeitlive.com, please wait...
Creating symbolic link for wetakeitlive.com
Creating htdocs & logs directory
Downloading WordPress, please wait...
Downloading WordPress 4.1 (en_US)...
Success: WordPress downloaded.
EE_DB_NAME = wetakeitlive_com 
EE_DB_USER = wetakeitlive_com 
EE_DB_PASS = MDLXaacJsKI1Z1D 
EE_MYSQL_HOST = localhost 
EE_MYSQL_GRANT_HOST = localhost
[ Sun Jan 25 21:05:50 UTC 2015 ] Unable to create wetakeitlive_com database, exit status =  1
[ Sun Jan 25 21:05:50 UTC 2015 ] Unable to create wetakeitlive_com database, exit status =  1
Installing required packages, please wait...
Reading package lists...
Building dependency tree...
Reading state information...
coreutils is already the newest version.
sudo is already the newest version.
tar is already the newest version.
wget is already the newest version.
curl is already the newest version.
The following extra packages will be installed:
  fontconfig fonts-liberation git git-man iso-codes less libcairo2 libcdt4
  libcgraph5 libcurl3-gnutls libdatrie1 liberror-perl libffi5 libglib2.0-0
  libglib2.0-data libgraph4 libgvc5 libgvpr1 libice6 libpango1.0-0
  libpathplan4 libpixman-1-0 libsm6 libthai-data libthai0 libxaw7
  libxcb-render0 libxcb-shm0 libxdot4 libxext6 libxft2 libxmu6 libxrender1
  libxt6 python-apt python-apt-common python-gnupginterface python-pycurl
  python-support shared-mime-info ttf-liberation unattended-upgrades
  x11-common
Suggested packages:
  git-daemon-run git-daemon-sysvinit git-doc git-el git-arch git-cvs git-svn
  git-email git-gui gitk gitweb gsfonts graphviz-doc isoquery ttf-baekmuk
  ttf-arphic-gbsn00lp ttf-arphic-bsmi00lp ttf-arphic-gkai00mp
  ttf-arphic-bkai00mp python-apt-dbg python-gtk2 python-vte python-apt-doc
  libcurl4-gnutls-dev python-pycurl-dbg bsd-mailx mail-transport-agent
The following NEW packages will be installed:
  bc ed fontconfig fonts-liberation git git-core git-man graphviz iso-codes
  less libcairo2 libcdt4 libcgraph5 libcurl3-gnutls libdatrie1 liberror-perl
  libffi5 libglib2.0-0 libglib2.0-data libgraph4 libgvc5 libgvpr1 libice6
  libpango1.0-0 libpathplan4 libpixman-1-0 libsm6 libthai-data libthai0
  libxaw7 libxcb-render0 libxcb-shm0 libxdot4 libxext6 libxft2 libxmu6
  libxrender1 libxt6 python-apt python-apt-common python-gnupginterface
  python-pycurl python-software-properties python-support shared-mime-info
  ttf-liberation unattended-upgrades x11-common
0 upgraded, 48 newly installed, 0 to remove and 0 not upgraded.
Need to get 21.5 MB of archives.
After this operation, 62.7 MB of additional disk space will be used.
Get:1 http://security.debian.org/ wheezy/updates/main libcurl3-gnutls amd64 7.26.0-1+wheezy12 [322 kB]
Get:2 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libpixman-1-0 amd64 0.26.0-4+deb7u1 [427 kB]
Get:3 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxcb-render0 amd64 1.8.1-2+deb7u1 [18.6 kB]
Get:4 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxcb-shm0 amd64 1.8.1-2+deb7u1 [10.4 kB]
Get:5 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxrender1 amd64 1:0.9.7-1+deb7u1 [32.7 kB]
Get:6 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libcairo2 amd64 1.12.2-3 [912 kB]
Get:7 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libdatrie1 amd64 0.2.5-3 [28.6 kB]
Get:8 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libffi5 amd64 3.0.10-3 [24.8 kB]
Get:9 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libglib2.0-0 amd64 2.33.12+really2.32.4-5 [1,838 kB]
Get:10 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main x11-common all 1:7.7+3~deb7u1 [284 kB]
Get:11 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libice6 amd64 2:1.0.8-2 [63.1 kB]
Get:12 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libthai-data all 0.1.18-2 [154 kB]
Get:13 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libthai0 amd64 0.1.18-2 [42.3 kB]
Get:14 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxft2 amd64 2.3.1-1 [61.0 kB]
Get:15 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main fontconfig amd64 2.9.0-7.1 [348 kB]
Get:16 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libpango1.0-0 amd64 1.30.0-1 [461 kB]
Get:17 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libsm6 amd64 2:1.2.1-2 [34.2 kB]
Get:18 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxext6 amd64 2:1.3.1-2+deb7u1 [54.8 kB]
Get:19 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxt6 amd64 1:1.1.3-1+deb7u1 [212 kB]
Get:20 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxmu6 amd64 2:1.1.1-1 [66.6 kB]
Get:21 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxaw7 amd64 2:1.0.10-2 [226 kB]
Get:22 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main bc amd64 1.06.95-2+b1 [110 kB]
Get:23 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main less amd64 444-4 [135 kB]
Get:24 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-apt-common all 0.8.8.2 [115 kB]
Get:25 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-apt amd64 0.8.8.2 [319 kB]
Get:26 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-support all 1.0.15 [33.6 kB]
Get:27 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main ed amd64 1.6-2 [57.6 kB]
Get:28 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main fonts-liberation all 1.07.2-6 [1,323 kB]
Get:29 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main liberror-perl all 0.17-1 [23.6 kB]
Get:30 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main git-man all 1:1.7.10.4-1+wheezy1 [1,074 kB]
Get:31 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main git amd64 1:1.7.10.4-1+wheezy1 [6,683 kB]
Get:32 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main git-core all 1:1.7.10.4-1+wheezy1 [1,336 B]
Get:33 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libcdt4 amd64 2.26.3-14+deb7u2 [60.0 kB]
Get:34 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libcgraph5 amd64 2.26.3-14+deb7u2 [88.1 kB]
Get:35 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libgraph4 amd64 2.26.3-14+deb7u2 [74.0 kB]
Get:36 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libpathplan4 amd64 2.26.3-14+deb7u2 [65.3 kB]
Get:37 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libxdot4 amd64 2.26.3-14+deb7u2 [54.4 kB]
Get:38 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libgvc5 amd64 2.26.3-14+deb7u2 [544 kB]
Get:39 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libgvpr1 amd64 2.26.3-14+deb7u2 [244 kB]
Get:40 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main graphviz amd64 2.26.3-14+deb7u2 [378 kB]
Get:41 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main iso-codes all 3.41-1 [2,068 kB]
Get:42 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main libglib2.0-data all 2.33.12+really2.32.4-5 [1,607 kB]
Get:43 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-gnupginterface all 0.3.2-9.1 [21.0 kB]
Get:44 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-pycurl amd64 7.19.0-5 [87.6 kB]
Get:45 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main unattended-upgrades all 0.79.5+wheezy1 [49.2 kB]
Get:46 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main python-software-properties all 0.82.7.1debian1 [104 kB]
Get:47 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main shared-mime-info amd64 1.0-1+b1 [595 kB]
Get:48 http://gce_debian_mirror.storage.googleapis.com/ wheezy/main ttf-liberation all 1.07.2-6 [9,284 B]
Preconfiguring packages ...
Fetched 21.5 MB in 7s (2,724 kB/s)
Selecting previously unselected package libpixman-1-0:amd64.
(Reading database ... 24339 files and directories currently installed.)
Unpacking libpixman-1-0:amd64 (from .../libpixman-1-0_0.26.0-4+deb7u1_amd64.deb) ...
Selecting previously unselected package libxcb-render0:amd64.
Unpacking libxcb-render0:amd64 (from .../libxcb-render0_1.8.1-2+deb7u1_amd64.deb) ...
Selecting previously unselected package libxcb-shm0:amd64.
Unpacking libxcb-shm0:amd64 (from .../libxcb-shm0_1.8.1-2+deb7u1_amd64.deb) ...
Selecting previously unselected package libxrender1:amd64.
Unpacking libxrender1:amd64 (from .../libxrender1_1%3a0.9.7-1+deb7u1_amd64.deb) ...
Selecting previously unselected package libcairo2:amd64.
Unpacking libcairo2:amd64 (from .../libcairo2_1.12.2-3_amd64.deb) ...
Selecting previously unselected package libcurl3-gnutls:amd64.
Unpacking libcurl3-gnutls:amd64 (from .../libcurl3-gnutls_7.26.0-1+wheezy12_amd64.deb) ...
Selecting previously unselected package libdatrie1:amd64.
Unpacking libdatrie1:amd64 (from .../libdatrie1_0.2.5-3_amd64.deb) ...
Selecting previously unselected package libffi5:amd64.
Unpacking libffi5:amd64 (from .../libffi5_3.0.10-3_amd64.deb) ...
Selecting previously unselected package libglib2.0-0:amd64.
Unpacking libglib2.0-0:amd64 (from .../libglib2.0-0_2.33.12+really2.32.4-5_amd64.deb) ...
Selecting previously unselected package x11-common.
Unpacking x11-common (from .../x11-common_1%3a7.7+3~deb7u1_all.deb) ...
Selecting previously unselected package libice6:amd64.
Unpacking libice6:amd64 (from .../libice6_2%3a1.0.8-2_amd64.deb) ...
Selecting previously unselected package libthai-data.
Unpacking libthai-data (from .../libthai-data_0.1.18-2_all.deb) ...
Selecting previously unselected package libthai0:amd64.
Unpacking libthai0:amd64 (from .../libthai0_0.1.18-2_amd64.deb) ...
Selecting previously unselected package libxft2:amd64.
Unpacking libxft2:amd64 (from .../libxft2_2.3.1-1_amd64.deb) ...
Selecting previously unselected package fontconfig.
Unpacking fontconfig (from .../fontconfig_2.9.0-7.1_amd64.deb) ...
Selecting previously unselected package libpango1.0-0:amd64.
Unpacking libpango1.0-0:amd64 (from .../libpango1.0-0_1.30.0-1_amd64.deb) ...
Selecting previously unselected package libsm6:amd64.
Unpacking libsm6:amd64 (from .../libsm6_2%3a1.2.1-2_amd64.deb) ...
Selecting previously unselected package libxext6:amd64.
Unpacking libxext6:amd64 (from .../libxext6_2%3a1.3.1-2+deb7u1_amd64.deb) ...
Selecting previously unselected package libxt6:amd64.
Unpacking libxt6:amd64 (from .../libxt6_1%3a1.1.3-1+deb7u1_amd64.deb) ...
Selecting previously unselected package libxmu6:amd64.
Unpacking libxmu6:amd64 (from .../libxmu6_2%3a1.1.1-1_amd64.deb) ...
Selecting previously unselected package libxaw7:amd64.
Unpacking libxaw7:amd64 (from .../libxaw7_2%3a1.0.10-2_amd64.deb) ...
Selecting previously unselected package bc.
Unpacking bc (from .../bc_1.06.95-2+b1_amd64.deb) ...
Selecting previously unselected package less.
Unpacking less (from .../archives/less_444-4_amd64.deb) ...
Selecting previously unselected package python-apt-common.
Unpacking python-apt-common (from .../python-apt-common_0.8.8.2_all.deb) ...
Selecting previously unselected package python-apt.
Unpacking python-apt (from .../python-apt_0.8.8.2_amd64.deb) ...
Selecting previously unselected package python-support.
Unpacking python-support (from .../python-support_1.0.15_all.deb) ...
Selecting previously unselected package ed.
Unpacking ed (from .../archives/ed_1.6-2_amd64.deb) ...
Selecting previously unselected package fonts-liberation.
Unpacking fonts-liberation (from .../fonts-liberation_1.07.2-6_all.deb) ...
Selecting previously unselected package liberror-perl.
Unpacking liberror-perl (from .../liberror-perl_0.17-1_all.deb) ...
Selecting previously unselected package git-man.
Unpacking git-man (from .../git-man_1%3a1.7.10.4-1+wheezy1_all.deb) ...
Selecting previously unselected package git.
Unpacking git (from .../git_1%3a1.7.10.4-1+wheezy1_amd64.deb) ...
Selecting previously unselected package git-core.
Unpacking git-core (from .../git-core_1%3a1.7.10.4-1+wheezy1_all.deb) ...
Selecting previously unselected package libcdt4.
Unpacking libcdt4 (from .../libcdt4_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libcgraph5.
Unpacking libcgraph5 (from .../libcgraph5_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libgraph4.
Unpacking libgraph4 (from .../libgraph4_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libpathplan4.
Unpacking libpathplan4 (from .../libpathplan4_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libxdot4.
Unpacking libxdot4 (from .../libxdot4_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libgvc5.
Unpacking libgvc5 (from .../libgvc5_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package libgvpr1.
Unpacking libgvpr1 (from .../libgvpr1_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package graphviz.
Unpacking graphviz (from .../graphviz_2.26.3-14+deb7u2_amd64.deb) ...
Selecting previously unselected package iso-codes.
Unpacking iso-codes (from .../iso-codes_3.41-1_all.deb) ...
Selecting previously unselected package libglib2.0-data.
Unpacking libglib2.0-data (from .../libglib2.0-data_2.33.12+really2.32.4-5_all.deb) ...
Selecting previously unselected package python-gnupginterface.
Unpacking python-gnupginterface (from .../python-gnupginterface_0.3.2-9.1_all.deb) ...
Selecting previously unselected package python-pycurl.
Unpacking python-pycurl (from .../python-pycurl_7.19.0-5_amd64.deb) ...
Selecting previously unselected package unattended-upgrades.
Unpacking unattended-upgrades (from .../unattended-upgrades_0.79.5+wheezy1_all.deb) ...
Selecting previously unselected package python-software-properties.
Unpacking python-software-properties (from .../python-software-properties_0.82.7.1debian1_all.deb) ...
Selecting previously unselected package shared-mime-info.
Unpacking shared-mime-info (from .../shared-mime-info_1.0-1+b1_amd64.deb) ...
Selecting previously unselected package ttf-liberation.
Unpacking ttf-liberation (from .../ttf-liberation_1.07.2-6_all.deb) ...
Processing triggers for man-db ...
Processing triggers for install-info ...
Processing triggers for mime-support ...
Setting up libpixman-1-0:amd64 (0.26.0-4+deb7u1) ...
Setting up libxcb-render0:amd64 (1.8.1-2+deb7u1) ...
Setting up libxcb-shm0:amd64 (1.8.1-2+deb7u1) ...
Setting up libxrender1:amd64 (1:0.9.7-1+deb7u1) ...
Setting up libcairo2:amd64 (1.12.2-3) ...
Setting up libcurl3-gnutls:amd64 (7.26.0-1+wheezy12) ...
Setting up libdatrie1:amd64 (0.2.5-3) ...
Setting up libffi5:amd64 (3.0.10-3) ...
Setting up libglib2.0-0:amd64 (2.33.12+really2.32.4-5) ...
No schema files found: doing nothing.
Setting up x11-common (1:7.7+3~deb7u1) ...
[ ok ] Setting up X socket directories... /tmp/.X11-unix /tmp/.ICE-unix.
Setting up libice6:amd64 (2:1.0.8-2) ...
Setting up libthai-data (0.1.18-2) ...
Setting up libthai0:amd64 (0.1.18-2) ...
Setting up libxft2:amd64 (2.3.1-1) ...
Setting up fontconfig (2.9.0-7.1) ...
Regenerating fonts cache... done.
Setting up libpango1.0-0:amd64 (1.30.0-1) ...
Setting up libsm6:amd64 (2:1.2.1-2) ...
Setting up libxext6:amd64 (2:1.3.1-2+deb7u1) ...
Setting up libxt6:amd64 (1:1.1.3-1+deb7u1) ...
Setting up libxmu6:amd64 (2:1.1.1-1) ...
Setting up libxaw7:amd64 (2:1.0.10-2) ...
Setting up bc (1.06.95-2+b1) ...
Setting up less (444-4) ...
Setting up python-apt-common (0.8.8.2) ...
Setting up python-apt (0.8.8.2) ...
Setting up python-support (1.0.15) ...
Setting up ed (1.6-2) ...
Setting up fonts-liberation (1.07.2-6) ...
Setting up liberror-perl (0.17-1) ...
Setting up git-man (1:1.7.10.4-1+wheezy1) ...
Setting up git (1:1.7.10.4-1+wheezy1) ...
Setting up git-core (1:1.7.10.4-1+wheezy1) ...
Setting up libcdt4 (2.26.3-14+deb7u2) ...
Setting up libcgraph5 (2.26.3-14+deb7u2) ...
Setting up libgraph4 (2.26.3-14+deb7u2) ...
Setting up libpathplan4 (2.26.3-14+deb7u2) ...
Setting up libxdot4 (2.26.3-14+deb7u2) ...
Setting up libgvc5 (2.26.3-14+deb7u2) ...
Setting up libgvpr1 (2.26.3-14+deb7u2) ...
Setting up graphviz (2.26.3-14+deb7u2) ...
Setting up iso-codes (3.41-1) ...
Setting up libglib2.0-data (2.33.12+really2.32.4-5) ...
Setting up python-gnupginterface (0.3.2-9.1) ...
Setting up python-pycurl (7.19.0-5) ...
Setting up unattended-upgrades (0.79.5+wheezy1) ...
Setting up python-software-properties (0.82.7.1debian1) ...
Setting up shared-mime-info (1.0-1+b1) ...
Setting up ttf-liberation (1.07.2-6) ...
Processing triggers for python-support ...
Cloning EasyEngine (ee) stable branch, please wait...
Cloning into '/tmp/easyengine'...
Installing EasyEngine (ee), please wait...
EasyEngine (ee) required your name & email address
to track changes you made under the Git version control
EasyEngine (ee) will be able to send you daily reports & alerts in upcoming version
EasyEngine (ee) will NEVER send your information across
git config user.name = Bamajr
git config user.email = bamajr@bamajr.com
For EasyEngine (ee) auto completion, run the following command
source /etc/bash_completion.d/ee
EasyEngine (ee) installed successfully
EasyEngine (ee) help: https://rtcamp.com/easyengine/docs/

When I run…

cat ~/.my.cnf

I get…

cat: /root/.my.cnf: No such file or directory

I also ran…

mysql -u root -p

and was able to log in with the MySQL Admin Password.

Finally, this was all done as root using the suggestion by @Chester to switch to root with…

sudo su

So, I’m at a loss! Can someone help? PLEASE?


#9

When using Debian 7 and the

sudo

command for installations, the default my.cnf location is:

/etc/mysql/my.cnf

not in:

~/.my.cnf

So my question is, should I copy the file to this location or will a symbolic link work just as good?

ln -s /etc/mysql/my.cnf ~/.my.cnf

#10

@bamajr,

EasyEngine ~/.my.cnf for storing MySQL root user name and password, so that it can easily access MySQL using myql command. Make sure that file is created and it has correct MySQL root user name and password so that your EasyEngine will work


#11

@gau1991 thanks for the post, but it took too long to get help, so I started over, using the instructions found here:

http://bamajr.us/InstallEasyEngine

I now know:

/etc/mysql/my.cnf

is not the same as:

~/.my.cnf

…so NO, a symbolic link to the first will not work.

It appears the ~/.my.cnf file only contains the following info:

[client]
user=root
password=<ROOT-MYSQL-PASSWORD>

… and this file doesn’t seem to get created when using the basic rtcamp installation instructions and the Google Developers Console, Compute Engine.

Before I’m asked, YES it’s possible I missed something, but I did try three times, on three fresh Debian 7 installations, all running on the Google Developers Console, Compute Engine. None of the three installation attempts created the ~/.my.cnf file, while the instructions found at the link I shared (top of this post), worked on the very first try.

Notably, the instructions found at the referenced link will not work with a remote database configuration.


#12

HI @bamajr,

Have you followed all the steps in https://rtcamp.com/easyengine/docs/remote-mysql/ for remote MySQL?


#13

Why would I do that? This installation didn’t have remote MySQL.


#14

I f you setup on RDS from amazon, you only edit two files:

vim ~/.my.cnf

[client] host=dns from amazon RDS>

user=user instance RDS

password= Pass

and

vim /etc/ee/ee.conf

Change to [mysql] grant-host= %


#15

FYI: I’m running on a Linode VM. Started having problems after upgrading to 3.0.4 today.

I think I have the same problem. It doesn’t look like it’s able to successfully create the database (based on logging into mysql as root and looking for supposedly set up database):


root# ee site create eeFudged.com --wpfc
Setting up NGINX configuration  [Done]
Setting up webroot              [Done]
Downloading Wordpress           [Done]
Setting up database             [Done]
Unable to Generate wp-config

Here’s what the log file has to say:

2015-03-08 16:02:09,523 (DEBUG) ee : logging initialized for 'ee' using LoggingLogHandler
2015-03-08 16:02:09,759 (DEBUG) ee : collecting arguments/commands for <ee.cli.controllers.base.EEBaseController object at 0x7f48a91ec5f8>
2015-03-08 16:02:09,761 (DEBUG) ee : collecting arguments/commands for <ee.cli.plugins.site.EESiteController object at 0x7f48a91ecac8>
2015-03-08 16:02:09,763 (DEBUG) ee : collecting arguments/commands for <ee.cli.plugins.site.EESiteCreateController object at 0x7f48a91eccc0>
2015-03-08 16:02:09,768 (DEBUG) ee : Setting apt_packages variable for Nginx
2015-03-08 16:02:10,992 (DEBUG) ee : Setting apt_packages variable for PHP
2015-03-08 16:02:12,274 (DEBUG) ee : Setting apt_packages variable for MySQL
2015-03-08 16:02:12,275 (DEBUG) ee : Running command: mysqladmin ping
2015-03-08 16:02:12,309 (DEBUG) ee : Setting apt_packages variable for Postfix
2015-03-08 16:02:13,625 (DEBUG) ee : Setting packages variable for WP-CLI
2015-03-08 16:02:13,625 (DEBUG) ee : Running command: which wp
2015-03-08 16:02:13,660 (INFO) ee : Setting up NGINX configuration
2015-03-08 16:02:13,661 (DEBUG) ee : loading template file /usr/lib/ee/templates/virtualconf.mustache
2015-03-08 16:02:13,664 (INFO) ee : [Done]
2015-03-08 16:02:13,664 (DEBUG) ee : Creating Symbolic link, Source:/etc/nginx/sites-available/eeFudged.com, Dest:/etc/nginx/sites-enabled/eeFudged.com
2015-03-08 16:02:13,664 (INFO) ee : Setting up webroot
2015-03-08 16:02:13,665 (DEBUG) ee : Creating Symbolic link, Source:/var/log/nginx/eeFudged.com.access.log, Dest:/var/www/eeFudged.com/logs/access.log
2015-03-08 16:02:13,665 (DEBUG) ee : Creating Symbolic link, Source:/var/log/nginx/eeFudged.com.error.log, Dest:/var/www/eeFudged.com/logs/error.log
2015-03-08 16:02:13,665 (INFO) ee : [Done]
2015-03-08 16:02:13,665 (INFO) ee : Downloading Wordpress
2015-03-08 16:02:13,666 (DEBUG) ee : Changing directory to /var/www/eeFudged.com/htdocs/
2015-03-08 16:02:13,666 (DEBUG) ee : Running command: wp --allow-root core download
2015-03-08 16:02:14,299 (INFO) ee : [Done]
2015-03-08 16:02:14,300 (INFO) ee : Setting up database
2015-03-08 16:02:14,300 (DEBUG) ee : Creating databse eeFudged_com
2015-03-08 16:02:14,300 (DEBUG) ee : Creating user eeFudged_com
2015-03-08 16:02:14,300 (DEBUG) ee : create user `eeFudged_com`@`%` identified by ''
2015-03-08 16:02:14,301 (DEBUG) ee : Setting up user privileges
2015-03-08 16:02:14,301 (INFO) ee : [Done]
2015-03-08 16:02:14,301 (DEBUG) ee : Changing directory to /var/www/eeFudged.com/htdocs/
2015-03-08 16:02:14,301 (DEBUG) ee : Setting up wp-config file
2015-03-08 16:02:14,301 (DEBUG) ee : Generating wp-config for WordPress Single site
2015-03-08 16:02:14,301 (DEBUG) ee : bash -c "php /usr/bin/wp --allow-root core config --dbname='eeFudged_com' --dbprefix='wp_' --dbuser='eeFudged_com' --dbhost='localhost' --dbpass= --extra-php<<PHP


define('WP_DEBUG', false);
PHP"
2015-03-08 16:02:14,416 (DEBUG) ee : Command Output: , Command Error: ERROR 1045 (28000): Access denied for user 'eeFudged_com'@'localhost' (using password: YES)

2015-03-08 16:02:14,417 (ERROR) ee : Unable to Generate wp-config

I checked /root/.my.cnf & the username and password work just fine to log into mysql as root.

Checked ee.conf file and changed the grant-host = % but something else seems to be a problem. Maybe ee isn’t seeing the .my.cnf file or something…

Any ideas?


#16

@ahmedreza

From you logs it seems that you have not set remote host in your .my.cnf file

checkout you .my.cnf file should look like this

[client]
user=xxxxxxxx
password=xxxxxxxx
host=x.x.x.x or domain name

#17

Hi @Nasrulhaq_Muiz

It’s been a long time, and we haven’t heard from you. It looks like your issue is resolved.

I am closing this support topic for now. Feel free to create a new support topic if you have any queries further. :slight_smile:


#18