Installation fails due to mysql pass

Tanuj · October 19, 2015, 11:43am

My installation fails due to the following error:

Installing for centos 6 amd64
In case you encounter an error, you can post on https://discuss.frappe.io

Adding centos mariadb repo
Installing packages for centos. This might take time...
Installing wkhtmltopdf
Installing supervisor
Starting supervisord: 
Error: Another program is already listening on a port that one of our HTTP servers is configured to use.  Shut this program down first before starting supervisord.
For help, use /usr/bin/supervisord -h
frappe:frappe-web                RUNNING   pid 2076, uptime 2:01:49
frappe:frappe-worker             RUNNING   pid 2075, uptime 2:01:49
frappe:frappe-workerbeat         RUNNING   pid 2077, uptime 2:01:49
node-socketio                    RUNNING   pid 2079, uptime 2:01:49
redis-async-broker               RUNNING   pid 2078, uptime 2:01:49
redis-cache                      FATAL     Exited too quickly (process log may have details)
Configuring CentOS services
Starting services
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Could someone please help me out?
Thanks!

anand · October 19, 2015, 12:14pm

@Tanuj,

Seems you have an existing mariadb setup. Delete the folders bench-repo and frappe-bench, and try running it with:

sudo bash setup_frappe.sh --setup-production --mysql-root-password YourRootPassword

anand · October 19, 2015, 12:15pm

Also, you seem to have existing setup on port 8000. Are you trying to install 2 benches on the same server?

Tanuj · October 19, 2015, 12:27pm

Second time i was trying to install. mysql failed the first time too.

Tanuj · October 19, 2015, 12:30pm

I’m still getting the same error, despite entering the password for mysql

pdvyas · October 19, 2015, 9:03pm

Start with a clean and minimal install of CentOS and Ubuntu, and run the script.

anand · October 20, 2015, 2:33am

Try using the latest CentOS

Tanuj · October 20, 2015, 10:21am

Thanks!
I installed the latest CentOS, and the script ran successfully.

But now, I’m unable to access the site either via “localhost”, localhost:8000"or through the IP of the server followed by “:8000”

Please help!

Thank You!

anand · October 20, 2015, 12:18pm

SSH into your centos server and run curl localhost or curl localhost:8000 and check its output

Tanuj · October 20, 2015, 12:51pm

Hi @anand
I’m not with the server anymore, but curl gave me the html file of what I assume is ERPNext.

The netstat output showed the following:

Is this correct?

anand · October 20, 2015, 1:29pm

could be firewall issue.

Best,
Anand Doshi

ERPNext

Tanuj · October 21, 2015, 6:02am

Hi @anand!
Thanks a lot for your help!
I opened ports 80 and 8000, and I can load the ERPNext through port 80.

But the site doesn’t look right.

I’ve restarted bench, but that doesn’t help.

Any suggestions?

Thank you!

anand · October 21, 2015, 7:00am

Check your browser’s console and network tab. Look for requests in red.

Also, try refreshing the browser or clearing its cache.

Best,
Anand Doshi

ERPNext

Tanuj · October 21, 2015, 7:07am

I’ve been trying to upload a screenshot of the error console since my last post, but the uploading is stuck at 100%.

The following errors are shown:

[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (jquery.min.js, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (website.css, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (frappe-web.min.js, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (bootstrap.css, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (frappe-web.css, line 0)
[Error] Failed to load resource: the server responded with a status of 404 (Not Found) (erpnext-web.min.js, line 0)
[Warning] Invalid CSS property declaration at: / (website_theme.css, line 130)
[Error] ReferenceError: Can’t find variable: $
(anonymous function)
[Error] ReferenceError: Can’t find variable: $
(anonymous function)
[Error] ReferenceError: Can’t find variable: __
(anonymous function)
(anonymous function)

Tanuj · October 21, 2015, 9:34am

@anand Ive updated nginx, and now i get a 403 Forbidden error.

anand · October 26, 2015, 5:42am

@Tanuj you will have to debug this via nginx logs

Tanuj · October 26, 2015, 10:24am

@anand I did a fresh install of CentOS 7 on ANOTHER PC, and I’m still facing this issue:

System19 · October 27, 2015, 12:23am

Those are odd errors.
On Centos 7 I use the minimal install then install the epel and update both.
To make sure you are protected from GHOST run sudo yum update glibc
Before I run the frappe script I would make sure MySQL is uninstalled or not installed. Also make sure you are not running any firewall at this piont.
I would then install the latest version of MariaDB,
Then install Pillow:
sudo yum install libtiff-devel libjpeg-devel libzip-devel freetype-devel lcms2-devel libwebp-devel tcl-devel tk-devel
Then run the frappe script.
Once finished make note of the password located in you top directory, Log out and log back in as user frappe.
You will be in /home/frappe/ so cd into ~/frappe/frappe-bench/ and then run bench update and see if works.
Good Luck.
Also make sure you have at least 1 GB RAM. 2GB is better.

Tanuj · October 28, 2015, 10:08am

@System19 Thanks for your advice

Followed those exact instructions.

Did a clean install of CentOS 7 - Minimal (On a server this time)
Installed glibc
Stopped firewalld.service
Installed Pillow
Ran the frappe script and updated it

BUT still getting the exact same 404 problem.

System19 · October 28, 2015, 10:47am

@Tanuj Can you post the 404 errors that you are getting on the new server?
Did you Install epel?
sudo yum install epel-release
Also you did all of this as root or su?