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
  #211  
Old 08-07-2014, 10:06 AM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

So here is how I have it setup now

Code:
drwxrwxrwx  3 root root  4096 Aug  5 07:32 www
Code:
drwxr-xr-x 11 eqemu eqemu 4096 Aug  7 09:38 phpeditor
Code:
drwxr-xr-x  3 eqemu eqemu     4096 Nov 25  2013 logs
And then there is nothing in the log folder because it cannot write.

Any type of edit gives me this error. I have also moved the log location around to directly into the peq/logs folder and I get the same result. For some reason php is not privileged...
Could not create /var/www/logs/sql_log_08-2014.sql! Make sure the logs directory is writeable by your webserver.
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #212  
Old 08-07-2014, 11:47 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

Ok, I think I'm understanding a little more with permissions. Apache is run as www-data on debian. Try these:
Code:
chown root:www-data /var/www
cd /var/www
chown -R www-data:www-data *
ls -al
EDIT: In fact, you would probably get away with just having www-data own the logs folder.
Reply With Quote
  #213  
Old 08-07-2014, 12:23 PM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

I put in those changes but it didn't help. Would I need to restart anything for the changes to take hold?

Also, what port does this travel in on? I would like to be able to hit this editor remote.
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #214  
Old 08-07-2014, 12:26 PM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

Sorry here is what we did.

Code:
eqemu@debian:/var/www$ ls -al
total 20
drwxrwxrwx  3 root     www-data 4096 Aug  5 07:32 .
drwxr-xr-x 13 root     root     4096 Aug  3 20:35 ..
-rw-r--r--  1 www-data www-data  177 Aug  3 20:01 index.html
-rw-r--r--  1 www-data www-data   20 Aug  3 20:04 info.php
drwxr-xr-x 11 www-data www-data 4096 Aug  7 09:38 phpeditor
eqemu@debian:/var/www$
Code:
eqemu@debian:/var/www/phpeditor$ ls -al
total 21976
drwxr-xr-x 11 www-data www-data     4096 Aug  7 09:38 .
drwxrwxrwx  3 root     www-data     4096 Aug  5 07:32 ..
drwxr-xr-x  3 www-data www-data     4096 Dec  7  2013 classes
-rw-r--r--  1 www-data www-data     2139 Aug  7 10:10 config.php
-rw-r--r--  1 www-data www-data     2130 Aug  5 09:05 config.php.dist
drwxr-xr-x  3 www-data www-data     4096 Aug 28  2013 css
-rw-r--r--  1 www-data www-data      716 Sep 27  2013 .htaccess
drwxr-xr-x  3 www-data www-data     4096 May  3 07:00 images
-rw-r--r--  1 www-data www-data     3515 Jul 23 07:00 index.php
drwxr-xr-x  3 www-data www-data     4096 Jul 23 07:00 lib
drwxr-xr-x  3 www-data www-data     4096 Nov 25  2013 logs
drwxr-xr-x  3 www-data www-data     4096 Jul 23 07:00 perl
-rw-r--r--  1 www-data www-data     1303 Dec  5  2013 README.txt
-rwxrwxrwx  1 www-data www-data 22436418 Aug  7 09:38 spells_us.txt
drwxr-xr-x  3 www-data www-data     4096 Jun 30  2013 sql
drwxr-xr-x  6 www-data www-data     4096 Jul 23 07:00 .svn
drwxr-xr-x 32 www-data www-data     4096 May  3 07:00 templates
eqemu@debian:/var/www/phpeditor$
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #215  
Old 08-07-2014, 12:33 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

Standard http is on port 80.

Not sure why it wouldn't be able to write if it is the owner... Try doing a chmod 0770 on just the logs folder.
Reply With Quote
  #216  
Old 08-07-2014, 01:02 PM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

Quote:
Originally Posted by joligario View Post
Standard http is on port 80.

Not sure why it wouldn't be able to write if it is the owner... Try doing a chmod 0770 on just the logs folder.
Sweet, no more logging into my home pc to try it out! Remote access is working

770 didn't help either...
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #217  
Old 08-07-2014, 01:58 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,490
Default

I'm at a loss then. We must be missing something else.
Reply With Quote
  #218  
Old 08-08-2014, 12:47 AM
Shin Noir's Avatar
Shin Noir
Legendary Member
 
Join Date: Apr 2002
Location: Seattle, WA
Posts: 502
Default

This is using my tutorial right?
You followed step 22? http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox
I have it working with those steps, from start to end. I didn't need to chown the directory or anything., just chmod 777 (or 770 or whatever, 777 due to laziness and I never plan to forward port 80 so it's a LAN only accessible network spot).

TECHNICAL STUFF FOLLOWING
by default debian creates /var/www/ as the htdocs root default vhost entry.
This is set inside /etc/apache2/sites-available/default file.

files inside /var/www/ can be root and readable, since init.d for apache2 is ran as root and www-data (you can verify this by typing $ "ps aux | grep apache2" and note the left side for user executing the binaries.)
__________________

~Shin Noir
DungeonEQ.com
Reply With Quote
  #219  
Old 08-08-2014, 07:32 AM
hayward6
Forum Guide
 
Join Date: Jul 2005
Posts: 468
Default

Quote:
Originally Posted by Shin Noir View Post
This is using my tutorial right?
You followed step 22? http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox
I have it working with those steps, from start to end. I didn't need to chown the directory or anything., just chmod 777 (or 770 or whatever, 777 due to laziness and I never plan to forward port 80 so it's a LAN only accessible network spot).

TECHNICAL STUFF FOLLOWING
by default debian creates /var/www/ as the htdocs root default vhost entry.
This is set inside /etc/apache2/sites-available/default file.

files inside /var/www/ can be root and readable, since init.d for apache2 is ran as root and www-data (you can verify this by typing $ "ps aux | grep apache2" and note the left side for user executing the binaries.)
Many of these steps have been changed since I set it up, and you have added a few commands, so I have only gone back and tried to adapt it. It's working fine, just not logging, which is ok with me... but I would like to figure it out...

I believe you have a couple steps out of place in the latest update. The sudo nano line is followed directly buy a mkdir command rather than what you will do in nano. Just confusing, but I get what you want done here.

22 - Set up PHPEditor (optional)
PHPEditor is a way to edit NPC's, spells, items, and many other aspects of the EQ database. It is recommended to set up for future editing, even if you use other tools along with it.

First, we need to inject the schema file for phpeditor
$ sudo mysql -u eq -p -h 127.0.0.1 eq < /var/www/phpeditor/sql/schema.sql
Go to a web browser, access http://10.0.0.111/phpeditor/
It should note database is not configured.
$ sudo cp /var/www/phpeditor/config.php.dist /var/www/phpeditor/config.php
$ sudo nano /var/www/phpeditor/config.php
$ sudo mkdir /var/www/phpeditor/logs
$ sudo chmod 777 /var/www/phpeditor/logs
change the dbhost, 127.0.0.1
dbuser change to eq
password change to root
db change to eq
Refresh web page, should show prompt
Log in as admin/password
$ sudo chmod 777 /var/www/phpeditor/spells_us.txt
__________________
Sayin Silverwolf
Server Op of The Sandbox (Non-Legit)
Reply With Quote
  #220  
Old 08-24-2014, 07:44 AM
Digitala's Avatar
Digitala
Sarnak
 
Join Date: Dec 2006
Posts: 35
Default

Hey!
Does the PEQ Editor work with Angelox Database?
Thx
Reply With Quote
  #221  
Old 08-24-2014, 09:04 AM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Quote:
Originally Posted by Digitala View Post
Hey!
Does the PEQ Editor work with Angelox Database?
Thx
No, because their tables have different column names and they have different table names as well.
Reply With Quote
  #222  
Old 08-24-2014, 09:11 AM
Digitala's Avatar
Digitala
Sarnak
 
Join Date: Dec 2006
Posts: 35
Default

Ahh okey thx!
So what kinda editor works with Angelox?
Just setting things up with my friend atm and we are trying to find out what to use. Any information is useful.
Thank you =)
Reply With Quote
  #223  
Old 08-24-2014, 09:24 AM
wolfwalkereci
Discordant
 
Join Date: Dec 2005
Posts: 435
Default

If you compared their tables/columns to PEQ you could modify the editor to work. Not to knock on their DB but why use it over PEQ?
__________________

Reply With Quote
  #224  
Old 08-24-2014, 09:27 AM
Digitala's Avatar
Digitala
Sarnak
 
Join Date: Dec 2006
Posts: 35
Default

We are going for the classic everquest, and from my understanding PEQ is missing a lot of that. Lavastorm CT etc.
Reply With Quote
  #225  
Old 09-07-2014, 02:39 PM
dimitrious
Fire Beetle
 
Join Date: Mar 2011
Posts: 3
Default

Hey guys, the editor is pretty amazing and I'm loving the easy-to-use nature of it all.

I am experiencing a problem with the spell copy function though. When I try and copy a spell I get the following error:

Quote:
Query failed:
INSERT INTO spells_new (name, player_1, teleport_zone, you_cast, other_casts, cast_on_you, cast_on_other, spell_fades, `range`, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdurationformula, buffduration, AEDuration, mana, effect_base_value1, effect_base_value2, effect_base_value3, effect_base_value4, effect_base_value5, effect_base_value6, effect_base_value7, effect_base_value8, effect_base_value9, effect_base_value10, effect_base_value11, effect_base_value12, effect_limit_value1, effect_limit_value2, effect_limit_value3, effect_limit_value4, effect_limit_value5, effect_limit_value6, effect_limit_value7, effect_limit_value8, effect_limit_value9, effect_limit_value10, effect_limit_value11, effect_limit_value12, max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, icon, memicon, components1, components2, components3, components4, component_counts1, component_counts2, component_counts3, component_counts4, NoexpendReagent1, NoexpendReagent2, NoexpendReagent3, NoexpendReagent4, formula1, formula2, formula3, formula4, formula5, formula6, formula7, formula8, formula9, formula10, formula11, formula12, LightType, goodEffect, Activated, resisttype, effectid1, effectid2, effectid3, effectid4, effectid5, effectid6, effectid7, effectid8, effectid9, effectid10, effectid11, effectid12, targettype, basediff, skill, zonetype, EnvironmentType, TimeOfDay, classes1, classes2, classes3, classes4, classes5, classes6, classes7, classes8, classes9, classes10, classes11, classes12, classes13, classes14, classes15, classes16, CastingAnim, TargetAnim, TravelType, SpellAffectIndex, field124, field125, deities1, deities2, deities3, deities4, deities5, deities6, deities7, deities8, deities9, deities10, deities11, deities12, deities13, deities14, deities15, deities16, field142, field143, new_icon, spellanim, uninterruptable, ResistDiff, dot_stacking_exempt, deleteable, RecourseLink, no_partial_resist, field152, field153, short_buff_box, descnum, typedescnum, effectdescnum, field158, npc_no_los, field160, reflectable, bonushate, field163, field164, field165, EndurCost, EndurTimerIndex, IsDiscipline, field169, field170, field171, field172, HateAdded, EndurUpkeep, numhitstype, numhits, pvpresistbase, pvpresistcalc, pvpresistcap, spell_category, field181, field182, field183, field184, can_mgb, nodispell, npc_category, npc_usefulness, MinResist, MaxResist, field191, field192, nimbuseffect, ConeStartAngle, ConeStopAngle, field196, not_extendable, field198, field199, suspendable, field201, songcap, field203, field204, field205, field206, spellgroup, rank, field209, field210, CastRestriction, allowrest, NotOutofCombat, NotInCombat, field215, field216, field217, field218, maxtargets, field220, field221, field222, field223, persistdeath, id) SELECT name, player_1, teleport_zone, you_cast, other_casts, cast_on_you, cast_on_other, spell_fades, `range`, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdurationformula, buffduration, AEDuration, mana, effect_base_value1, effect_base_value2, effect_base_value3, effect_base_value4, effect_base_value5, effect_base_value6, effect_base_value7, effect_base_value8, effect_base_value9, effect_base_value10, effect_base_value11, effect_base_value12, effect_limit_value1, effect_limit_value2, effect_limit_value3, effect_limit_value4, effect_limit_value5, effect_limit_value6, effect_limit_value7, effect_limit_value8, effect_limit_value9, effect_limit_value10, effect_limit_value11, effect_limit_value12, max1, max2, max3, max4, max5, max6, max7, max8, max9, max10, max11, max12, icon, memicon, components1, components2, components3, components4, component_counts1, component_counts2, component_counts3, component_counts4, NoexpendReagent1, NoexpendReagent2, NoexpendReagent3, NoexpendReagent4, formula1, formula2, formula3, formula4, formula5, formula6, formula7, formula8, formula9, formula10, formula11, formula12, LightType, goodEffect, Activated, resisttype, effectid1, effectid2, effectid3, effectid4, effectid5, effectid6, effectid7, effectid8, effectid9, effectid10, effectid11, effectid12, targettype, basediff, skill, zonetype, EnvironmentType, TimeOfDay, classes1, classes2, classes3, classes4, classes5, classes6, classes7, classes8, classes9, classes10, classes11, classes12, classes13, classes14, classes15, classes16, CastingAnim, TargetAnim, TravelType, SpellAffectIndex, field124, field125, deities1, deities2, deities3, deities4, deities5, deities6, deities7, deities8, deities9, deities10, deities11, deities12, deities13, deities14, deities15, deities16, field142, field143, new_icon, spellanim, uninterruptable, ResistDiff, dot_stacking_exempt, deleteable, RecourseLink, no_partial_resist, field152, field153, short_buff_box, descnum, typedescnum, effectdescnum, field158, npc_no_los, field160, reflectable, bonushate, field163, field164, field165, EndurCost, EndurTimerIndex, IsDiscipline, field169, field170, field171, field172, HateAdded, EndurUpkeep, numhitstype, numhits, pvpresistbase, pvpresistcalc, pvpresistcap, spell_category, field181, field182, field183, field184, can_mgb, nodispell, npc_category, npc_usefulness, MinResist, MaxResist, field191, field192, nimbuseffect, ConeStartAngle, ConeStopAngle, field196, not_extendable, field198, field199, suspendable, field201, songcap, field203, field204, field205, field206, spellgroup, rank, field209, field210, CastRestriction, allowrest, NotOutofCombat, NotInCombat, field215, field216, field217, field218, maxtargets, field220, field221, field222, field223, persistdeath, 33000 AS id FROM spells_new WHERE id = '2160' - Unknown column 'field191' in 'field list'
I assume there's something wrong with my spells_new but I'm unsure how to go about fixing this. This is a recent setup (two days ago)
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 08:58 AM.


 

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