EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)
-   -   PEQ Database Editor 1.0 (for servers 0.6.4 and up) (https://www.eqemulator.org/forums/showthread.php?t=20073)

Rhodan 05-18-2014 09:54 AM

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 08-05-2014 09:21 AM

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!

HTML Code:

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

joligario 08-05-2014 11:22 AM

What is the logs and parent chmod?

hayward6 08-05-2014 11:35 AM

Quote:

Originally Posted by joligario (Post 232548)
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 08-06-2014 12:00 PM

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 08-06-2014 12:43 PM

Quote:

Originally Posted by joligario (Post 232582)

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 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 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 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 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 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 08-06-2014 01:48 PM

Quote:

Originally Posted by hayward6 (Post 232587)
... 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 08-06-2014 01:53 PM

Quote:

Originally Posted by joligario (Post 232590)
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 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 08-07-2014 09:53 AM

Quote:

Originally Posted by joligario (Post 232598)
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.


All times are GMT -4. The time now is 03:01 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.