Support for Account Manager

[mochitto]

Cannot login to server with uppercase letters in loginname

[ha0ck]

Hi daedalus,

I have the following configuration:

Vista 32Bit
Wamp 2.0
Account Manager "New Version"
install.php check report all criteria as "OK" in green

When attempting to use either the Create Account or to log into an existing account, a blank page is produced and Apache (and only Apache) crashes. The SQL data from the attempt to create the account is present in the l2jdb database (ie username, password, email, timestamp etc) as if it had worked as expected, but no HTML data is returned.

What could be causing this issue? We get the following in the Apache error log:

Code: Select all

[Mon Nov 16 01:57:02 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.[Mon Nov 16 01:57:02 2009] [notice] Child 5824: Exit event signaled. Child process is ending.[Mon Nov 16 01:57:03 2009] [notice] Child 5824: Released the start mutex[Mon Nov 16 01:57:04 2009] [notice] Child 5824: All worker threads have exited.[Mon Nov 16 01:57:04 2009] [notice] Child 5824: Child process is exiting[Mon Nov 16 01:57:04 2009] [notice] Parent: Child process exited successfully.[Mon Nov 16 01:57:04 2009] [notice] Apache/2.2.11 (Win32) PHP/5.3.0 configured -- resuming normal operations[Mon Nov 16 01:57:04 2009] [notice] Server built: Dec 10 2008 00:10:06[Mon Nov 16 01:57:04 2009] [notice] Parent: Created child process 5648[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Child process is running[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Acquired the start mutex.[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Starting 64 worker threads.[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Starting thread to listen on port 80.[Mon Nov 16 01:57:38 2009] [notice] Parent: child process exited with status 255 -- Restarting.[Mon Nov 16 01:57:38 2009] [notice] Apache/2.2.11 (Win32) PHP/5.3.0 configured -- resuming normal operations[Mon Nov 16 01:57:38 2009] [notice] Server built: Dec 10 2008 00:10:06[Mon Nov 16 01:57:38 2009] [notice] Parent: Created child process 7304[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Child process is running[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Acquired the start mutex.[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Starting 64 worker threads.[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Starting thread to listen on port 80.

I've been scratching my head for hours now, I've tried running Apache in all sorts of compatibillity modes as well.

Something was mentioned about 'Cache Folder' access rights - can you explain what I might need to edit if I need to grant access to this?

All help is very much welcome.

Thanks Guys

[ha0ck]

Anybody? :s

[ha0ck]

Hey,

I really could do with some help on this subject,

It appears to be a similar issue to droll. And i'm almost sure its a caching issue, but, i can't seem to find anywhere, the instructions on how to make sure the cache folder has the access rights required on a windows machine to allow smarty to write to it or any file for that matter.

Could anyone shed some light on this please?

[daedalus]

@mochitto, Ok, I'm on it.

@ha0ck, Hum if you have all tests ok in the verification tool. It shouldn't be the cache directory. I've not get this issue. May try with the email socks.

Regards,

[UnIcAL]

Hi all,
I test the acm manager all work's fine exept the unstuck command.
When i push: Move your character to the nearest town
Debug mode tell me

l2xxx->SELECT COUNT(login) FROM accounts WHERE login = "xxxx" AND password = "xxxx=" AND accessLevel >= 0 LIMIT 1;
Result: string('1')
Getting Worlds list
l2xxx->SELECT `server_id` FROM `gameservers`;
Records: 1
World n�61 had not configuration !

And in html shows me this: Any Character Found
I push here but nothing done and the player stays in the same position in game.
Can you help me please?

Ps: i try to change the line 386 of character.class.php in:

function mapRegionTable() {
$sql = 'SELECT "plop", region, sec0, sec1, sec2, sec3, sec4, sec5, sec6, sec7, sec8, sec9, sec10, sec11, sec12, sec13, sec14, sec15 FROM mapregion;';

but nothing.
Thanks for the share keep going on!!!

[INDIGO]

Hello.

Has established АМ. In options has established:

Code: Select all

 CONFIG::g()->cb('service_allow', true);CONFIG::g()->cb('service_name', true);CONFIG::g()->cs('service_name_regex', '`^[[:alnum:]]{3,16}$`'); 

But all the same the point of change of a name at the character is not shown.

How it to correct?

[tropheo]

ACM and castle status are 100% safe? My saver was hacked 2 times with sql injection and other sh1ts...

[daedalus]

@UnIcAL, ha true I'm on it. Could you try the new version ?

@INDIGO, Change Name service isn't implemented atm.

@tropheo, I can't say it's 100% safe. You can use log system which will log all mysql request. By the way be sure to remove access from log folder. Try the last version.

[momo61]

Daedalus,

when will the new styles be released ?

[daedalus]

@momo61, i'm overbooked for now ; no template on board atm.

[disorder35]

Daedalus thanks for the hard work you put on this tool.
One question I run the intall.php and everything is OK.
But when I click on Create on index.php it takes me to this:

Code: Select all

Index of /account_manager     * Parent Directory    * cache/    * classes/    * clean.php    * config.php    * db.sql    * images/    * img.php    * index.php    * install.php    * language/    * libs/    * log/    * readme.txt    * servername.xml    * templates/ 

instead of take me to the create page. Also when I click on Login it take me to

Code: Select all

Not Found The requested URL /account_manager/ was not found on this server.

But the folder is there. I wasn't able to use it yet because of that problem and I really want to use it on my server.
Thanks in advance.

[laguna]

Hi daedalus,

I have the following configuration:

Vista 32Bit
Wamp 2.0
Account Manager "New Version"
install.php check report all criteria as "OK" in green

When attempting to use either the Create Account or to log into an existing account, a blank page is produced and Apache (and only Apache) crashes. The SQL data from the attempt to create the account is present in the l2jdb database (ie username, password, email, timestamp etc) as if it had worked as expected, but no HTML data is returned.

What could be causing this issue? We get the following in the Apache error log:

Code: Select all

[Mon Nov 16 01:57:02 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.[Mon Nov 16 01:57:02 2009] [notice] Child 5824: Exit event signaled. Child process is ending.[Mon Nov 16 01:57:03 2009] [notice] Child 5824: Released the start mutex[Mon Nov 16 01:57:04 2009] [notice] Child 5824: All worker threads have exited.[Mon Nov 16 01:57:04 2009] [notice] Child 5824: Child process is exiting[Mon Nov 16 01:57:04 2009] [notice] Parent: Child process exited successfully.[Mon Nov 16 01:57:04 2009] [notice] Apache/2.2.11 (Win32) PHP/5.3.0 configured -- resuming normal operations[Mon Nov 16 01:57:04 2009] [notice] Server built: Dec 10 2008 00:10:06[Mon Nov 16 01:57:04 2009] [notice] Parent: Created child process 5648[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Child process is running[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Acquired the start mutex.[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Starting 64 worker threads.[Mon Nov 16 01:57:04 2009] [notice] Child 5648: Starting thread to listen on port 80.[Mon Nov 16 01:57:38 2009] [notice] Parent: child process exited with status 255 -- Restarting.[Mon Nov 16 01:57:38 2009] [notice] Apache/2.2.11 (Win32) PHP/5.3.0 configured -- resuming normal operations[Mon Nov 16 01:57:38 2009] [notice] Server built: Dec 10 2008 00:10:06[Mon Nov 16 01:57:38 2009] [notice] Parent: Created child process 7304[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Child process is running[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Acquired the start mutex.[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Starting 64 worker threads.[Mon Nov 16 01:57:39 2009] [notice] Child 7304: Starting thread to listen on port 80.

I've been scratching my head for hours now, I've tried running Apache in all sorts of compatibillity modes as well.

Something was mentioned about 'Cache Folder' access rights - can you explain what I might need to edit if I need to grant access to this?

All help is very much welcome.

Thanks Guys

Hi guys, I have just the same issue here.... had someone found a solutions.....? I also activated php ssl extension... but I'm just lost about what may be the problem.

thks for any help

[daedalus]

I don't know what is your problem. I've heard there are few problems with apache on vista but I can't confirm that.

[disorder35]

about my problem??????????

Edit: Ok I was able to fix it, all I have to do was add "index.php" to apache's conf file at the "Directoryindex" section.
After that it all worked fine.