+- Las Venturas Playground (https://forum.sa-mp.nl)
+-- Forum: Main Talk (https://forum.sa-mp.nl/forum-3.html)
+--- Forum: Development (https://forum.sa-mp.nl/forum-16.html)
+--- Thread: server running error (/thread-33936.html)
Pages:
1
2
server running error - bidowhab - 05-19-2017
i am trying to run LVP server for testing it and such things , anyway i get this error while trying to run the server , so any ideas ?
Quote:----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team
Server Plugins
--------------
Loading plugin: echo-plugin
Failed.
Loading plugin: json-plugin
Failed.
Loading plugin: mysql-plugin
Failed.
Loading plugin: playgroundjs-plugin
Failed.
Loading plugin: zone-manager-plugin
Failed.
Loading plugin: streamer
Failed.
Loading plugin: sscanf
Failed.
Loaded 0 plugins.
Started server on port: 1337, with maxplayers: 50 lanmode is OFF.
Filterscripts
---------------
Loading filterscript 'cameditor.amx'...
--------------------------------------
CamEditor by Drebin
--------------------------------------
Loading filterscript 'textdraweditor.amx'...
--------------------------------------
Text Draw Editor 1.0RC2 by Zamaroht for SA-MP 0.3 Loaded.
--------------------------------------
Loaded 2 filterscripts.
Script[gamemodes/lvp.amx]: Run time error 19: "File or function is not found"
Number of vehicle models: 0
RE: server running error - Winnie - 05-19-2017
Seems like your plugins are not loaded properly, which is causing this problem. make sure you have all the plugins in the plugins folder, and then make sure to check server.cfg and check weather the plugins are mentioned in the server.cfg or not. if you are running the server on windows make sure to remove .so from each plugin mentioned in .cfg, since .so works for linux not for windows.
I hope it works.
RE: server running error - Yassine - 05-19-2017
Hello,
I experienced this bug from 4 month ago
to fix you should download plugin one by one not from here https://github.com/LVPlayground/server-staging/tree/master/server/plugins
not from package and same as v8.dll and log-core.dll
exemple:
open one plugin it will show u page like that https://github.com/LVPlayground/server-staging/blob/master/server/plugins/echo-plugin.dll
then download and its fine
Yassine
RE: server running error - bidowhab - 05-20-2017
your answer helped alot Yassine , but anyway those two plugins still have an issue
"" Loading plugin: mysql-plugin
Failed.
Loading plugin: playgroundjs-plugin
Failed. ""
and can't find this log-core.dll
RE: server running error - Yassine - 05-20-2017
(05-20-2017, 10:51 AM)bidowhab Wrote: your answer helped alot Yassine , but anyway those two plugins still have an issue
"" Loading plugin: mysql-plugin
Failed.
Loading plugin: playgroundjs-plugin
Failed. ""
and can't find this log-core.dll
Hello
You need to downlaod those files like you did with plugins
https://github.com/LVPlayground/server-staging/blob/master/server/libmysql.dll
https://github.com/LVPlayground/server-staging/blob/master/server/libmysqlclient.so
https://github.com/LVPlayground/server-staging/blob/master/server/v8.dll
https://github.com/LVPlayground/server-staging/blob/master/server/v8_libbase.dll
https://github.com/LVPlayground/server-staging/blob/master/server/v8_libplatform.dll
and you need to install this too https://www.microsoft.com/en-gb/download/details.aspx?id=48145
make sure that you have Windows 8+ else the JS Playground plugin will not load correctly (java functions will not work)
Yassine
RE: server running error - bidowhab - 05-20-2017
all plugins are working now , but there is an sql error , sorry for taking so much of your time and thx for helping me so far
Quote:[13:19:43] |------------------------------------------------------------------------|
[13:19:43] | LAS VENTURAS PLAYGROUND - version 33.0.27912 - revision 5154 |
[13:19:43] |------------------------------------------------------------------------|
[13:19:43]
[13:19:43] Number of vehicle models: 0
[13:19:43] [connection] 127.0.0.1:62805 requests connection cookie.
[13:19:44] [connection] incoming connection: 127.0.0.1:62805 id: 0
[13:19:45] [npc:join] Gunther has joined the server (0:127.0.0.1)
[13:19:47] [INFO][mysql_module.cc4] Connection to 82.192.76.193:43891 succeeded.
[13:19:47] [Database] The connection with the database has been established.
[13:19:48] [MySQL] The connection with the database has been (re-)established.
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:idQueryFail(4) - rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:49] [ERROR][mysql_module.cc:191] MySQL (#1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] [INFO][mysql_module.cc:202] MySQL:- rejecting promise
[13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
[13:19:54] --- Server Shutting Down.
[13:19:54] [npc:part] Gunther has left the server (0:0)
[13:19:54] Plugin echo.dll got unloaded.
[13:19:54] [LVP] JSON Reader plugin unloaded.
[13:19:54] [LVP] MySQL plugin unloaded.
or how to make my own sql connection ?
RE: server running error - Yassine - 05-20-2017
Hello
You can create your own database for free using an website db4free.net using 3306 or mysql.db4free.net using port 3307
but i don't think LVP open source their MySQL Map (Dump), so hosting a new database will not change anything.
LVP Public Account is limited due to some guys abuse it i think so you need to pm an management or Developer that can give you MySQL map (.sql) file to host it by uself
Yassine
RE: server running error - Winnie - 05-20-2017
Try WAMP for local MySQL database.
RE: server running error - bidowhab - 05-21-2017
(05-20-2017, 11:15 PM)Winnie Wrote: Try WAMP for local MySQL database.
I am already using xampp , but i just want to know what tables and columns should i make
RE: server running error - George - 05-21-2017
(05-20-2017, 12:20 PM)bidowhab Wrote: [13:19:49] =========================
[13:19:49] Uncaught promise rejection: Error: MySQL error (1142): INSERT, UPDATE command denied to user 'lvp_public'@'45.245.31.116' for table 'settings'
[13:19:49] =========================
When creating MySQL database users, you will have the ability to define their privileges. For example, if you were working with cPanel, when setting privileges, you would this:
![[Image: WEFQEOa.png]](http://i.imgur.com/WEFQEOa.png)
As such, based on the provided server log you provided, you need to give your database user access to use the INSERT and UPDATE privileges.
The process to do this depends on how your server is configured. If you have a GUI, you can use it to add the privileges for you. If you're working via CLI, you should look at this: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql