http://wiki.prometheusipn.com/api.php?action=feedcontributions&feedformat=atom&user=NewjorciksPrometheusIPN Wiki - User contributions [en]2026-05-04T15:48:11ZUser contributionsMediaWiki 1.29.0http://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3574Installation:lua prerequisites2020-01-05T11:43:57Z<p>Newjorciks: </p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend MySQLoo, but you can use tMySQL as well. This documentation only covers MySQLoo as tMySQL is deprecated.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://github.com/syl0r/MySQLOO/releases/ here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here: <br />
<br />
(You need to create the lua/bin folder manually if you do not already have it.)<br />
<br />
[[File:Bin.png]]<br />
<div style="text-decoration: line-through"><br />
You are also going to need either [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll libmysql] on Windows or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18 libmysqlclient] on Linux.<br />
They have to be placed within the root folder of your server (the one that contains srcds.exe or srcds_run)<br />
</div><br />
As of the latest MySQLoo version (9.6 and newer) you no longer need the second file(libmysql) on the server. So if you use MySQLoo 9.6 or newer you only need the first, MySQLoo file.<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3547Installation:debugging2018-12-31T12:23:19Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== "Lost connection to MySQL server during query" ====<br />
* Your MySQL server has too low read timeout values for the connection distance/speed between your MySQL server and your GMod server.<br />
*To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@local.net_read_timeout=300;<br />
SET @@global.net_read_timeout=300;<br />
<br />
<br />
==== "Can’t connect to local MySQL server through socket /tmp/mysql.sock" ====<br />
* Use "127.0.0.1" instead of "localhost" as the hostname.<br />
* Keep in mind that 127.0.0.1 can be used when the the MySQL server is on the same exact machine as the server trying to connect to it(Gmod server or web server).<br />
* If they aren't on the same machine you will have to use the public IP of the MySQL server and enable remote connections on the MySQL server.<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
* Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
* The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
* Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
<br />
====The DONATE button in !donate menu does nothing ====<br />
* You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
* Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
<br />
==== Cannot log in, after steam sends back without logging in. ====<br />
* If you are using HTTPS on your website you need to make sure $using_ssl is set to true in config.php<br />
<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== 500 Internal server error ====<br />
* Give the 'cache' folder 777 recursive permissions as specified in the web installation. If that doesn't work, please create a ticket containing your PHP error log.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin -> General settings -> Payment Gateways -> PayPal -< IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https for your site)<br />
* Also make sure you have done this: http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3546Installation:debugging2018-12-31T12:22:09Z<p>Newjorciks: Added "Can’t connect to local MySQL server through socket /tmp/mysql.sock".</p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== "Lost connection to MySQL server during query" ====<br />
* Your MySQL server has too low read timeout values for the connection distance/speed between your MySQL server and your GMod server.<br />
*To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@local.net_read_timeout=300;<br />
SET @@global.net_read_timeout=300;<br />
<br />
<br />
==== "Can’t connect to local MySQL server through socket /tmp/mysql.sock" ====<br />
* Use "127.0.0.1" instead of "localhost" as the hostname.<br />
* Keep in mind that 127.0.0.1 can be used when the the MySQL server is on the same exact machine as the server trying to connect to it(Gmod server or web server).<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
* Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
* The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
* Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
<br />
====The DONATE button in !donate menu does nothing ====<br />
* You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
* Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
<br />
==== Cannot log in, after steam sends back without logging in. ====<br />
* If you are using HTTPS on your website you need to make sure $using_ssl is set to true in config.php<br />
<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== 500 Internal server error ====<br />
* Give the 'cache' folder 777 recursive permissions as specified in the web installation. If that doesn't work, please create a ticket containing your PHP error log.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin -> General settings -> Payment Gateways -> PayPal -< IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https for your site)<br />
* Also make sure you have done this: http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3545Installation:debugging2018-12-29T11:48:22Z<p>Newjorciks: Added "Lost connection to MySQL server during query"</p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== "Lost connection to MySQL server during query" ====<br />
* Your MySQL server has too low read timeout values for the connection distance/speed between your MySQL server and your GMod server.<br />
*To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@local.net_read_timeout=300;<br />
SET @@global.net_read_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
* Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
* The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
* Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
<br />
====The DONATE button in !donate menu does nothing ====<br />
* You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
* Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
<br />
==== Cannot log in, after steam sends back without logging in. ====<br />
* If you are using HTTPS on your website you need to make sure $using_ssl is set to true in config.php<br />
<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== 500 Internal server error ====<br />
* Give the 'cache' folder 777 recursive permissions as specified in the web installation. If that doesn't work, please create a ticket containing your PHP error log.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin -> General settings -> Payment Gateways -> PayPal -< IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https for your site)<br />
* Also make sure you have done this: http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Integration:gateways&diff=3531Integration:gateways2018-03-07T17:23:30Z<p>Newjorciks: /* Payment Gateways */</p>
<hr />
<div>====== Payment Gateways ======<br />
Current payment gateways:<br />
* PayPal<br />
* Paymentwall<br />
* Stripe<br />
* Credits (Purchased using any of the previously listed Payment Gateways)<br />
<br />
====== PayPal ======<br />
* Visit your Paypal account(Both sandbox and not sandbox) at [https://www.paypal.com/cgi-bin/customerprofileweb?cmd=_profile-ipn-notify this] link. Go to "My selling tools" and find "Instant Payment Notification". Set the URL to the same as your Prometheus' IPN URL(Admin->General Settings->Payment Gateways->PayPal) and activate IPN URL on Paypal.<br />
<br />
Like the following:<br />
<br />
[[File:paypal1.png|900px]]<br />
<br />
[[File:paypal2.png|900px]]<br />
<br />
* Test your system with PayPal Sandbox and if everything works fine turn off sandbox and you're good to go :)<br />
<br />
====== Paymentwall ======<br />
In order to use paymentwall you need to modify a few things on your PaymentWall controlpanel:<br />
<br />
[[File:paymentwall.png|800px]]<br />
<br />
'''You need to add four custom pingback parameters'''<br />
<br />
* goodstype -> own<br />
* price -> own<br />
* cur -> own<br />
* coupon -> own '''- THIS ONE IS NEW AS OF 1.6.2'''<br />
<br />
You also need to set your pingback url to <code>http://yourprometheus.com/donate/paymentwall.php</code><br />
<br />
The secret key and project keys are found on your Paymentwall "My projects" page. Review key should be left blank and widget key is by default p10<br />
<br />
Now submit your project for review and hope that they accept you and don't tell you that I haven't set up some user API bullshit they want to enforce.<br />
<br />
====== Credits ======<br />
Credits is a virtual currency within Prometheus. The only setting you'll be able to set in the credits options is the ability to only use credits as payment for packages / raffles.<br />
<br />
====== Stripe ======<br />
<br />
The first thing you need to do is sign in to your Stripe account.<br />
Now make sure your account is set to live, and properly set up. Then go to your user in the top right and click account settings.<br />
<br />
[[File:stripe1.png|800px]]<br />
<br />
You will now be greeted with this screen. Click "API Keys" and retrieve your live secret key and your live publishable key<br />
<br />
[[File:stripe2.png|800px]] <br />
<br />
They have to be copied and pasted into Prometheus' Payment Gateways -> Stripe settings.<br />
<br />
API Key is the secret key, publishable key is the publishable key<br />
<br />
[[File:stripe3.png|800px]]</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3529Installation:debugging2018-01-05T21:00:18Z<p>Newjorciks: Added not being able to log in web side</p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
* Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
* The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
* Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
<br />
====The DONATE button in !donate menu does nothing ====<br />
* You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
* Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
<br />
==== Cannot log in, after steam sends back without logging in. ====<br />
* If you are using HTTPS on your website you need to make sure $using_ssl is set to true in config.php<br />
<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== 500 Internal server error ====<br />
* Give the 'cache' folder 777 recursive permissions as specified in the web installation. If that doesn't work, please create a ticket containing your PHP error log.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin -> General settings -> Payment Gateways -> PayPal -< IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https for your site)<br />
* Also make sure you have done this: http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Modding&diff=3522Modding2017-08-13T20:19:15Z<p>Newjorciks: /* Lua */</p>
<hr />
<div>=== Web ===<br />
Anyone is allowed to create modifications to prometheus code which they can share or even sell, as long as these requirements are met:<br />
* The person sharing/selling the modification has purchases Prometheus.<br />
* Amount of files changed is the minimal possible(Only files that MUST be modified should be modified and shared, adding unnecessary stuff to a file only for it to be shareable is also violation of this requirement)<br />
* You must state on the modification page that it is a derivative work of Prometheus, and also link to Prometheus’ addon page<br />
* You must also state that adding the modification to Prometheus will mean that any errors or problems involving stuff the modification changes will NOT be helped with by the Prometheus support team.<br />
* Your modification must be freely accessible by the Prometheus support team(Can be done after requested by us)<br />
* '''The modification can't contain Prometheus files from any of these files/folders:''' (you can put any class files in inc/classes and run them from any file loaded elsewhere, they autoload)<br />
** /inc/functions.php<br />
** /cache/*<br />
** /vendor/*<br />
** /cert/*<br />
** /inc/lib/*<br />
** /mods/*<br />
** install.php<br />
** ipn.php<br />
** paymentwall.php<br />
** inc/classes/verification.class.php<br />
** inc/classes/paymentwall.class.php<br />
** inc/classes/stripe.class.php<br />
** inc/classes/update.class.php<br />
** inc/classes/cache.class.php<br />
** inc/classes/mods.class.php<br />
<br />
* No modifications regarding license verification<br />
* You need to inform the user that is downloading your modification of the files modified BEFORE they are required to pay(So they can check if any other modifications they already have, have modified a file yours has as well)<br />
* The modification MUST include a modification info file located in “mods” folder, example of syntax can be found in examplemod.txt (Make the filename as unique as you can)<br />
You are allowed to include new files/folders of your own to any folder as long as they do not replace any of Prometheus files/folders. This includes /vendor, but only through the use of composer.<br />
=== Lua ===<br />
==== Usable hooks: ====<br />
* PrometheusAddActions<br />
** Arguments: none<br />
** Add any custom actions inside this hook using Prometheus.AddAction function(Described lower)<br />
* PrometheusDBConnected<br />
** Arguments: none<br />
** Ran when Prometheus has just connected to the database<br />
* PrometheusDBInitialized<br />
** Arguments: none<br />
** Ran when Prometheus has fully connected to the database and has run any initializing queries<br />
* PrometheusInitialized<br />
** Arguments: none<br />
** Ran when Prometheus has fully loaded(All it’s functions/values have been created)<br />
* PrometheusRunningAction<br />
** Arguments:<br />
*** Table Table of players that this action will run on(Can contain SteamID strings or Player Objects)<br />
*** String Name of the action<br />
*** Table Table of values for that action<br />
*** Table Table of action data(steam64 of person, active status, expire time, etc)<br />
** Ran when Prometheus is running an action(For any custom new actions, use PrometheusAddActions hook instead, this is for informational purposes)<br />
<br />
==== Usable functions: ====<br />
* Prometheus.AddAction<br />
** Arguments:<br />
*** Table Table that contains these values:<br />
**** name String Name of the action<br />
**** runfunc Function Function that will run when the action is bought(Arguments are: Player object, Table of values for that action, Table of action data)<br />
**** endfunc Function Functions that will run when the action has expired or deactivated(Arguments are: Player object, Table of values for that action, Table of action data)<br />
** Use this to create your own custom actions(Keep in mind you need to also mod web side to be able to save/buy that action).<br />
** Examples of actions can be found in actions.lua file.<br />
<br />
'''Preferably don't modify Prometheus Lua files.'''<br />
<br />
Rather create your own separate add-on that uses the hooks/function overwrites to modify Prometheus Lua side, while not modifying files is almost impossible in PHP, in Lua it's pretty easy.<br />
<br />
Pretty much anything you would need to do can be acquired by using the hooks, if that isn't enough, you can use function overwrites, example of tapping into a function called "testFunc":<br />
<br />
local oldFunc = testFunc<br />
<br />
testFunc = function(...)<br />
<br />
args = {...}<br />
<br />
-- Do anything here with the arguments, original function will still run by running the oldFunc(...)<br />
<br />
oldFunc(...)<br />
<br />
end<br />
{| class="wikitable" !File / Folder <br />
|- | / inc functions.php |- cache * vendor cert lib mods |install.php |ipn.php |paymentwall.php |inc classes verification.class.php paymentwall.class.php stripe.class.php update.class.php cache.class.php mods.class.php |}<br />
<br />
|}</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3505Installation:lua prerequisites2017-06-29T20:05:06Z<p>Newjorciks: </p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend MySQLoo, but you can use tMySQL as well.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here: <br />
<br />
(You need to create the lua/bin folder manually if you do not already have it.)<br />
<br />
[[File:Bin.png]]<br />
<br />
You are also going to need either [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll libmysql] on Windows or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18 libmysqlclient] on Linux.<br />
They have to be placed within the root folder of your server (the one that contains srcds.exe or srcds_run)<br />
<br />
<br />
<br />
==== tMySQL ('''Discontinued, not recommended!''') ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3504Installation:lua prerequisites2017-06-29T20:04:55Z<p>Newjorciks: /* Installing prerequisites for Prometheus' lua portion */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend MySQLoo, but you can use tMySQL as well.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here: <br />
<br />
(You need to create the lua/bin folder manually if you do not already have it.)<br />
[[File:Bin.png]]<br />
<br />
You are also going to need either [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll libmysql] on Windows or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18 libmysqlclient] on Linux.<br />
They have to be placed within the root folder of your server (the one that contains srcds.exe or srcds_run)<br />
<br />
<br />
<br />
==== tMySQL ('''Discontinued, not recommended!''') ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3503Installation:lua prerequisites2017-06-29T20:04:43Z<p>Newjorciks: </p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend MySQLoo, but you can use tMySQL as well.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here: <br />
(You need to create the lua/bin folder manually if you do not already have it.)<br />
[[File:Bin.png]]<br />
<br />
You are also going to need either [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll libmysql] on Windows or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18 libmysqlclient] on Linux.<br />
They have to be placed within the root folder of your server (the one that contains srcds.exe or srcds_run)<br />
<br />
<br />
<br />
==== tMySQL ('''Discontinued, not recommended!''') ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3502Installation:lua prerequisites2017-06-29T20:03:50Z<p>Newjorciks: </p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend MySQLoo, but you can use tMySQL as well.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here:<br />
(You need to create the lua/bin folder manually if you do not already have it.)<br />
[[File:Bin.png]]<br />
<br />
You are also going to need either [][https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll libmysql] on Windows or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18 libmysqlclient] on Linux.<br />
They have to be placed within the root folder of your server (the one that contains srcds.exe or srcds_run)<br />
<br />
<br />
<br />
==== tMySQL ([[Discontinued, not recommended!]]) ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3494Installation:lua prerequisites2017-04-28T15:14:38Z<p>Newjorciks: /* MySQLoo */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows server use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3493Installation:lua prerequisites2017-04-28T15:14:19Z<p>Newjorciks: /* MySQLoo */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/ HERE] for Linux server use gmsv_mysqloo_linux.dll, but for Windows use gmsv_mysqloo_win32.dll, choose the latest release that has your version and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3492Installation:lua prerequisites2017-04-28T15:11:33Z<p>Newjorciks: /* tMySQL */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/bkacjios/gm_tmysql4/releases/download/R1.02/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/download/9.1/gmsv_mysqloo_win32.dll this for Windows] or [https://github.com/syl0r/MySQLOO/releases/download/9.1/gmsv_mysqloo_linux.dll this for Linux] and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3489Installation:lua prerequisites2017-01-18T12:34:27Z<p>Newjorciks: /* MySQLoo */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/blackawps/gm_tmysql4/releases/download/R1/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/blackawps/gm_tmysql4/releases/download/R1.01/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/releases/download/9.1/gmsv_mysqloo_win32.dll this for Windows] or [https://github.com/syl0r/MySQLOO/releases/download/9.1/gmsv_mysqloo_linux.dll this for Linux] and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3487Installation:debugging2017-01-02T21:12:03Z<p>Newjorciks: /* Packages are not given after people pay on PayPal */</p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin - General settings - PayPal - IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https ofor your site)<br />
* Also make sure you have done this: [http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal http://wiki.prometheusipn.com/index.php?title=Integration:gateways#PayPal]</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3485Installation:debugging2016-12-15T21:03:45Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin - General settings - PayPal - IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php (Make sure to use set it to https if you use https ofor your site)</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3484Installation:debugging2016-12-15T21:00:37Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin - General settings - PayPal - IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.com/donate/ipn.php</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3483Installation:debugging2016-12-15T20:58:47Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.<br />
==== Packages are not given after people pay on PayPal ====<br />
* Make sure your IPN link is correct in the web side settings under Admin - General settings - PayPal - IPN URL, it should be set to: http://YourUrlHere/FolderYouInstalledPrometheusIn/ipn.php for example http://example.php/donate/ipn.php</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3465Installation:debugging2016-11-06T22:34:22Z<p>Newjorciks: /* ISSUES ON SERVER */</p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled. Go to your steam settings - In-Game - check "Enable the Steam Overlay while in-game".<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3463Installation:debugging2016-10-08T15:48:25Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
==== !donate menu only shows 'Server has failed connecting to the database! Please contact the owner.' ====<br />
Check your server console for a message from Prometheus, after reading it consult 'WEB AND LUA ERRORS' portion of this page.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled.<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:debugging&diff=3462Installation:debugging2016-10-08T15:46:03Z<p>Newjorciks: </p>
<hr />
<div>If you have any issues with Prometheus you should always read this article first:<br />
=== WEB AND LUA ERRORS ===<br />
<br />
==== MySQL not connecting / "Server has failed connecting to the database. Please contact the owner!" ====<br />
<br />
* Make sure you have MySQL remote connections enabled on your webhost's controlpanel, and your GMod server's IP whitelisted. In case you haven't done so already, you need to make sure that you have [[Installation:Lua|installed your Tmysql/MySQLOO module]] correctly.<br />
* You can see exactly what is going wrong by checking your console and seeing what happens when the first player joins after the server restarts. All Prometheus error messages will have ''[Prometheus] DB connection error'' before the error.<br />
* If issues persist after trying these troubleshooting options, please [http://nmscripts.com/prometheus/support contact support].<br />
<br />
==== "Access denied for user 'X'@'XXX.XXX.XXX.XXX' (using password: YES)" ====<br />
* You have either entered your MySQL username and password wrong in your config file, or permission is not allowed for the IP address that is connecting.<br />
* If this message appears, make sure that remote connections are allowed from your website's control panel.<br />
<br />
==== "MySQL Server has gone away" ====<br />
<br />
* Set your refreshrate in your lua config to 15 seconds or less. Your MySQL server does not allow any connections that last longer than 15 seconds most likely, so it's timing out before its hitting the default 40.<br />
* To fix this run these two commands in your MySQL (If you can't, get your host to do it):<br />
SET @@GLOBAL.wait_timeout=300;<br />
SET @@LOCAL.wait_timeout=300;<br />
<br />
==== I do not receive the test message on my server ====<br />
<br />
* Enable the launch parameter -condebug on your server unless you are using TCAdmin 2.0 already.<br />
* '''If you are using TCAdmin2''' (or any web-console), view your server console upon starting your server and look for anything that starts with ''[Prometheus]''. CTRL+F is your friend so that you can find it more quickly.<br />
* If you are using -condebug, search for the same thing as if you were using TCAdmin2, but instead search the console.log file within your GMod servers "Garrysmod" directory<br />
<br />
==== I do receive the test message, but don't get the items in my server ====<br />
This can mean one of two things:<br />
* Your IPN url in General Settings -> Payment Gateways -> PayPal is wrong. <br />
* Your ServerID in your prometheus lua config is wrong. Make sure it's correct(Edit a server to find out its ID)<br />
<br />
Check your server console for any errors that might give you a hint of what the error is.<br />
<br />
If there are no errors there, also check the ipn_errors.log file for errors and contact support.<br />
<br />
===== Not getting any items on my server, and nothing appearing in the transaction log of Prometheus =====<br />
<br />
* You have not set up your Prometheus properly following this [[installation:website|installation tutorial]]. Your PayPal is receiving the money, but is not sending a pingback message to your webserver.<br><br> [[File:pingback.png|400px]] <br><br><br />
<br />
Your system is failing at the red arrow (Inbetween PayPal and your installation). You need to set your IPN URL in PayPal itself. See the installation tutorial link above.<br />
<br />
===== Not getting any items on my server, but something appearing in the transaction log of Prometheus =====<br />
<br />
* Your serverID is most likely incorrect in your lua config. To find your actual serverID go to Admin-> Servers and edit a server to see the ID.<br />
=== ISSUES ON SERVER ===<br />
==== !donate menu doesn't have packages I created ====<br />
The !donate menu ONLY shows the packages you have purchased or that ave been assigned to you.<br />
====The DONATE button in !donate menu does nothing ====<br />
You have your steam overlay disabled.<br />
==== The DONATE button in !donate menu opens wrong site ====<br />
Edit the prometheus_client_config.lua config and set the link to your site.<br />
=== WEB ISSUES ===<br />
==== Parse error unexpected '[' ====<br />
<br />
* You do not have the latest PHP 5.4 version or greater installed on your webserver. If this is the case, you need to update your PHP version from your website control panel. If 5.4+ is not available, contact your webhost's support team and request that they update it for you.<br />
<br />
==== When logging in, "An error occurred while processing your request. Reference #XX.XXXXXXXX.XXXXXXXXXX.XXXXXXX" ====<br />
* This is an issue with Steam. Please wait and it should resolve itself eventually. Please do not contact NMScripts support as there is nothing we can do about this.<br />
<br />
==== Permanent packages don't get assigned, the test message doesn't send either! Help! ====<br />
* This is due to your MySQL server not accepting invalid dates, this will only be an issue up until version 2.0. <br />
* To fix this, run the following MySQL query: <br />
* '''SET GLOBAL sql_mode ='TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* '''SET SESSION sql_mode = 'TRADITIONAL,ALLOW_INVALID_DATES;'''<br />
* Make sure to set this SQL_MODE in your MySQL config file too if you have access to it.</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3419Installation:lua prerequisites2016-08-01T23:19:05Z<p>Newjorciks: /* Installing prerequisites for Prometheus' lua portion */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/blackawps/gm_tmysql4/releases/download/R1/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/blackawps/gm_tmysql4/releases/download/R1.01/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/blob/master/out/windows/gmsv_mysqloo_win32.dll?raw=true this for Windows] or [https://github.com/syl0r/MySQLOO/blob/master/out/linux/gmsv_mysqloo_linux.dll?raw=true this for Linux] and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=File:Libmysql.png&diff=3418File:Libmysql.png2016-08-01T23:18:32Z<p>Newjorciks: </p>
<hr />
<div></div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=File:Bin.png&diff=3417File:Bin.png2016-08-01T23:18:20Z<p>Newjorciks: </p>
<hr />
<div></div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3416Installation:lua prerequisites2016-08-01T23:16:15Z<p>Newjorciks: </p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. We recommend tMySQL, but you can use MySQLoo as well.<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/blackawps/gm_tmysql4/releases/download/R1/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/blackawps/gm_tmysql4/releases/download/R1.01/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/blackawps/gm_tmysql4/releases/download/R1/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/blackawps/gm_tmysql4/releases/download/R1.01/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
[[File:Libmysql.png]]<br />
<br />
<br />
Download [https://github.com/syl0r/MySQLOO/blob/master/out/windows/gmsv_mysqloo_win32.dll?raw=true this for Windows] or [https://github.com/syl0r/MySQLOO/blob/master/out/linux/gmsv_mysqloo_linux.dll?raw=true this for Linux] and put it here:<br />
<br />
[[File:Bin.png]]<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorcikshttp://wiki.prometheusipn.com/index.php?title=Installation:lua_prerequisites&diff=3415Installation:lua prerequisites2016-08-01T21:47:02Z<p>Newjorciks: /* Installing prerequisites for Prometheus' lua portion */</p>
<hr />
<div>=== Installing prerequisites for Prometheus' lua portion ===<br />
Install the [[Installation:website|web files]] first<br />
<br />
You need to install either tMySQL or MySQLoo. You install the one that you find you need for other MySQL based addons as well.<br />
<br />
==== tMySQL ====<br />
<br />
[http://facepunch.com/showthread.php?t=1442438 Link to tMySQL]<br />
<br />
Download [https://github.com/blackawps/gm_tmysql4/releases/download/R1/gmsv_tmysql4_win32.dll this for Windows] or [https://github.com/blackawps/gm_tmysql4/releases/download/R1.01/gmsv_tmysql4_linux.dll this for Linux] and put it in ''garrysmod/garrysmod/lua/bin''<br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
==== MySQLoo ====<br />
The MySQLoo 9 module from [https://facepunch.com/showthread.php?t=1515853 here]<br />
<br />
Download [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/windows/libmysql.dll?raw=true this for windows] or [https://github.com/syl0r/MySQLOO/raw/master/MySQL/lib/linux/libmysqlclient.so.18?raw=true this for linux] and put it here:<br />
<br />
''(The image shows libMySQL.dll which is for windows, but if you're on linux libmysqlclient.so.18 goes here)''<br />
<br />
<br><br><br />
[[File:Lua1.png|900px]]<br />
<br><br><br />
<br />
Download [https://github.com/syl0r/MySQLOO/blob/master/out/windows/gmsv_mysqloo_win32.dll?raw=true this for Windows] or [https://github.com/syl0r/MySQLOO/blob/master/out/linux/gmsv_mysqloo_linux.dll?raw=true this for Linux] and put it here:<br />
<br />
<br><br><br />
[[File:Lua2.png|900px]]<br />
<br><br><br />
<br />
You need to create the lua/bin folder manually if you do not already have it.<br />
<br />
<br />
'''Done''' Continue with the [[Installation:lua|lua files]] installation</div>Newjorciks