Jump to content

  •  

chryxt

Member Since 09 Oct 2015
Offline Last Active Jun 04 2017 04:57 AM
-----

Posts I've Made

In Topic: [Function] Starter NPC

04 June 2017 - 01:04 AM

The files can't be opened, someone who already had it please kindly share with me please? Thank You :)


In Topic: Installing FluxCP

31 May 2017 - 10:04 AM

 

Well basically u have to link website with your server database, no need to link with your Web host database it just meaningless because your server database is located in VPS, so just link your server database with your site using servers.php which u can find in Config folder. 
 
In your servers.php
 
 
            'Hostname'   => 'Your vps ip',
            'Username'   => 'Sql Username', //bassically create another user and assign him permissions
            'Password'   => 'Sql user password',
            'Database'   => 'Database name',
       
This is your main config in your servers.php DbConfig, do same with LogsDbConfig and in your application.php use your web host IP.
 
Also even after doing this your VPS server SQL Database does not accept outside host to manipulate it, so there is one sql file you have to edit (i don't remember name right now, so u have to search google for it or maybe someone here know) after that your flux start working.
Check here for remote connection to mySql, just change bind-address = 0.0.0.0[/size] and restart and check

Thank You @caspe it's work perfectly!
What i do
1.  mysql_secure_installation
2.  GRANT ALL ON *.* TO '(user )'@'(webhost IP)' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;3. GRANT ALL ON *.* TO '(user)'@'%' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;4. FLUSH PRIVILEGES; 5. EXIT;
Never ever grant user access to all database, (for security reasons), I would recommend only grant to db which is required

@Dastgir
Is it like this?
GRANT ALL ON (dbfolder).* TO '(user )'@'(webhost IP)' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;

GRANT ALL ON (dbfolder).* TO '(user)'@'%' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;

FLUSH PRIVILEGES;

 

If i already grant user access to all database what i need to do to redo that?
Thank You :)

 


In Topic: Installing FluxCP

31 May 2017 - 08:14 AM

Well basically u have to link website with your server database, no need to link with your Web host database it just meaningless because your server database is located in VPS, so just link your server database with your site using servers.php which u can find in Config folder. 
 
In your servers.php

 

 

            'Hostname'   => 'Your vps ip',
            'Username'   => 'Sql Username', //bassically create another user and assign him permissions
            'Password'   => 'Sql user password',
            'Database'   => 'Database name',
       
This is your main config in your servers.php DbConfig, do same with LogsDbConfig and in your application.php use your web host IP.
 
Also even after doing this your VPS server SQL Database does not accept outside host to manipulate it, so there is one sql file you have to edit (i don't remember name right now, so u have to search google for it or maybe someone here know) after that your flux start working.

Check here for remote connection to mySql, just change bind-address = 0.0.0.0 and restart and check

Thank You @caspe it's work perfectly!
What i do

1.  mysql_secure_installation

2.  GRANT ALL ON *.* TO '(user )'@'(webhost IP)' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;
3. GRANT ALL ON *.* TO '(user)'@'%' IDENTIFIED BY '(passwd)' WITH GRANT OPTION;
4. FLUSH PRIVILEGES;
5. EXIT;


In Topic: Extended Vending is not working

15 February 2017 - 10:58 AM

plugins_list: [
	/* Enable HPMHooking when plugins in use rely on Hooking */
	"HPMHooking",
	//"db2sql",
	//"sample",
	//"other",
	"ExtendedVending",
	"partybuff",
	"restock",
	"security",
	"whobuy",
	"whosell",
]
MYPLUGINS = whosell whobuy security restock partybuff ExtendedVending

HPMHook is enabled

up, i got same problem