Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::GeorgeS's Tools

Development::GeorgeS's Tools A forum just for GeorgeS's tools

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2008, 04:56 AM
WillowyLady
Sarnak
 
Join Date: Aug 2003
Location: Recycle Bin
Posts: 90
Default

Ok sussed this one it out. Too much booze last night:(

Problem was with me and db.ini *looks around sheepishly*


db.ini WAS:-

=======================
host=127.0.0.1
user=?
password=?
database=c:\peq_db
everquest_folder=e:\EverQuest
=======================

Should have been:-

=======================
host=127.0.0.1
user=root
password="one used in setting up MySql Server Instance Config"
database=peq "localhost\peq"
everquest_folder=e:\EverQuest
========================

Thanks for a great app!
__________________
I'll be back!

Reply With Quote
  #2  
Old 12-23-2008, 05:50 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Your registrations of the ocx's were fine, so the problem is with your db.ini

..an example of a db.ini..

host=127.0.0.1
user=george
password=mypass
database=PEQ <<----this must be the SCHEMA name, not the path
everquest_folder=e:\EverQuest

Your database name must be the schema of your database when it was made. If it was with Cavedudes installer, then likely it's just PEQ.


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #3  
Old 12-23-2008, 09:18 AM
WillowyLady
Sarnak
 
Join Date: Aug 2003
Location: Recycle Bin
Posts: 90
Default A little problem with EQ Items Database Editor

I have encounter a little problem, when attempting to run C:\eqitems\eqitems.exe, the following message pops up:-

MYSQL Connection FAILED!- Check db.ini and did you install my OBDC drivers?

ocx_register.bat looks like this:~

==================================================
regsvr32 DXAnimatedGIF.ocx
regsvr32 a.ocx
regsvr32 msdxm.ocx
regsvr32 MSCOMCTL.OCX
regsvr32 MSINET.OCX
regsvr32 MSDATGRD.OCX
==================================================

when run outputs:-

==================================================
c:\eqitems\resources>register_ocx.bat

c:\eqitems\resources>regsvr32 DXAnimatedGIF.ocx

c:\eqitems\resources>regsvr32 a.ocx

c:\eqitems\resources>regsvr32 msdxm.ocx

c:\eqitems\resources>regsvr32 MSCOMCTL.OCX

c:\eqitems\resources>regsvr32 MSINET.OCX

c:\eqitems\resources>regsvr32 MSDATGRD.OCX
==================================================

Each had a sucessful popup.

So on the surface of thing, the OBDC aspect appears to be OK.

Now, looking at DB.ini.

==================================================
host=127.0.0.1
user=?
password=?
database=c:\peq_db
everquest_folder=e:\EverQuest
==================================================


This is the bit that has thrown me a little and could possibly the be the cause of the error.

I am unsure of what to put in certain fields. Does the user / pass relate to something else that is installed, or can I bung in anything?

I am uncertain if the path to db is correct. In my lashup c:\peq_db is the folder that contains:-

==================================================
16/12/2008 16:53 <DIR> .
16/12/2008 16:53 <DIR> ..
12/02/2008 14:17 1,861 aa_timers.sql
12/02/2008 14:17 2,272 account.sql
21/04/2008 19:07 387 Banned_IPs.sql
12/02/2008 14:17 1,755 botinventory.sql
12/02/2008 14:17 1,722 botleader.sql
12/02/2008 14:17 1,763 botsowners.sql
29/03/2008 19:17 98 bot_npcs.bat
16/03/2008 20:40 98 bot_npcs.sh
22/11/2008 04:59 319 buyer.sql
22/11/2008 04:59 1,373 character_.sql
01/10/2008 04:44 726 character_activities.sql
12/02/2008 14:17 2,372 character_backup.sql
01/10/2008 04:44 569 character_enabledtasks.sql
01/10/2008 04:44 641 character_tasks.sql
22/11/2008 04:59 24,758 commands.sql
01/10/2008 04:44 664 completed_tasks.sql
22/11/2008 04:59 1,679 drop_player.sql
25/11/2008 23:38 1,989 drop_system.sql
12/02/2008 14:17 2,078 eventlog.sql
12/02/2008 14:17 1,835 faction_values.sql
16/08/2008 20:07 405 group_id.sql
12/08/2008 21:30 373 group_leaders.sql
12/02/2008 14:17 1,989 guilds.sql
12/02/2008 14:17 2,091 guild_members.sql
12/02/2008 14:17 2,286 guild_ranks.sql
12/02/2008 14:17 1,856 guild_relations.sql
02/06/2008 02:50 537 hackers.sql
12/02/2008 14:17 2,239 inventory.sql
01/10/2008 04:44 486 keyring.sql
12/02/2008 14:17 1,779 launcher.sql
12/02/2008 14:17 1,825 launcher_zones.sql
22/11/2008 04:59 1,114 load_player.sql
07/10/2008 19:25 570 merchantlist_temp.sql
12/02/2008 14:17 1,701 name_filter.sql
12/02/2008 14:17 2,259 object_contents.sql
25/11/2008 23:01 91,810,002 peqdb_1129Rev233.sql
16/12/2008 16:44 13,520,326 peqdb_1129Rev233.sql.gz
12/02/2008 14:17 2,374 petitions.sql
12/02/2008 14:17 2,273 player_corpses.sql
12/02/2008 14:17 2,258 player_corpses_backup.sql
12/02/2008 14:17 2,100 quest_globals.sql
01/10/2008 04:44 555 raid_details.sql
01/10/2008 04:44 761 raid_members.sql
12/03/2008 16:04 467 rule_sets.sql
25/11/2008 23:38 11,371 rule_values.sql
12/02/2008 14:17 2,137 sharedbank.sql
12/02/2008 14:17 1,878 timers.sql
14/11/2008 21:10 424 trader.sql
22/11/2008 04:59 325 trader_audit.sql
16/12/2008 16:44 <DIR> updates
01/10/2008 04:44 3,086 variables.sql
12/02/2008 14:17 1,746 zone_flags.sql
51 File(s) 105,432,552 bytes
3 Dir(s) 4,059,373,568 bytes free
==================================================

In the meantime...I'll poke around a bit. Might get lucky!

I am most likely overlooking the blindly obvious, if some kindly soul could provide a little pointer in the correct direction, it would be very welcome.

Many thanks.
__________________
I'll be back!

Reply With Quote
Reply


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 03:29 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3