Garbaek

a cool util for linux is http://expect.nist.gov (works great with telnet/bash and such)

that's also worth having a look at I think

Try to open 'directly' link http://server1/reggacc/world1.php . Have you got identical error again?

Did you set proper values for characters and realm databases too? (hostc, userc, ... hostr, userr, ...)

v.

Yeah, I tied that site, did not work, only with localhost as hostname on server1.. with server2 as hostname, it fails, even tho right's and database names are the same on both servers.. (did that to make it easy on myself)

I really do not comprehend what's wrong.

For some reason I cant get this to work..

I have a webserver in germany, called server1 and a game/mysql server in denmark called server2

I have the reggacc website on server1 one, and my databases on server2.. I have a user on server2 called user1 has access to mang_realmd mang_chars and mang_world databases on server2..

but I cant connect from http://server1/reggacc/index.php I get this error

Error:
Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query.

Update your >>> ReggAcc configuration <<<
Check configuration file - hosts, usernames and passwords.

I have tried everything in the configuration.php

$realmName="Realm1";

$rid="1";

$host="ip.ip.ip.ip : port";

and

$host="ip.ip.ip.ip";

also

$host="hostname.server2";

and

$host="hostname.server2 : port";

nothing works.. and I'm sure I got username and password and remote rights 100% correct.

When I try to run everything on server1. it works perfectly, so I think your script is not allowing remote connections to the databases, or is it me?

Thanks in advance.

How did you solve it?

I would have used "Replace into"

You can also add color codes to the messages

|cff7777cd = Bluish-purple

|cff32cd32 = Green

|cff7777aa = Light Blue

|cffcd32cd = Pink

|cffffcc00 = Yellow

|cffff0000 = Red

|cff995500 = Orange

|cff00ffff = Lightblue

|cffffcc00 = Gold

|c000000ff = Green

|c0000ad00 = Blue

|cff000000 = Black

|cffffffff = White

Ie

message1="|cffffcc00 Hello world!"

I do not take credit for this, It was on the old mangos forums waaaaay back, and I just stumpled upon the files on my server. Thought I wanted to share.

Note, this only works for linux, cause its using bash scripts.

First make sure you have the correct settings in mangos.conf (all the way in the bottom)

Ra.Enable = 1
Ra.IP = 127.0.0.1
Ra.Port = 3443
Ra.MinLevel = 3 (what gm levels that are allowed to connect to the telnet realm server
Ra.Secure = 1

Then you need to make 3 files

messages.sh

starttelnet.sh

telnet.sh

And they should look something like this

messages.sh

#!/bin/sh

/home/user/adscript/telnet.sh | /home/user/adscript/starttelnet.sh
echo Done

starttelnet.sh

#!/bin/sh

telnet -e X

telnet.sh

#!/bin/sh

host=127.0.0.1   #server hostname or IP address
port=3443
login="USER account"            #RA console commands for login user
passwd="PASS password"  #and the password

message1="This is the first message"
message2="This is the second message"
message3="This is the third message"

mess=$[ ( $RANDOM % 3 ) + 1 ]   # replace "3" with real number of your messages

echo open $host $port
sleep 1
echo $login
sleep 1
echo $passwd
sleep 1

case $mess in
   1)
       echo "announce $message1";
    ;;
   2)
       echo "announce $message2";
    ;;
   3)
       echo "announce $message3";
    ;;

  # and so on..
esac
sleep 1
echo X
sleep 1
echo quit

Then all you need to do, is add the script to crontab, if you want it to run automaticly every xx minutes

type crontab -e to get your crontab, and insert this line in the bottom.

*/15 * * * * /home/user/adscript/messages.sh > /dev/null 2>&1

and your done..

you can naturally test the script by typing

./home/user/adscript/messages.sh in shell

have fun with it..

almost 200 views and no comments if this worked for others or not..

Gief comments!

Thanks for the input!

and yeah I knew that what you clone becomes your own branch, I just had problems fiding a good guide on checking out older revisions, like right now, the 7050 rev, is broken, you cant do "make install" in linux without errors, so I needed to grab a older "working" tree, and there was no real help for this.. Hence the reason I made this guide.

I hope others will benefit from this.

After searching the forums, I gave up and went to #git and asked the experts and I found out how to pull old revisions of mangos..

First you'll need to do

git clone git://github.com/mangos/mangos.git

cd mangos

git checkout -b yourbranchname 519bc25a215e095b573dafc62eb496e908cdae59

(Because we want http://github.com/mangos/mangos/commit/1d52f36ced501c8e284db7860470c73de85df9bf)

Then you can do

git show

should show something like this

splashgame@siara:~/mangos$ git show
commit [b]519bc25a215e095b573dafc62eb496e908cdae59[/b]
Author: ApoC <[email protected]>
Date:   Wed Jan 7 04:21:09 2009 +0100

   [7042] Forget to add revision number.

   Signed-off-by: ApoC <[email protected]>

diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h
index 05ad9af..1c80b3c 100644
--- a/src/shared/revision_nr.h
+++ b/src/shared/revision_nr.h
@@ -1,4 +1,4 @@
#ifndef __REVISION_NR_H__
#define __REVISION_NR_H__
- #define REVISION_NR "7041"
+ #define REVISION_NR "7042"
#endif // __REVISION_NR_H__

Now you can start to apply patches, compile and make your custom branch.

Cheers

Garbaek

Great tutorial.!

Worked perfectly first time! Thanks!