I have been >.< Other database thingys load up fine, just the one in these files keeps coming up with the error.Originally Posted by deanfletc
I have been >.< Other database thingys load up fine, just the one in these files keeps coming up with the error.
Excellent Thread - Stickied! :)
I have just had a thought about the db in the files, I think i made it with sql 2005 but there should be on in them that was made with sql 2000.
If shunt could reply i think hed know if that is the case as my mind isnt working very well lately.
Hi,
Just trying this out as ive lost my damn database so thought i would try it again. Had sql2000 so installed 2005 and now i am getting...
Loaded client version information and server table...
Loading StdItem.DB...
[04/01/2008 04:40:55] StartTimer exception: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
Using sa and sa password on the setup.txt. Its only the M2Server thats doing this. Checked TCP on 2005 was all enabled and its up and running.
EDIT: FIXED - Was because it wasnt mysql in the setup.txt. Becareful of this is you are using 2005 database, like the one included as the setup.txt says mssql and not mysql.
Getting [ODBC Driver Manager] Data source name not found and no default driver specified now because i think i messed up reinstalling sql so going to install 2005 again.
it should say:
[SQL]
UseSQL=TRUE
SQLHost=(local)
SQLUsername=sa
SQLPassword=****
SQLDatabase=lom2
SQLType=mssql (if you are using MSSQL, these dont work with MYSQL?)
SQLPort=3306
SQLCharDatabase=lom2
I dont believe mssql works with 05, i had to change mine to mysql which seemed to get past the error i was recieveing.. I think i read that the database provided wasnt running with the server files provided here?
Anyway i gave up on this db and 05 as i was getting error after error, so i returned to my 2000 one which works fine.
Having problems getting it online but am not sure what it is lol.
i think there was 2 dbs included one i did on 05 which i think is the one people were getting errors restoring and the idabiga one which still neded an update or 2 to the tables and fields, apart from all that the server files will get you online/offline and ingame. quickly and easily .
Yea thanks for the files :) I am using my own db i created a while (after new npcs/ item matching/maps etc) I didnt want to delete that!
I am having trouble getting online but im not sure where i am going wrong. Do i use my Router IP as the public ip for online? Or do i use my internet ip or my ip my router gives me?
I am playing round with them atm.
great guide :D
my server worked fine in local mode, but i getting problems when i try and run it in LAN mode. i changed all IP's to 192.168.0.5 (thats the IP i got from my router) and everything is starting fine. only odd bit is the Gate port, it seems to open random ports everytime i start the server/ close and re-open the gate. the login process (client) is working fine, but after putting my id/ pw in the char seletct screen won t come up (the gate stays closed)
any ideas??
You problem is Loginsrv there, change around the ips in that - Bugger it i will show mine :P
Set in logsrv.ini
All to 127.0.0.1 execpt
FeeServer=192.168.0.5
LogServer=192.168.0.5
!servaddr.txt should be just 127.0.0.1
!addtable.txt should be
127.0.0.1 192.168.0.5 192.168.0.5:7100
Try that and see if you can get into char select - I suggest you change all of them back to 127.0.0.1 - there is only about 6/7 192.168.0.5's you need to put in for lan.
as far as i know , when not using a router there are only 3 places to change the ip, if you do a search on these forums you will come up with those locations.
As far as a router goes I do not have a clue on what to change due to the favt i prefer a full internet connection rather than a shared connection via a router i like switches :D so you could say im a router noob.
best bet would be to do a search for router port forwarding and setup from the forums.
Hi Guys,
Whats the best way to restore the DB? And is it best to run one DB or 2 for data and char?
how can i restore the database it gives me an error anyone help plz? im using sql 2000 btw.
check that you are trying to restore the correct db as one of them is a backup of mssql 2005 and has erroirs on restoring.
If one DB wont restore try using the other on or maybe even one in the old dbs folder and do all the updates too from the updates.doc working from bottom of the doc to the top.
i only have 1 db and thats this one but come up with errors mir2(restorethis)
is there 2 dbs in the files 1 called restorenotattach aswell as the restorethis one ?
as 1 of those dbs is 2005 sql but cant remember which
there is a link somehwere on forums to a good fully updated sql 2000 db
only one i got is this mir2(restorethis) and i have sql 2000 installed.
look through all this thread m8 i think there is a link to the second one.
yes there is but link is broken :(
i have added a sql200 backup to the original files, unfortunately it will mean downloading again,
it is located in the same placem dbserver folder, and called mir2sql2000backup
can someone please give me simple instructions how to make a server. Really want to make one ive been trying all day with no success. Any help at all would be greatly appraicated(not spelt right). A few links and files to download would rock. Also anyone that has done it already and knows exatly how would be great too thanks :)
link is dead, can someone give a mirror please..
here,, i will ask elvin to change main one
http://hell23.servegame.com/Mirserver/Mirserver.rar
OK after reading this thread i have changed the first post link to the one shunt has on the post above.
thx for the links sir
work 100%
thx for elvin & shunt for the file
just wonder where i can find the monster :P
Last edited by dadarguling; 07-06-08 at 12:22 AM.
Reply With Quote