1 aa513bf8 2023-01-22 jrmu version=pmwiki-2.2.130 ordered=1 urlencoded=1
2 aa513bf8 2023-01-22 jrmu agent=Mozilla/5.0 (X11; OpenBSD amd64; rv:76.0) Gecko/20100101 Firefox/76.0
4 aa513bf8 2023-01-22 jrmu charset=UTF-8
6 aa513bf8 2023-01-22 jrmu ctime=1597226457
7 aa513bf8 2023-01-22 jrmu host=38.81.163.143
8 aa513bf8 2023-01-22 jrmu name=Openbsd.Oscommerce
11 aa513bf8 2023-01-22 jrmu text=When initially setting up oscommerce, one must first create a database and a user for said database, and the database server should be set to 127.0.0.1 when installing oscommerce (not localhost) in order to function correctly.%0a%0aAlso make sure that /etc/resolv.conf has been coped to /var/www/etc, one can do so with the following command:%0a%0acp /etc/resolv.conf /var/www/etc%0a%0aThe SQL command to create a database is as follows:%0a%0aCREATE DATABASE databasename;%0a%0aThe SQL command to create a user and grant said user permissions to use the database created previously are as follows:%0a%0aGRANT ALL PRIVILEGES ON databasename.* TO "oscuser"@"localhost" IDENTIFIED BY "password";%0a%0aAfter both are created, the permissions should be flushed with the following command:%0a%0aFLUSH PRIVILEGES;%0a%0aThe following section applies only if you are accepting cryptocurrency payments with globee:%0aIn globee module settings, make sure your currency is set to the fiat currency you're listing your prices in, for example if you're listing your prices in USD, make sure you type in USD and only USD, as by default many currencies are there (which should be erased).%0a%0aYou also must move your /etc/cert.pem into the chroot, which can be done with the following command:%0a%0amkdir -p /var/www/etc/ssl && cp /etc/ssl/cert.pem /var/www/etc/ssl%0a%0a
12 aa513bf8 2023-01-22 jrmu time=1597226457
13 aa513bf8 2023-01-22 jrmu author:1597226457=jrmu
14 aa513bf8 2023-01-22 jrmu diff:1597226457:1597226457:=1,25d0%0a%3c When initially setting up oscommerce, one must first create a database and a user for said database, and the database server should be set to 127.0.0.1 when installing oscommerce (not localhost) in order to function correctly.%0a%3c %0a%3c Also make sure that /etc/resolv.conf has been coped to /var/www/etc, one can do so with the following command:%0a%3c %0a%3c cp /etc/resolv.conf /var/www/etc%0a%3c %0a%3c The SQL command to create a database is as follows:%0a%3c %0a%3c CREATE DATABASE databasename;%0a%3c %0a%3c The SQL command to create a user and grant said user permissions to use the database created previously are as follows:%0a%3c %0a%3c GRANT ALL PRIVILEGES ON databasename.* TO "oscuser"@"localhost" IDENTIFIED BY "password";%0a%3c %0a%3c After both are created, the permissions should be flushed with the following command:%0a%3c %0a%3c FLUSH PRIVILEGES;%0a%3c %0a%3c The following section applies only if you are accepting cryptocurrency payments with globee:%0a%3c In globee module settings, make sure your currency is set to the fiat currency you're listing your prices in, for example if you're listing your prices in USD, make sure you type in USD and only USD, as by default many currencies are there (which should be erased).%0a%3c %0a%3c You also must move your /etc/cert.pem into the chroot, which can be done with the following command:%0a%3c %0a%3c mkdir -p /var/www/etc/ssl && cp /etc/ssl/cert.pem /var/www/etc/ssl%0a%3c %0a
15 aa513bf8 2023-01-22 jrmu host:1597226457=38.81.163.143
