|
|
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/spacer.gif) |
![](/forums/images/Darkness/misc/q1.jpg) |
|
![](/forums/images/Darkness/misc/q1-1.jpg) |
![](/forums/images/Darkness/misc/q4.jpg) |
|
![](/forums/images/Darkness/misc/q4-1.jpg) |
![](/forums/images/Darkness/misc/a1.jpg) |
|
![](/forums/images/Darkness/misc/a1-1.jpg) |
|
Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 10:06 AM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 468
|
|
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)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 11:47 AM
|
![joligario's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=15712&dateline=1407721451) |
Developer
|
|
Join Date: Mar 2003
Posts: 1,497
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 12:23 PM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 468
|
|
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)
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 12:26 PM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 468
|
|
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)
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 12:33 PM
|
![joligario's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=15712&dateline=1407721451) |
Developer
|
|
Join Date: Mar 2003
Posts: 1,497
|
|
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.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 01:02 PM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 468
|
|
Quote:
Originally Posted by joligario
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)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-07-2014, 01:58 PM
|
![joligario's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=15712&dateline=1407721451) |
Developer
|
|
Join Date: Mar 2003
Posts: 1,497
|
|
I'm at a loss then. We must be missing something else.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-08-2014, 12:47 AM
|
![Shin Noir's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=996&dateline=1453801334) |
Legendary Member
|
|
Join Date: Apr 2002
Location: Seattle, WA
Posts: 505
|
|
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.)
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-08-2014, 07:32 AM
|
Forum Guide
|
|
Join Date: Jul 2005
Posts: 468
|
|
Quote:
Originally Posted by Shin Noir
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)
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-24-2014, 07:44 AM
|
![Digitala's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=70857&dateline=1408523121) |
Sarnak
|
|
Join Date: Dec 2006
Posts: 35
|
|
Hey!
Does the PEQ Editor work with Angelox Database?
Thx ![Wink](http://www.eqemulator.net/forums/images/smilies/icon_wink.gif)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-24-2014, 09:04 AM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,590
|
|
Quote:
Originally Posted by Digitala
Hey!
Does the PEQ Editor work with Angelox Database?
Thx ![Wink](http://www.eqemulator.net/forums/images/smilies/icon_wink.gif)
|
No, because their tables have different column names and they have different table names as well.
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-24-2014, 09:11 AM
|
![Digitala's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=70857&dateline=1408523121) |
Sarnak
|
|
Join Date: Dec 2006
Posts: 35
|
|
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 =)
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-24-2014, 09:24 AM
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
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?
__________________
|
![Old](/forums/images/Darkness/statusicon/post_old.gif)
08-24-2014, 09:27 AM
|
![Digitala's Avatar](image.php?s=4be99c313a3780293bfac2341e61608e&u=70857&dateline=1408523121) |
Sarnak
|
|
Join Date: Dec 2006
Posts: 35
|
|
We are going for the classic everquest, and from my understanding PEQ is missing a lot of that. Lavastorm CT etc.
|
![](/forums/images/Darkness/misc/a4.gif) |
|
![](/forums/images/Darkness/misc/a6.gif) |
![Old](/forums/images/Darkness/statusicon/post_old.gif)
09-07-2014, 02:39 PM
|
Fire Beetle
|
|
Join Date: Mar 2011
Posts: 3
|
|
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)
|
![](/forums/images/Darkness/misc/a1.gif) |
|
![](/forums/images/Darkness/misc/a3.gif) |
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:14 AM.
|
|
![](/forums/images/Darkness/misc/s1.jpg) |
|
![](/forums/images/Darkness/misc/s1-1.jpg) |
|
|
|
![](/forums/images/Darkness/misc/z1.jpg) |
|
![](/forums/images/Darkness/misc/z1-1.jpg) |
|
![](/forums/images/Darkness/misc/side3.jpg) |