PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[Rhodan]

Got it! And now the SVN works from the resulting directory too.

There seems to be something wrong with the login routine though. I always get an error

Invalid login attempt. Bad password from IP: '127.0.0.1'. Username: 'admin' Password: 'password'.; -- admin (18-May-14 15:36:24)

But I checked and the password in peq_admin does match md5('password')

odds bodkins!

Found it in another post. XAMPP defaults to short tags off, turned them on and all is well.

[hayward6]

Does anyone know how I fix this? THis is my first time with the editor... Everything seems setup correctly, but that logs directory doesn't exist on my server... Even after I created it and provided write access to it I couldn't work this out. Thank you!

Could not create logs/sql_log_08-2014.sql! Make sure the logs directory is writeable by your webserver.

[joligario]

What is the logs and parent chmod?

[hayward6]

Originally Posted by joligario

What is the logs and parent chmod?

I have been playing around with several and the login screen itself "The pfpeditor folder" likes 755, but nothing I do to the logs folder seems to help.

I have no idea... I have even moved the log location in the config file and it's the same thing. There must be a setting somewhere that allows the webserver to write, and until I find that... It won't work.

[joligario]

Yeah, 755 the folders and 644 the files (if I remember right). Are you running with a different user than the public html owner? Is it outside your public html folder with a symlink?

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

[hayward6]

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...

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]

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

[joligario]

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]

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]

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

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]

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.

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]

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]

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]

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]

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.