• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Change database directory

Sort by date Sort by votes
Are you talking about the mysql connection files (www/db or smth) or the database names (znote_shop, znote_accounts etc)?
 
Upvote 0 Downvote
hejd12345 said:
How can I change this directory and let ZnoteACC search for my database somewhere else?
https://i.imgur.com/hmJIVgl.png
Click to expand...
Its not needed to change that directory, thats just an example of where you can find the .sql file.

Just upload the database file from your TFS folder to PHPMyAdmin or whatever your using.
 
Upvote 0 Downvote
HalfAway said:
Its not needed to change that directory, thats just an example of where you can find the .sql file.

Just upload the database file from your TFS folder to PHPMyAdmin or whatever your using.
Click to expand...
Already done but the main reason I asked the first question is that I do not know how to connect my database to my webhotel/doamin I have bought. I have uploaded all the sql files to my webhotel and when I try to connect to my website and its domain I get this, https://i.imgur.com/hmJIVgl.png.

I think I need to change something in connect.php or config.php but I do not know what. :(
 
Upvote 0 Downvote
  • Did you use phpMyAdmin to create a database?
  • Did you use the TFS .sql script to create the TFS tables?
  • Did you use the Znote SQL in that web page to create the Znote tables?
  • Did you find Znote's config.php file and read it?
 
Upvote 0 Downvote
I am using phpmyadmin and I have created the tables/ znote tables by hosting the website on my own computer, using uniserver. I do not know how to make my webhotel to read my config.php. I have just copy/pasted the whole "www" folder with my website into my webhotel and now I need help from someone. I do not know what I need to change in the config files to make the webhotel find my database on my own computer.
 
Upvote 0 Downvote
There's still some information missing from your question. Please be clear about where the different components are located.

You have one or more instances of:
  • An OT server (program, configuration, and data files)
  • A MySql database
  • A web server
Please specify what you have, and where each component is located.
 
Upvote 0 Downvote
So you need to modify the Znote config.php on binero.se to point to your MySql, or move the OT server to binero.se.

The Znote video here: http://otland.net/threads/znotes-video-tutorials-for-ot-servers-updated-4th-april.137957/
shows how to set up and modify the Znote configuration.

Note: I can't test this myself because I don't have a remote Web Server - don't blame me if it doesn't work :)

Modify Znote's config.php. The section for connecting to MySql looks like this:
Code: 
// ------------------------ \\
// MYSQL CONNECTION DETAILS \\
// ------------------------ \\
  
// phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
$config['sqlUser'] = 'MySqlUserForOtServer';
  
// phpmyadmin password for OT server:
$config['sqlPassword'] = 'MySqlPwForOtServer';
  
// The database name to connect to.
$config['sqlDatabase'] = 'MySqlDbNameForOtServer';
  
// Hostname or IP address
$config['sqlHost'] = 'hostNameOfYourPc';

Put in the correct values for your environment and see what happens.
I don't know if you can change the port, but it uses the default MySql port (3306) ok.
Note the userid and password in clear text. Make sure you understand the security implications of this.

You need a "real" IP address to make it work.
localhost and 127.0.0.1 are only visible in your PC. 192.168.x.x and 10.x.x.x are non-routable networks, and binero.se probably can't find you on those. The possible exception would be if binero.se is your ISP, in which case they may have a mechanism for this set up already.

Also the web site won't start if MySql on your PC isn't available to it (it will show the page you posted above).
 
Upvote 0 Downvote
Pteryx said:
So you need to modify the Znote config.php on binero.se to point to your MySql, or move the OT server to binero.se.

The Znote video here: http://otland.net/threads/znotes-video-tutorials-for-ot-servers-updated-4th-april.137957/
shows how to set up and modify the Znote configuration.

Note: I can't test this myself because I don't have a remote Web Server - don't blame me if it doesn't work :)

Modify Znote's config.php. The section for connecting to MySql looks like this:
Code: 
// ------------------------ \\
// MYSQL CONNECTION DETAILS \\
// ------------------------ \\
 
// phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
$config['sqlUser'] = 'MySqlUserForOtServer';
 
// phpmyadmin password for OT server:
$config['sqlPassword'] = 'MySqlPwForOtServer';
 
// The database name to connect to.
$config['sqlDatabase'] = 'MySqlDbNameForOtServer';
 
// Hostname or IP address
$config['sqlHost'] = 'hostNameOfYourPc';

Put in the correct values for your environment and see what happens.
I don't know if you can change the port, but it uses the default MySql port (3306) ok.
Note the userid and password in clear text. Make sure you understand the security implications of this.

You need a "real" IP address to make it work.
localhost and 127.0.0.1 are only visible in your PC. 192.168.x.x and 10.x.x.x are non-routable networks, and binero.se probably can't find you on those. The possible exception would be if binero.se is your ISP, in which case they may have a mechanism for this set up already.

Also the web site won't start if MySql on your PC isn't available to it (it will show the page you posted above).
Click to expand...
Umm, I have done everything you said but the Znote video thread link you posted, the videos in it does not work. But now I get a new error: https://i.imgur.com/5zTeZSO.png
 
Upvote 0 Downvote
Back
Top