Windows Problem with Znote AAc website

[Tyson12302]

I've made my 9.60 server. Now im ready to make the admin account. But im having problems getting up my Znote AAc website. When i go on Localhost it says that i cannot connect. I done everything that was said in Znote video. Can someone explain more fully on how to set up the website or can someone show me how to do it. Thanks.

 

[8408323]

You can not at all get to the page? It just says that you can't connect before you access it at first glance?

 

[Tyson12302]

You can not at all get to the page? It just says that you can't connect before you access it at first glance?

Yeah. It comes up with a page that says. Cannot connect to the database. It also has a 3 steps
1. Make sure you have imported TFS database. (OTdir/forgottenserver.sql OR OTdir/schemas/mysql.sql
2. Import the below schema to a TFS database in phpmyadmin:
3. Edit config.php with correct mysql connection details.
I did all of them and it still brings it up.
http://snag.gy/y3rwp.jpg

 

[8408323]

Send me your config.php
You can send in private message if you don't want to publish your password

 

[Tyson12302]

// Available options: TFS_02, TFS_03
// TFS 0.2 = TFS_02
// TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
// TFS 0.4 = TFS_03
$config['TFSVersion'] = 'TFS_02';

$config['site_title'] = 'Znote AAC';
$config['site_title_context'] = 'Because open communities are good communities. :3';


// phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
$config['sqlUser'] = 'otserv';

// phpmyadmin password for OT server:
$config['sqlPassword'] = 'polska2009';

// The database name to connect to. (This is usually same as username).
$config['sqlDatabase'] = 'otserv';

// Hostname is usually localhost or 127.0.0.1.
$config['sqlHost'] = 'localhost';

$config['time'] = time();
//$config['time'] = time() + (+3 * 3600); // adjust clock by +3 hours.

I guess thats all you need to see.

 

[8408323]

Just asking quite simple questions to make sure these things are correct.

Are you using TFS 0.2?

$config['TFSVersion'] = 'TFS_02';

And the sql username is otserv?

$config['sqlUser'] = 'otserv';

Correct password?

$config['sqlPassword'] = 'polska2009';

Correct database?

$config['sqlDatabase'] = 'otserv';

Sometimes you need to change

$config['sqlHost'] = 'localhost';

into

$config['sqlHost'] = '127.0.0.1';

I know that could be a problem with modern AAC at least. Let me know if it doesn't work!

 

[Tyson12302]

Does it matter if i use the newest AAC or do i have to use the one that was used in the video (1.0) or is the 1.4 fine to use
And im using TFS 0.2.14.

 

[8408323]

I'm using 1.4 , with tfs 1.0 and it works fine, and have tried with tfs 0.3 and it works fine.
Updated the last message a little, just make sure all those things are correct, thanks!

 

[Tyson12302]

IT Worked!! Thanks
But i think theres another problem. When i create a account a error come up

• Failed to recognize your IP address. (Not a valid IPv4 address).

 

[8408323]

Did it work when you changed to

127.0.0.1

?

 

[Tyson12302]

Did it work when you changed to

127.0.0.1

?

Yes.
But as always there's another problem. Ever seen that error when creating a account?

 

[8408323]

Try to change "createcharacter.php" search for

if (validate_ip(getIP()) === false && $config['validate_IP'] === true) {
                $errors[] = 'Failed to recognize your IP address. (Not a valid IPv4 address).';

and change it to

if (validate_ip(getIP()) === false && $config['validate_IP'] === false) {
                $errors[] = 'Failed to recognize your IP address. (Not a valid IPv4 address).';

I think you need to do the same thing in "register.php"! Let me know if that solves your new problem.

 

[Tyson12302]

It worked. Thank bro.

 

[8408323]

No problems, you're welcome! Just glad to help!
Let me know if you encounter any further problems.

 

[Tyson12302]

Ok. I dont think this is a problem but i cant log in on tibia with my new made account.

 

[8408323]

What error does the client print?

 

[Tyson12302]

It just says that the account or password is incorrect but its not.
I tried changing password and logging off on the website and putting in the acc and pass. It works in the site but not on the tibia client.

 

[8408323]

Well, that's probably because you have wrong encryption-type in your config.lua, try to copy the password created in phpmyadmin. Or write your password here http://www.sha1.cz/ and copy the sring underneath. And paste it in the password field.

 

[Tyson12302]

The password automatically changes at the password field.
Tried those and i still cant log on. Also i created a account using the account manager, i tried to log it in the website and it says its wrong. but its right on tibia. Its like none of the accounts connect.

 

[8408323]

Strange, note sure what causes this. Are all tables & queries imported?