Znote's Video tutorial, how to make a server, Failed.

[man boob]

I was following his tutorial, and came to the phpMyAdmin, where im suposed to make a new database and browse it to the file "forgottenserver.sql". But the one I dowloaded don't got that, here's the files

Is it any other file that I can use insted?

 

[Alvanea]

mysql.sql?

 

[man boob]

Oh, ofc, thanks ;d
@Update, error comes up when Im starting the exe

 

[lordad]

run your sql bro (xampp)
or uniserver what ever

 

[man boob]

I think I am

 

[Pteryx]

From my personal notes for server setup:
NB: I use XAMPP for now - I don't think that affects this text significantly, but it's in some of the directory names


Step 2. Configure the server's startup configuration file: \serverName\config.lua
-- Password type for OT Accounts (as entered into the client at login)
passwordType = "sha1" -- note - this is the only allowed value ifor TFS 1.0, so this entry is probably redundant.
-- SQL
sqlType = "MySQL"
-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "apocUser" -- Userid to MySql - ideally limited to the specific servers DB (Znote recommends uid = DB name)
mysqlPass = "apocuserPw" -- MySql password for the UID above
mysqlDatabase = "Apocalypse" -- DB name in MySQL, must have tables defined for that server level and Znote ACC level
mysqlPort = 3306 -- 3306 is default - this is from XAMPP/MySQl install



Step 4. Create the MySql database and tables for this server
Use phpMyAdmin to create a database corresponding to the name chosen above
Use phpMyAdmin to create the OT server's tables:
Select the database (displayed at the top of phpMyAdmin's main screen)
Import (tab)
Grab the SQL script file for the server (\serverName\schema.sql) and run it ("go")
Use phpMyAdmin to create the Znote tables:
Start Znote: it will display a "help" page with a window containing SQL
Copy the SQL into the clipboard
Select the database
SQL (tab)
Paste and run the SQL

Status: The server can be started, but it's not possible to log in yet

Step 5. Start the OT server and connect to the client - this validates the basic server startup, the IpChanger, and the client
Start the server and check that the dos window doesn't show any alarming errors
Start the IpChanger, which will start the specified client
Check that the client starts
Exit the client and stop the IpChanger, but leave the OT server running

Status: ready to create an Account and a Character to test OT

Step 6. Generate an SHA1 password, then create an initial account using phpMyAdmin
Notes:
There is at least one site on the web that will generate an SHA1 value for you
On some servers the first account is created by the SQL that defines the database, but not all servers do this
Choose an account name and password
Generate an SHA1 version ofthe password (it will be 40 hex characters - save it to the clipboard)
Select the database, and table Accounts
Verify that Accounts is empty
Insert (tab)
Enter values for id (1), name (the account name you chose), password (the SHA1 values from the clipboard)
You don't need values for the other columns

Step 7.Start Znote and create a character
Notes:
Start Znote, and verify it's using your account name ("Welcome Xxx" on the right side of the screen)
Select "My Account" (right side of the screen) and create an account

Status: Ready to play OT

Step 8. Verify that the server is usable
Start the client via the IpChanger
Log in to your account
Select the new character and play

 

[EvilSkillz]

first you got this error because you put more dlls that tfs don't need
these two msvc

remove them

 

[man boob]

Yes I need them, oralse I get a debug..

Nothing is working to get rid of that "The program has stopped working"

 

[Pteryx]

The last console message before the "tfs-win64.exe" panel is that your OT userid isn't allowed access to your OT database.