Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2009, 08:18 AM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

welcome and let me know any bugs / errors you run into.
Reply With Quote
  #2  
Old 09-01-2009, 02:59 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

hey me again. again I want to thank you for a wonderful app, I have a few things i've noticed that might be out of place, maybe just needs updating again Idk.

1. rules aren't showing up on the rules tab. I have it config'd for it to show them, but they just aren't showing up.

2. I started tinkering with the auto compiler, and had it compile, but after it compiled and restarted the server, I was my zones were failing to launch. wish I had the screenie for it, but unfortunately I forgot to get it before tryin to fix it. I recompiled under VS2008 and its working fine now. dunno if that was the apps problem or a fluke.

3. after it did the compile I was tryin to get it to update the binaries but it would crash when attempting (see code block below). basically it tries to move the new biniaries to the eqemu folder, but its trying to pull from svnroot/build folder, but the route to the new biniaries is svnroot/trunk/eqemuserver/build. don't know if you are aware of that or not. this causes an unhandled exception, cause it can't find the build folder, and crashes the app. I Just unchecked update binaries and conf and ran eqemu from the build folder, and it works good enough. just thought you should be aware of that.

output from debugging
Code:
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Users\Public\New Folder\source\trunk\EQEmuServer\Build\ServerTender.exe'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Runtime.Remoting\2.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Users\Public\New Folder\source\trunk\EQEmuServer\Build\MySql.Data.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll'
An unhandled exception of type 'System.IO.DirectoryNotFoundException' occurred in mscorlib.dll

Additional information: Could not find a part of the path 'C:\Users\Public\New Folder\source\Build'.
4. broadcast works, but then closes the window. no debug info for it, but thats all it does lol.

5. idk if this supports the new ucs, or if the mail/chat server IS the ucs. sorry couldn't find a whole lot of info on it. but if its not, is there a way to update it to support the new ucs for SoF?

6. bots.sql isn't being sourced in when its updated. just another notice, dunno how indepth you were wanting the sourcing to be, but again just another notice.

7. more of a feature request. a way to have it shut down the server before starting the sourcing and compiling? nothing big, but would be helpful for those that have slower systems and can't have both the server and compiler running.

I think thats pretty much it. sorry if its a burden, I just don't want to see such a great app get lost. its very useful, and makes it so much easier to focus on other parts of the server like content, without having to worry about getting the latest svn, or having to get up in the middle of the night and restart the server cause of lag lol.

thanx again.
Reply With Quote
  #3  
Old 09-01-2009, 03:25 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

Quote:
Originally Posted by nightsta69 View Post
1. rules aren't showing up on the rules tab. I have it config'd for it to show them, but they just aren't showing up.
i've had this problem too every so often - it's an sql problem somewhere and i haven't been able to figure out where yet - and it's driving me nuts. is the app showing up what db_version and core_version you are running?

Quote:
Originally Posted by nightsta69 View Post
2. I started tinkering with the auto compiler, and had it compile, but after it compiled and restarted the server, I was my zones were failing to launch. wish I had the screenie for it, but unfortunately I forgot to get it before tryin to fix it. I recompiled under VS2008 and its working fine now. dunno if that was the apps problem or a fluke.
i'll check into that as soon as RL calms down - insane this week!

Quote:
Originally Posted by nightsta69 View Post
3. after it did the compile I was tryin to get it to update the binaries but it would crash when attempting (see code block below). basically it tries to move the new biniaries to the eqemu folder, but its trying to pull from svnroot/build folder, but the route to the new biniaries is svnroot/trunk/eqemuserver/build. don't know if you are aware of that or not. this causes an unhandled exception, cause it can't find the build folder, and crashes the app. I Just unchecked update binaries and conf and ran eqemu from the build folder, and it works good enough. just thought you should be aware of that.

output from debugging
Code:
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Users\Public\New Folder\source\trunk\EQEmuServer\Build\ServerTender.exe'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Runtime.Remoting\2.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Users\Public\New Folder\source\trunk\EQEmuServer\Build\MySql.Data.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
'ServerTender.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll'
An unhandled exception of type 'System.IO.DirectoryNotFoundException' occurred in mscorlib.dll

Additional information: Could not find a part of the path 'C:\Users\Public\New Folder\source\Build'.
you should be able to point the OPTIONS -> Server Maintenance -> SVN -> Update Source Code field to the correct folder that contains 'Server.sln'

in your case I believe its
'C:\Users\Public\New Folder\source\trunk\EQEmuServer'

No other folder structure has changed, the resulting build should be in
C:\Users\Public\New Folder\source\trunk\EQEmuServer\build

also - make sure you're building RELEASE or RELEASE BOTS!

It looks like you have it pointed to
'C:\Users\Public\New Folder\source'

Quote:
Originally Posted by nightsta69 View Post
4. broadcast works, but then closes the window. no debug info for it, but thats all it does lol.
The broadcast feature is supposed to broadcast what you type in the box when you hit 'broadcast now', it runs telnet, broadcasts, and closes.
You're not seeing anything in game?

Quote:
Originally Posted by nightsta69 View Post
5. idk if this supports the new ucs, or if the mail/chat server IS the ucs. sorry couldn't find a whole lot of info on it. but if its not, is there a way to update it to support the new ucs for SoF?
The chatserver checkbox is the new ucs, uncheck the mailserver checkbox and check the chatserver checkbox.

Quote:
Originally Posted by nightsta69 View Post
6. bots.sql isn't being sourced in when its updated. just another notice, dunno how indepth you were wanting the sourcing to be, but again just another notice.
that's related to #1. try sourcing in a file via command line
mysql -u'username' -p'pass' -h'server ip - usually 127.0.0.1' 'db name' < 'sql_file.sql'

ie

mysql -uroot -pmypass -h127.0.0.1 peq < db_version.sql

see if it works - that's how my app runs the db sourcing - using a batch file (source.bat)

Quote:
Originally Posted by nightsta69 View Post
7. more of a feature request. a way to have it shut down the server before starting the sourcing and compiling? nothing big, but would be helpful for those that have slower systems and can't have both the server and compiler running.
That's a good idea - i'll work on it when i can!

Quote:
Originally Posted by nightsta69 View Post
I think thats pretty much it. sorry if its a burden, I just don't want to see such a great app get lost. its very useful, and makes it so much easier to focus on other parts of the server like content, without having to worry about getting the latest svn, or having to get up in the middle of the night and restart the server cause of lag lol.
thanx again.
You're welcome - and not a burden! good feedback is always appreciated!
Reply With Quote
  #4  
Old 09-01-2009, 03:38 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

Quote:
Originally Posted by nosfentora View Post
i've had this problem too every so often - it's an sql problem somewhere and i haven't been able to figure out where yet - and it's driving me nuts. is the app showing up what db_version and core_version you are running?



i'll check into that as soon as RL calms down - insane this week!



you should be able to point the OPTIONS -> Server Maintenance -> SVN -> Update Source Code field to the correct folder that contains 'Server.sln'

in your case I believe its
'C:\Users\Public\New Folder\source\trunk\EQEmuServer'

No other folder structure has changed, the resulting build should be in
C:\Users\Public\New Folder\source\trunk\EQEmuServer\build

also - make sure you're building RELEASE or RELEASE BOTS!

It looks like you have it pointed to
'C:\Users\Public\New Folder\source'



The broadcast feature is supposed to broadcast what you type in the box when you hit 'broadcast now', it runs telnet, broadcasts, and closes.
You're not seeing anything in game?



The chatserver checkbox is the new ucs, uncheck the mailserver checkbox and check the chatserver checkbox.



that's related to #1. try sourcing in a file via command line
mysql -u'username' -p'pass' -h'server ip - usually 127.0.0.1' 'db name' < 'sql_file.sql'

ie

mysql -uroot -pmypass -h127.0.0.1 peq < db_version.sql

see if it works - that's how my app runs the db sourcing - using a batch file (source.bat)



That's a good idea - i'll work on it when i can!



You're welcome - and not a burden! good feedback is always appreciated!
1. under the rules tab all i'm seeing is 1 and default in the left hand box. everything else is empty.

2. no rush, RL always more important then server stuff. unless RL is server stuff lol.

3. sorry my stupidity there. lack of sleep kicking in lol.

4.no what happens is i'll type in what I want to broadcast. it'll broadcast, then the app window closes. its still shows its runnng in processes. but no GUI.

5. ty for clarification on the ucs.

6.will definitely try that. wasn't too sure how to go about that. my skills for mysql is slightly lacking, I know enough to work on content and such, but I mostly do stuff thru navicat, not command line.

7.always glad to help improve and alrdy great app.

if I find more, i'll definitely post it here.

thanx.

edit:: something else I found odd. I manually closed out world and eqlaunch just to see if it would restart, its been sittin for idk, maybe an hour and hasn't restarted them. dunno if you have it programmed only to detect if it crashed, or if it'll detect the windows bein manually closed out as well and restart the windows.
Reply With Quote
  #5  
Old 09-01-2009, 04:08 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

Quote:
Originally Posted by nightsta69 View Post
1. under the rules tab all i'm seeing is 1 and default in the left hand box. everything else is empty.
ahh! so they are loading! i feel better now!

try double clicking on '1' or 'default'.
it only loads them when you double click on them - allows multiple rule sets to be used / managed.

Quote:
Originally Posted by nightsta69 View Post
2. no rush, RL always more important then server stuff. unless RL is server stuff lol.
thanks! kids =)

Quote:
Originally Posted by nightsta69 View Post
3. sorry my stupidity there. lack of sleep kicking in lol.
it happens

Quote:
Originally Posted by nightsta69 View Post
4.no what happens is i'll type in what I want to broadcast. it'll broadcast, then the app window closes. its still shows its runnng in processes. but no GUI.
so the server tender app is closing? sounds like the app is gaining focus and catching the alt + f4 closing keystrokes.
You might want to do what i suggested earlier - open my source, find 'Private Sub BroadcastNow', change broadcast3(msg) to broadcast1(msg) and recompile.
That will use sockets instead of telnet and sendkeys.

Quote:
Originally Posted by nightsta69 View Post
5. ty for clarification on the ucs.
NP. sorry it was confusing! This was built before the UCS had taken effect and the separate mailserver was removed.

Quote:
Originally Posted by nightsta69 View Post
6.will definitely try that. wasn't too sure how to go about that. my skills for mysql is slightly lacking, I know enough to work on content and such, but I mostly do stuff thru navicat, not command line.
it's a good skill to learn and not really that hard.

Quote:
Originally Posted by nightsta69 View Post
7.always glad to help improve and alrdy great app.

if I find more, i'll definitely post it here.

thanx.
thank you!

Quote:
Originally Posted by nightsta69 View Post
edit:: something else I found odd. I manually closed out world and eqlaunch just to see if it would restart, its been sittin for idk, maybe an hour and hasn't restarted them. dunno if you have it programmed only to detect if it crashed, or if it'll detect the windows bein manually closed out as well and restart the windows.
manually closed meaning...? (the english language is open to such lovely interpretation!)

the app will close any crashed apps, it doesn't restart them if they crash (world takes care of re-starting zones that crash.)

(i know false advertising! the title of this is 'world crash rebooter', and my app doesn't restart a crashed world! That'll be in the next rev when i can - i haven't had a world crash in quite a while so i put that on the back burner in preference to other features)
Reply With Quote
  #6  
Old 09-01-2009, 04:16 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

Also - multiple zone launchers can be used by adding new entries to the launcher and launcher_zones table.

(its the reason why if you shut down the app and restart it without shutting down the server, the eqlaunch uptime timer doesn't start - it doesn't know which launcher is which) i'll be fixing that in the future too.

so much code so little time...
Reply With Quote
  #7  
Old 09-01-2009, 04:22 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

Quote:
try double clicking on '1' or 'default'.
it only loads them when you double click on them - allows multiple rule sets to be used / managed.
yep that worked, didn't know to double click lol


Quote:
so the server tender app is closing? sounds like the app is gaining focus and catching the alt + f4 closing keystrokes.
You might want to do what i suggested earlier - open my source, find 'Private Sub BroadcastNow', change broadcast3(msg) to broadcast1(msg) and recompile.
That will use sockets instead of telnet and sendkeys.
will try this probably tonight, after I get some sleep.

Quote:
NP. sorry it was confusing! This was built before the UCS had taken effect and the separate mailserver was removed.
its no biggie. just wantin to help get it up to date

Quote:
it's a good skill to learn and not really that hard.
yea i'm workin on it, slowly lol.


Quote:
manually closed meaning...? (the english language is open to such lovely interpretation!)

the app will close any crashed apps, it doesn't restart them if they crash (world takes care of re-starting zones that crash.)
IE clicking the x in the corner of world and eqlauncher. but you cleared that up.


if I come up with more ideas to help improve this I will definitely let you know. I can always come up with the ideas, but I just can't code for crap lol.
Reply With Quote
  #8  
Old 09-01-2009, 04:54 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 387
Default

Always on the lookout for ideas! =)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:54 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3