PEQ Database Editor 1.0 (for servers 0.6.4 and up) - Page 12

**hayward6** · #1 08-06-2014, 12:43 PM

Quote:

Originally Posted by joligario

EDIT: How about give me an ls -al from your editor directory.

It's a little more broken than it was because I had to redo the database and source, but the log issue is still there... I don't know why that spells file is there...

Code:

eqemu@debian:/var/www/phpeditor$ ls -al
total 64
drwxr-xr-x 11 eqemu eqemu 4096 Aug  5 09:06 .
drwxr-xr-x  3 root  root  4096 Aug  5 07:32 ..
drwxr-xr-x  3 eqemu eqemu 4096 Dec  7  2013 classes
-rw-r--r--  1 eqemu eqemu 2146 Aug  5 11:50 config.php
-rw-r--r--  1 eqemu eqemu 2130 Aug  5 09:05 config.php.dist
drwxr-xr-x  3 eqemu eqemu 4096 Aug 28  2013 css
-rw-r--r--  1 eqemu eqemu  716 Sep 27  2013 .htaccess
drwxr-xr-x  3 eqemu eqemu 4096 May  3 07:00 images
-rw-r--r--  1 eqemu eqemu 3515 Jul 23 07:00 index.php
drwxr-xr-x  3 eqemu eqemu 4096 Jul 23 07:00 lib
drwxr-xr-x  3 eqemu eqemu 4096 Nov 25  2013 logs
drwxr-xr-x  3 eqemu eqemu 4096 Jul 23 07:00 perl
-rw-r--r--  1 eqemu eqemu 1303 Dec  5  2013 README.txt
-rw-r--r--  1 eqemu eqemu    0 Jun 30  2013 spells_us.txt
drwxr-xr-x  3 eqemu eqemu 4096 Jun 30  2013 sql
drwxr-xr-x  6 eqemu eqemu 4096 Jul 23 07:00 .svn
drwxr-xr-x 32 eqemu eqemu 4096 May  3 07:00 templates
eqemu@debian:/var/www/phpeditor$

**hayward6** · #2 08-06-2014, 12:55 PM

I was able to get it working by turning off sql logging, so that is where the problem is...

**joligario** · #3 08-06-2014, 01:03 PM

I wonder if the problem may be that root owns your parent directory (www). Only guessing at this point.

What is inside your logs folder? Can I get an ls -al from there?

**hayward6** · #4 08-06-2014, 01:24 PM

There is nothing inside the logs folder and I had to create that folder myself. I may be wrong but I believe that www folder was part of the debain deployment, so maybe that is the problem. I could change ownership of it... Let me try that.

**hayward6** · #5 08-06-2014, 01:26 PM

Oh sorry ls-la... yeah it looks like this...

Code:

eqemu@debian:/var/www/phpeditor/logs$ ls -la
total 12
drwxr-xr-x  3 eqemu eqemu 4096 Nov 25  2013 .
drwxr-xr-x 11 eqemu eqemu 4096 Aug  5 09:06 ..
drwxr-xr-x  6 eqemu eqemu 4096 Jul 23 07:00 .svn
eqemu@debian:/var/www/phpeditor/logs$

**hayward6** · #6 08-06-2014, 01:35 PM

That didn't help :( I would run it with logs off, but it seems that the commands don't execute unless the log is written.

Code:

eqemu@debian:/var$ ls -la
total 52
drwxr-xr-x 13 root  root  4096 Aug  3 20:35 .
drwxr-xr-x 23 root  root  4096 Aug  5 09:23 ..
drwxr-xr-x  2 root  root  4096 Aug  5 06:25 backups
drwxr-xr-x 10 root  root  4096 Aug  6 07:15 cache
drwxr-xr-x 31 root  root  4096 Aug  3 20:08 lib
drwxrwsr-x  2 root  staff 4096 Jun 11 17:07 local
lrwxrwxrwx  1 root  root     9 Aug  3 19:46 lock -> /run/lock
drwxr-xr-x  9 root  root  4096 Aug  6 06:25 log
drwxrwsr-x  2 root  mail  4096 Aug  6 13:00 mail
drwxr-xr-x  2 root  root  4096 Aug  3 19:46 opt
lrwxrwxrwx  1 root  root     4 Aug  3 19:46 run -> /run
drwxr-xr-x  5 root  root  4096 Aug  3 19:51 spool
drwxrwxrwt  2 root  root  4096 Aug  3 20:35 tmp
drwx------  3 root  bin   4096 Aug  5 20:29 webmin
drwxr-xr-x  3 eqemu eqemu 4096 Aug  5 07:32 www
eqemu@debian:/var$

**joligario** · #7 08-06-2014, 01:48 PM

Quote:

Originally Posted by hayward6

... I may be wrong but I believe that www folder was part of the debain deployment...

I also assumed that as it didn't look user specific. Don't forget to put it back!

**hayward6** · #8 08-06-2014, 01:53 PM

Quote:

Originally Posted by joligario

I also assumed that as it didn't look user specific. Don't forget to put it back!

Yeah I restored it. The only think in there is the phpeditor though.

**joligario** · #9 08-06-2014, 05:31 PM

I just created a debian 7 VM and the default for that folder is owned by root and the chmod is initially set low. I recommend setting /var/www back to root:root with a chmod of 0777. Then, any folders inside can be 0755 while the files are 0644 and should be owned by (in your case) eqemu:eqemu. See if that works.

**hayward6** · #10 08-07-2014, 09:53 AM

Quote:

Originally Posted by joligario

I just created a debian 7 VM and the default for that folder is owned by root and the chmod is initially set low. I recommend setting /var/www back to root:root with a chmod of 0777. Then, any folders inside can be 0755 while the files are 0644 and should be owned by (in your case) eqemu:eqemu. See if that works.

I don't understand how to do what you are saying... I can set the permissions on folders and files, but the file its writing doesn't exist, and seems to be created each time a new change is made while having the time and date in the file name... I do have the editor working now but I get an error everytime I commit a change.

I changed www back to 777. You're saying that phpeditor should be 755, so I will try that.

**hayward6** · #11 08-07-2014, 10:06 AM

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.

**joligario** · #12 08-07-2014, 11:47 AM

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.

**hayward6** · #13 08-07-2014, 12:23 PM

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.

**hayward6** · #14 08-07-2014, 12:26 PM

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$

**joligario** · #15 08-07-2014, 12:33 PM

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.