How to configure a custom web app on bitnami nginx stack

Kabi 2016-11-16 04:25:07 UTC #1

Is there a detailed documentation on how to install and configure a custom php application on nginx server?, the one i saw is so mixed up with the apache documentation so i got lost in some occasions, i will appreciate any help offered. thank you in advance

silvio 2016-11-17 16:51:55 UTC #2

There was an error in the documentation, we are working in correct it. Meanwhile you can follow these instructions:

How To Create A Custom PHP Application?

Many users run a Bitnami stack as a development environment for their own PHP projects (as opposed to running third-party applications such as Joomla! or WordPress). To deploy your PHP application in this environment, you have two options:

To make a single PHP application accessible at the root URL of the Web server (for example, http://localhost), simply copy the PHP files into the /opt/bitnami/apache2/htdocs folder. For an example, take a look at the phpinfo example.

To have several applications running, create the same structure used by Bitnami when installing Bitnami PHP applications. Recent versions of Bitnami stacks ship a demo application with this structure to help you get started. To use this, follow the steps below:

Copy the /opt/bitnami/docs/demo folder into the /opt/bitnami/apps directory.

sudo cp -a /opt/bitnami/docs/demo /opt/bitnami/apps/

Add the following line to the end of the /opt/bitnami/nginx/conf/bitnami/bitnami-apps-prefix.conf file:

Include include "/opt/bitnami/apps/demo/conf/nginx-prefix.conf";

Restart the Nginx server using the command-line tool.

You should now be able to access the demo application at http://SERVER-IP/demo. You should see a "Hello world" message in your browser.


If your stack does not include a demo application, or if you prefer to create a custom PHP application from scratch, follow the steps below. These steps assume that your application will live in the ```/opt/bitnami/apps/myapp/``` directory:

Run the following commands to create the directories:

sudo mkdir /opt/bitnami/apps/myapp
sudo mkdir /opt/bitnami/apps/myapp/htdocs/
sudo mkdir /opt/bitnami/apps/myapp/conf

Create and edit the /opt/bitnami/apps/myapp/conf/nginx-prefix.conf file and add the line below to it:

location /demo {
    alias "/opt/bitnami/apps/myapp/htdocs";
    include "/opt/bitnami/apps/myapp/conf/nginx-app.conf";
}

Create and edit the /opt/bitnami/apps/myapp/conf/nginx-app.conf file and add the content below to it. This is the main configuration file for your application, so modify it further depending on your application's requirements.

index index.php index.html index.htm; location ~ \.php$ { fastcgi_split_path_info ^(.+\.php)(/.+)$; fastcgi_read_timeout 300; fastcgi_pass unix:/opt/bitnami/php/var/run/www.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $request_filename; include fastcgi_params; }

Restart the Nginx server:

```sudo /opt/bitnami/ctlscript.sh restart nginx```
You should now be able to access the application at http://SERVER-IP/myapp.

If you want to use a configuration using virtual hosts instead of prefix you mus esti the /opt/bitnami/apps/myapp/conf/nginx-vhost.conf in this way

```
server {
    listen    80;
    root   "/opt/bitnami/apps/demo/htdocs";
    server_name  demo.example.com www.demo.example.com;
    include "/opt/bitnami/apps/demo/conf/nginx-app.conf";
}
server {
    listen    443 ssl;
    root   "/opt/bitnami/apps/demo/htdocs";
    server_name  demo.example.com www.demo.example.com;
    ssl_certificate      "/opt/bitnami/apps/demo/conf/certs/server.crt";
    ssl_certificate_key  "/opt/bitnami/apps/demo/conf/certs/server.key";
       ssl_session_cache    shared:SSL:1m;
       ssl_session_timeout  5m;
    ssl_ciphers  HIGH:!aNULL:!MD5;
    ssl_prefer_server_ciphers  on;
    include "/opt/bitnami/apps/demo/conf/nginx-app.conf";
}

Restart the Nginx server:

sudo /opt/bitnami/ctlscript.sh restart nginx
You should now be able to access the application at http:/demo.example.com

| NOTE: You must have your host file or DNS well setted in order to work.

Kabi 2016-11-21 11:59:53 UTC #3

Thank you much @silvio, i have one last question, what is the default database name for the nginx server?

crhernandez 2016-11-22 12:33:11 UTC #4

By default, nginx server is not associated with any database. The database is created when you install the application, so you can find the database name when your application is successfully installed.

Here, you can find and example to install WordPress on top of the Bitnami nginx stack.

I hope this information is useful for you. If you have any other question, please do not hesitate to let us know.

Best Regards,
Carlos R. Hernández

shokah 2016-11-22 17:11:52 UTC #5

Hi @crhernandez, after successfully installing the application, how do you access the database name of your installed application?, like, how do you know the new installed application database name?

crhernandez 2016-11-22 18:00:11 UTC #6

If you are installing a custom application, you must specify manually the database properties, for example:

 $ installdir/mysql/bin/mysql -u root -p
 ...
 mysql> create database myAppDB;
 mysql> grant all privileges on myAppDB.* to 'myAppUser'@'localhost' identified by 'MYAPP-PASSWORD';
 mysql> exit

Keep in mind that you must replace the MYAPP-PASSWORD placeholder with a user-defined password that you will also later use when installing myApp.

You can find the complete information in our documentation: https://docs.bitnami.com/installer/infrastructure/nginx/#how-can-i-install-wordpress-on-top-of-the-bitnami-nginx-stack

Best regards,
Carlos R. Hernández

shokah 2016-11-22 18:25:15 UTC #7

Thank you @crhernandez , this is the error am getting while trying to implement your solution bitnami@ip-172-31-53-143:~$ $ installdir/mysql/bin/mysql -u root -p $: command not found bitnami@ip-172-31-53-143:~$ ... ...: command not found bitnami@ip-172-31-53-143:~$ mysql> create database bitnami_new; bitnami@ip-172-31-53-143:~$ mysql> grant all privileges on bitnami_new.* to 'bitnami_new'@'localhost' identified by '@mbigwa143'; bitnami@ip-172-31-53-143:~$ mysql> exit ERROR 1045 (28000): Access denied for user 'bitnami'@'localhost' (using password: NO) bitnami@ip-172-31-53-143:~$
Kindly shed on some light on this, will apreciate much

crhernandez 2016-11-22 18:57:35 UTC #8

Please, you should follow this guide, but changing WordPress for the application that you want.

The command that I posted in the below answer only refers to the initialization of the database, a small section of the guide that you should follow. You must have a database previously installed, you can download MySQL here and you can find the information you need in our documentation.

Some tips to follow this guide:

$ is the prompt of your shell, it is not a command.
installdir refer to the place where you installed the application, server, databaseClient, etc.
mysql> is the prompt indicating that you're inside of mysql-client.
I recommend you run the commands one by one, not together.

Best regards,
Carlos R. Hernández

shokah 2016-11-23 03:57:38 UTC #9

Thankyou @crhernandez, i will certainly follow the documentation, but i am facing slight challenges, like this command seems not to work at all installdir/ infact for a simple task like restarting nginx, it's totally impossible with it, i get a command not found error when i use sudo installdir/ctlscript.sh restart nginx but it's possible with sudo /opt/bitnami/ctlscript.sh restart nginx , what can be the problem?

shokah 2016-11-23 04:08:03 UTC #10

Also if possible kindly shed some light on this error=> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql

crhernandez 2016-11-23 09:05:46 UTC #11

Yes, it is a normal behavior because installdir/ is not a real directory, you must substituting installdir/ by the directory where you have the application installed, by default /opt/bitnami/.

This is an error related to your SQL syntax. After you connect with your database running /opt/bitnami/mysql/bin/mysql -u root -p and you see the mysql prompt mysql>, you can follow this step to create the database https://docs.bitnami.com/installer/components/mysql/#how-to-create-a-database-for-a-custom-application

Best regards,
Carlos R. Hernández

shokah 2016-11-23 16:45:42 UTC #12

Thank you @crhernandez , unfortunately i am still receiving an error when trying to create the data base, the logs show it's a permission denied issue.
The error after running the create database new_app; is mysql> create database new_app; ERROR 1006 (HY000): Can't create database 'new_app' (errno: 13) mysql>
The error log shows './mysql/proc.frm' (errno: 13 - Permission denied) 2016-11-22 17:57:32 2448 [ERROR] /opt/bitnami/mysql/bin/mysqld.bin: Can't find file: './mysql/proc.frm' (errno: 13 - Permission denied) 2016-11-22 17:57:43 2448 [ERROR] /opt/bitnami/mysql/bin/mysqld.bin: Can't find file: './mysql/proc.frm' (errno: 13 - Permission denied) 2016-11-22 17:57:43 2448 [ERROR] /opt/bitnami/mysql/bin/mysqld.bin: Can't find file: './mysql/proc.frm' (errno: 13 - Permission denied)
what can be the problem?

crhernandez 2016-11-24 17:34:23 UTC #13

Can you run the next command inside your mysql-client console (first /opt/bitnami/mysql/bin/mysql -u root -p) and paste here your output?

mysql> show grants;

Best regards,
Carlos R. Hernández

shokah 2016-11-24 18:36:47 UTC #14

Thank you @crhernandez , this is the output

 bitnami@ip-172-31-53-143:~$ /opt/bitnami/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 73
Server version: 5.6.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

No entry for terminal type "xterm";
using dumb terminal settings.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> mysql> show grants;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> show grants' at line 1
mysql>

crhernandez 2016-11-24 21:26:59 UTC #15

Please, note the clarifications that I mentioned you in a previous reply. You must run the command without mysql>.

Best regards,
Carlos R. Hernández

shokah 2016-11-26 18:32:40 UTC #16

Thank you @crhernandez ,i followed your lead closely but still receiving the following error

mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'xxxxxxxx' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> create database MY_DATABASE;
ERROR 1006 (HY000): Can't create database 'my_database' (errno: 13)
mysql>

Where can i be going wrong? kindly help

crhernandez 2016-11-28 15:11:22 UTC #17

Hi!

It seems that you are wrong permissions in your mysql installation directory. Can you run the next commands and paste here the output?

ls -la /opt/bitnami/mysql/data
ls -la /opt/bitnami/mysql/data/mysql

Best regards,
Carlos R. Hernández

shokah 2016-11-28 18:00:01 UTC #18

Thank youfor the response @crhernandez, after running the commands, this is the output i am getting

bitnami@ip-172-31-53-143:~$ ls -la /opt/bitnami/mysql/data
total 110640
drwxr-xr-x  5 bitnami daemon     4096 Nov 14 09:33 .
drwxr-xr-x 11 bitnami daemon     4096 Nov 14 09:33 ..
-rw-rw----  1 bitnami daemon       56 Oct 29 10:57 auto.cnf
-rw-rw----  1 bitnami daemon 12582912 Nov 14 09:33 ibdata1
-rw-rw----  1 bitnami daemon 50331648 Nov 14 09:33 ib_logfile0
-rw-rw----  1 bitnami daemon 50331648 Oct 29 10:57 ib_logfile1
-rw-r-----  1 bitnami daemon     6020 Nov 14 09:33 ip-172-31-53-143.err
drwx------  2 bitnami daemon     4096 Oct 29 10:57 mysql
-rw-r-----  1 bitnami daemon     8709 Nov 22 17:57 mysqld.log
-rw-rw----  1 bitnami daemon        5 Nov 14 09:33 mysqld.pid
drwx------  2 bitnami daemon     4096 Oct 29 10:57 performance_schema
drwxr-xr-x  2 bitnami daemon     4096 Oct 29 10:56 test
bitnami@ip-172-31-53-143:~$ ls -la /opt/bitnami/mysql/data/mysql
total 1696
drwx------ 2 bitnami daemon   4096 Oct 29 10:57 .
drwxr-xr-x 5 bitnami daemon   4096 Nov 14 09:33 ..
-rw-rw---- 1 bitnami daemon   8820 Oct 29 10:57 columns_priv.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 columns_priv.MYD
-rw-rw---- 1 bitnami daemon   4096 Oct 29 10:57 columns_priv.MYI
-rw-rw---- 1 bitnami daemon   9582 Oct 29 10:57 db.frm
-rw-rw---- 1 bitnami daemon    880 Oct 29 10:57 db.MYD
-rw-rw---- 1 bitnami daemon   5120 Oct 29 10:57 db.MYI
-rw-rw---- 1 bitnami daemon  10223 Oct 29 10:57 event.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 event.MYD
-rw-rw---- 1 bitnami daemon   2048 Oct 29 10:57 event.MYI
-rw-rw---- 1 bitnami daemon   8665 Oct 29 10:57 func.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 func.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 func.MYI
-rw-rw---- 1 bitnami daemon     35 Oct 29 10:57 general_log.CSM
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 general_log.CSV
-rw-rw---- 1 bitnami daemon   8776 Oct 29 10:57 general_log.frm
-rw-rw---- 1 bitnami daemon   8700 Oct 29 10:57 help_category.frm
-rw-rw---- 1 bitnami daemon   1120 Oct 29 10:57 help_category.MYD
-rw-rw---- 1 bitnami daemon   3072 Oct 29 10:57 help_category.MYI
-rw-rw---- 1 bitnami daemon   8612 Oct 29 10:57 help_keyword.frm
-rw-rw---- 1 bitnami daemon 120761 Oct 29 10:57 help_keyword.MYD
-rw-rw---- 1 bitnami daemon  22528 Oct 29 10:57 help_keyword.MYI
-rw-rw---- 1 bitnami daemon   8630 Oct 29 10:57 help_relation.frm
-rw-rw---- 1 bitnami daemon  11007 Oct 29 10:57 help_relation.MYD
-rw-rw---- 1 bitnami daemon  21504 Oct 29 10:57 help_relation.MYI
-rw-rw---- 1 bitnami daemon   8770 Oct 29 10:57 help_topic.frm
-rw-rw---- 1 bitnami daemon 570188 Oct 29 10:57 help_topic.MYD
-rw-rw---- 1 bitnami daemon  22528 Oct 29 10:57 help_topic.MYI
-rw-rw---- 1 bitnami daemon  12982 Oct 29 10:57 innodb_index_stats.frm
-rw-rw---- 1 bitnami daemon  98304 Oct 29 10:57 innodb_index_stats.ibd
-rw-rw---- 1 bitnami daemon   8830 Oct 29 10:57 innodb_table_stats.frm
-rw-rw---- 1 bitnami daemon  98304 Oct 29 10:57 innodb_table_stats.ibd
-rw-rw---- 1 bitnami daemon   8898 Oct 29 10:57 ndb_binlog_index.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 ndb_binlog_index.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 ndb_binlog_index.MYI
-rw-rw---- 1 bitnami daemon   8586 Oct 29 10:57 plugin.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 plugin.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 plugin.MYI
-rw-rw---- 1 bitnami daemon   9996 Oct 29 10:57 proc.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 proc.MYD
-rw-rw---- 1 bitnami daemon   2048 Oct 29 10:57 proc.MYI
-rw-rw---- 1 bitnami daemon   8875 Oct 29 10:57 procs_priv.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 procs_priv.MYD
-rw-rw---- 1 bitnami daemon   4096 Oct 29 10:57 procs_priv.MYI
-rw-rw---- 1 bitnami daemon   8800 Oct 29 10:57 proxies_priv.frm
-rw-rw---- 1 bitnami daemon   1386 Oct 29 10:57 proxies_priv.MYD
-rw-rw---- 1 bitnami daemon   5120 Oct 29 10:57 proxies_priv.MYI
-rw-rw---- 1 bitnami daemon   8838 Oct 29 10:57 servers.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 servers.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 servers.MYI
-rw-rw---- 1 bitnami daemon  10719 Oct 29 10:57 slave_master_info.frm
-rw-rw---- 1 bitnami daemon  98304 Oct 29 10:57 slave_master_info.ibd
-rw-rw---- 1 bitnami daemon   9334 Oct 29 10:57 slave_relay_log_info.frm
-rw-rw---- 1 bitnami daemon  98304 Oct 29 10:57 slave_relay_log_info.ibd
-rw-rw---- 1 bitnami daemon   9230 Oct 29 10:57 slave_worker_info.frm
-rw-rw---- 1 bitnami daemon  98304 Oct 29 10:57 slave_worker_info.ibd
-rw-rw---- 1 bitnami daemon     35 Oct 29 10:57 slow_log.CSM
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 slow_log.CSV
-rw-rw---- 1 bitnami daemon   9016 Oct 29 10:57 slow_log.frm
-rw-rw---- 1 bitnami daemon   8955 Oct 29 10:57 tables_priv.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 tables_priv.MYD
-rw-rw---- 1 bitnami daemon   4096 Oct 29 10:57 tables_priv.MYI
-rw-rw---- 1 bitnami daemon   8636 Oct 29 10:57 time_zone.frm
-rw-rw---- 1 bitnami daemon   8624 Oct 29 10:57 time_zone_leap_second.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 time_zone_leap_second.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 time_zone_leap_second.MYI
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 time_zone.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 time_zone.MYI
-rw-rw---- 1 bitnami daemon   8606 Oct 29 10:57 time_zone_name.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 time_zone_name.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 time_zone_name.MYI
-rw-rw---- 1 bitnami daemon   8686 Oct 29 10:57 time_zone_transition.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 time_zone_transition.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 time_zone_transition.MYI
-rw-rw---- 1 bitnami daemon   8748 Oct 29 10:57 time_zone_transition_type.frm
-rw-rw---- 1 bitnami daemon      0 Oct 29 10:57 time_zone_transition_type.MYD
-rw-rw---- 1 bitnami daemon   1024 Oct 29 10:57 time_zone_transition_type.MYI
-rw-rw---- 1 bitnami daemon  10684 Oct 29 10:57 user.frm
-rw-rw---- 1 bitnami daemon    668 Nov 14 09:33 user.MYD
-rw-rw---- 1 bitnami daemon   2048 Nov 14 09:33 user.MYI
bitnami@ip-172-31-53-143:~$

crhernandez 2016-11-29 09:37:47 UTC #19

Your MySQL permissions and user/group are wrong. You can fix it running:

sudo chown -R mysql:root /opt/bitnami/mysql/data
sudo chmod -R 640 /opt/bitnami/mysql/data/mysql

At this moment you can run:

/opt/bitnami/mysql/bin/mysql -u root -p
...
mysql> create database myAppDB;
mysql> grant all privileges on myAppDB.* to 'myAppUser'@'localhost' identified by 'MYAPP-PASSWORD';
mysql> exit

Best regards,
Carlos R. Hernández

shokah 2016-12-01 13:52:54 UTC #20

Thank you @crhernandez i followed your guide and it worked, now the problem is am getting an error while installing my web app, this is the error i am receiving SQLSTATE[HY000] [1045] Access denied for user 'shokah'@'localhost' (using password: YES)

My configurations are;

Host -localhost
Database Name- mydatabase
Username  -shokah
Password -the one i created here =>grant all privileges on myAppDB.* to 'myAppUser'@'localhost' identified by 'MYAPP-PASSWORD';
Prefix  i left blank

Am i missing something?
I successfully created the database mydatabase and granted local host powers to shokah
Kindly guide me where i am going wrong

Powered by Discourse, best viewed with JavaScript enabled

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!

SugarCRM

Drupal

WordPress

Joomla!

Redmine