[Guide] Allods 1.1.02.0 Server Setup on Windows

[fido67]

Yes, I found the console, but what exactly should I write?

CREATE USER 'allods_online'@'localhost';

GRANT ALL PRIVILEGES ON . TO 'allods_online'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;


You enter those 3 sql command in your mysql command prompt

 

[nikizrya]

CREATE USER 'allods_online'@'localhost';

GRANT ALL PRIVILEGES ON . TO 'allods_online'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;


You enter those 3 sql command in your mysql command prompt

it didn't help but thanks anyway)

 

[fido67]

Uhm , first remove the space of your path , its avoid to have some issue : C:\allods 1.0\server\
and second try :

CREATE USER ''@'localhost';

GRANT ALL PRIVILEGES ON . TO ''@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;


xd i dont promise that it will works

 

[meyouect]

Hello
I have a problem with character name creation

 

[fido67]

Hello
I have a problem with character name creationView attachment 2705

Hi
In /shard/cfg/shard.xml

in the line

<content territory="Russia" pack="Base"/>

replace by :

<content territory="USA" pack="Base"/>

 

[milowdruida]

i need help again

 

[Ninjazz]

A java class from client must be edited to allow other IP than local ip

Could you elaborate on that at all? Finally got everything up and running and would love to make it lan accessible for my wife to join in.

 

[Ninjazz]

Could you elaborate on that at all? Finally got everything up and running and would love to make it lan accessible for my wife to join in.

Nevermind, after plenty of digging through .class files, working a few things out, and revisiting this forum to see what was off, I discovered this:

<config name="AOSRV" comment="" build="Debug" serversNeed="1" maxUsers="5000">

That config name line makes all the difference, as apparently it checks if something is named "*_local" and forces the 127.0.0.1 IP address rule.
Otherwise it seems to happily accept whatever.
Got mine working over my lan now, happily.

 

[GeneralZod]

Someone can help me with this?

 

[adastmin]

Кто-нибудь может помочь мне с этим?
[/ЦИТИРОВАТЬ]
Сheack cfg billing ip

 

[morg]

it didn't help but thanks anyway)

Hey there Community,

first of all big thanks for all the Guides and Fixes and Helps. After a terrible long time, beginner me got everything up and running. Also thanks to google.

I had the same problem as you nikizrya and maybe someone else has too. So here is how it works:

Do all steps as fido described and enter in MySQL the following:

CREATE USER 'allods_online'@'localhost';

GRANT ALL PRIVILEGES ON * . * TO 'allods_online'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Beware that you enter * . * without the spaces. If you write it without spaces (as fido did here) you may get the bold function of the text, so it seems no stars are there. This combo is a reference to your database.

Other way: Go to your phpMyAdmin->User->chose user "allods_online" with host "localhost" and change rights/privileges. You can then manually change to "ALL PRIVILEGES" and "GRANT"-Option "yes". After you apply, it will show you the correct code on the top of the website. (but it will overwrite you privileges to nullify them).
So you can copy the line that says "GRANT ALL PRIVILEGES ON * . * TO 'allods_online'@'localhost' WITH GRANT OPTION;"
into your WAMP MySQL Console and it should work fine, with no danger of any typos.
After that FLUSH PRIVILEGES; to save the settings, reload phpMyAdmin and voila.

I hope this helps someone and is not too obvious

 

[meyouect]

Hello, a year ago I managed to install a virtualization, but alas the hard disk was lost during the move
So I sit down to do it all over again, I remember it was easy. Yeah, not easy. Help me, please.

If its important I tried different amount of memory 1,2,3,4,5gb

Spoiler: accountserver

<?xml version="1.0" encoding="utf-8"?>
<config name="test_trunk_shard" build="Debug" serversNeed="1" mapServicesAmount="1">
  <net basePort="9000" datagramPort="8000" bindPortsRange="15"/>
  <logging args="logging.channels.local.LocalChannelEngineFactory --defaultlogpath --logpath=/local/temp --format=CSV --start"/>

  <accountServer maxUsersOnShard="1000" clientsLimit="50" build="builds/standard.xml" versionOnLogin="-1" memory="500" ip="127.0.0.1">
    <approve ip="127.0.0.1" port="9318"/>
    <auth ip="127.0.0.1" port="9317" timeout="300000"/>
    <api protocol="http" host="127.0.0.1" port="9337"/>
    <db host="127.0.0.1" user="postgres" password="1234" config="accountserverdb-config-pgsql.properties"/>
  </accountServer>
</config>

Spoiler: MasterServer

<?xml version="1.0" encoding="utf-8"?>
<config>
  <resourceSystem restrictedMapsLoading="true" checkResourceSystemIndex="false"/>

  <masterServer memory="1024" ip="127.0.0.1">
    <db host="127.0.0.1" user="root" password="" config="masterserverdb-config-trunk.properties"/>
    <net ip="127.0.0.1" port="9500"/>
    <api ip="127.0.0.1" port="10500"/>
  </masterServer>
</config>

Spoiler: shard

<?xml version="1.0" encoding="utf-8"?>
<config name="trunk_local" comment="" build="Debug" serversNeed="1" maxUsers="5000">
  <net basePort="10000" consoleAccessPort="9856"/>
  <resourceSystem storeXdbLinks="true" useInternalization="true"/>

  <content territory="USA" pack="Base"/>

  <logging kind="local">
    <local format="csv"/>
    <remote host="localhost" port="8888"/>
  </logging>

  <shard role="LocalShard" memory="" ip="127.0.0.1">
    <frontEnd externalHost="127.0.0.1" ip="127.0.0.1" port="9322" timeout="60000"/>
    <db host="127.0.0.1" user="allods_online" password="" config="db/database-config-trunk.properties"/>
    <auction host="127.0.0.1" user="allods_online" password="" db="db/auctiondb-config-trunk.properties"/>
    <mail host="127.0.0.1" user="allods_online" password="" db="db/maildb-config.properties"/>
    <guild host="127.0.0.1" user="allods_online" password="" db="db/guilddb-config.properties"/>
    <http host="127.0.0.1" port="82"/>
    <indicator/>
    <doorway/>
  </shard>

  <itemMallServer>
    <net ip="127.0.0.1" port="9321" reconnect-timeout="30"/>
  </itemMallServer>

  <accountServer maxUsersOnShard="1000" build="builds/standard.xml">
    <approve ip="127.0.0.1" port="9318"/>
    <auth ip="127.0.0.1" port="9317" timeout="30000"/>
    <api protocol="http" host="127.0.0.1" port="9337"/>
  </accountServer>

  <masterServer>
    <net ip="127.0.0.1" port="9500"/>
    <api ip="127.0.0.1" port="10500"/>
  </masterServer>

  <billingServer>
    <net port="9320" host="127.0.0.1"/>
    <api port="8080" host="-1"/>
  </billingServer>

  <resourceErrorsEnabled>false</resourceErrorsEnabled>

  <gameMechanics>
    <characterCreation allowDiffFactions="true"/>
    <character levelCap="42"/>
    <shipRate build="1" buildReduce="1"/>
    <mobExpRate>1</mobExpRate>
    <questExpRate>1</questExpRate>
  </gameMechanics>

  <!-- use fake address of gametool - 127.0.0.2 - to avoid same ip as local shard -->
  <gametoolEAR ip="127.0.0.2" lang="rus">
    <standard-gametool-config>
      <mode name="single"/>
      <instance name="Trunk shard"/>
      <database-defaults>
        <default-gametool-database port="5432" database="gametool" login="gametool" password="gametool"/>
        <default-logserver-database host="127.0.0.1" port="5432" database="logserver" login="logserver" password="logserver"/>
      </database-defaults>
      <master address="127.0.0.1" login="*" password="*"/>
      <shard id="trunk_local" name="trunk_local" address="127.0.0.1"
             login="*" password="*"/>
    </standard-gametool-config>
  </gametoolEAR>

</config>

Spoiler: billingServer

<?xml version="1.0" encoding="utf-8"?>
<config name="cbt_local" build="Debug" serversNeed="8" mapServicesAmount="1">

  <logging kind="local">
    <local format="csv"/>
  </logging>

  <billingServer ip="127.0.0.1">
    <net port="9320" host="127.0.0.1"/>
    <api port="8080" host="127.0.0.1"/>
    <db host="127.0.0.1" user="allods_online" password="" config="billingdb-config-trunk.properties"/>
  </billingServer>
</config>

Spoiler: ItemMall

<?xml version="1.0" encoding="utf-8"?>
<config name="cbt_local" build="Debug" serversNeed="8" mapServicesAmount="1">
  <net basePort="9000" datagramPort="8000" bindPortsRange="15"/>
  <resourceSystem skipClientResources="true" restrictedMapsLoading="true"/>

  <logging kind="local">
    <local format="csv"/>
  </logging>

  <itemMallServer ip="127.0.0.1">
    <net ip="127.0.0.1" port="9321"/>
    <assortment banners-config="banners.cfg"/>
  </itemMallServer>

  <billingServer>
    <net port="9320" host="127.0.0.1"/>
  </billingServer>
</config>

 

[Lione]

Hello, a year ago I managed to install a virtualization, but alas the hard disk was lost during the move
So I sit down to do it all over again, I remember it was easy. Yeah, not easy. Help me, please.

If its important I tried different amount of memory 1,2,3,4,5gb

in log file database errors, check it

 

[meyouect]

in log file database errors, check it

You're absolutely right, there was an extra space there

Thank you so much! C: