This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
openbsd:oscommerce [2020/05/04 01:47] locust created |
openbsd:oscommerce [2020/05/04 01:48] (current) locust |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Also make sure that /etc/resolv.conf has been coped to /var/www/etc, one can do so with the following command: | Also make sure that /etc/resolv.conf has been coped to /var/www/etc, one can do so with the following command: | ||
| + | |||
| cp /etc/resolv.conf /var/www/etc | cp /etc/resolv.conf /var/www/etc | ||
| The SQL command to create a database is as follows: | The SQL command to create a database is as follows: | ||
| + | |||
| CREATE DATABASE databasename; | CREATE DATABASE databasename; | ||
| The SQL command to create a user and grant said user permissions to use the database created previously are as follows: | The SQL command to create a user and grant said user permissions to use the database created previously are as follows: | ||
| + | |||
| GRANT ALL PRIVILEGES ON databasename.* TO "oscuser"@"localhost" IDENTIFIED BY "password"; | GRANT ALL PRIVILEGES ON databasename.* TO "oscuser"@"localhost" IDENTIFIED BY "password"; | ||
| After both are created, the permissions should be flushed with the following command: | After both are created, the permissions should be flushed with the following command: | ||
| + | |||
| FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
| Line 17: | Line 21: | ||
| You also must move your /etc/cert.pem into the chroot, which can be done with the following command: | You also must move your /etc/cert.pem into the chroot, which can be done with the following command: | ||
| - | mkdir -p /var/www/etc/ssl && cp /etc/ssl/cert.pem /var/www/etc/ss | + | |
| + | mkdir -p /var/www/etc/ssl && cp /etc/ssl/cert.pem /var/www/etc/ssl | ||