Login, Session Issue again

[wolfram]

Hello All, Hello Forum

1. I just installed the latest version of ZM ona SUSE 10 Linux.
2. The installation was despite some OS settings straight foward.
3. I have a running MYSQLD, I have the ZM Database created, I have a database user and password, I can login directly with mySQL etc.
4. I have apache up and running, and I see my other webpages.
Just what is NOT going to work is ZM.
When I try to login, I get the login page again. OK I set debug flag in the zm.php file to true and I get the following output:

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /opt/lampp/htdocs/xampp/homenet/zm/zm.php:28) in /opt/lampp/htdocs/xampp/homenet/zm/zm.php on line 159

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /opt/lampp/htdocs/xampp/homenet/zm/zm.php:28) in /opt/lampp/htdocs/xampp/homenet/zm/zm.php on line 159

I searched through old forum topics regarding that problem,
but could not yet solve that problem.
I tried with almost every browser I tried (Firefox, Mozilla, Internet Explorer) no matter of I run it on the Linux Box nor on Remote windows xp.

Can anybody help me out here to find at least a starting point for debugging ?


Cheers wolfram

[zoneminder]

The debug flag will mess up the session cookies unfortunately so isn't much use here. Are you sure you have a default user? Early 1.21.4 tar files had a bogus insert statement that meant this failed (only for a new install not an upgrade).

If you don't go have one, go into mysql for your database and type the following,

Code: Select all

insert into Users values ('','admin',password('admin'),'',1,'View','Edit','Edit','Edit','Edit','','');

Phil

[wolfram]

I found this bug before in the database create script and had already created a new user.
Thats why I am sure this should work.
Its to bad that the debug mode disturbes the cookie and session stuff.
Unfortunately I dont know to much about cookies and sessions etc.
Shall I rather disable debug,? and whats then ?
Can I disable disable the login dialog to find out if it works in principle ?

cheers wolfram

[zoneminder]

Do you know what version of php and mysql you are running?

One thing you can try is to edit zm_funcs.php, go to the userLogin function and just before the line with mysql_query in it, add the following lines

Code: Select all

echo $sql;
exit;

This will output the sql statement and then exit the script (so you won't get any further). However at least then you can look at the statement and check it looks valid. Plus try applying the same statement to mysql yourself to make sure it works. What you get from that will decide what we do next.

Phil

[wolfram]

well, thanks for reply.

Here is the result of your hint
echo $sql;
:
select * from Users where Username = 'admin' and Enabled = 1

I used admin admin for username password;
it seems to ignore any password I enter;

The PHP version is: 5.05
The Mysql version is: 4.1.13

wolfram

[wolfram]

Actually I tried the login always from a remote machine via ssl.

I have changed the mysql access rights for the local access via localhost user(grant...) etc. but(!!!!) didnt see any difference.

Now I found out that you have to FLUSH Privileges in MySQL to make them valid, and as soon this was done login worked fine.

What can I say: The login into MySQL AND ZM seems to work.
So thanks again for pointing my eyes to the right place in the code. I love the internet and the people...

Now I will try to go the next steps...in exploring ZM )))