Leginon

Frank,

According to Denis, this may be solved by changing the error_reporting variable in /etc/php.ini as follows:

error_reporting = E_ALL & ~E_NOTICE

Let us know if that works.

Jim

Hi Jim and Denis,

"pulokas" wrote:

[...] changing the error_reporting variable in /etc/php.ini as follows:

error_reporting = E_ALL & ~E_NOTICE

the error messages are now cut down to

[Thu Oct 30 18:47:12 2008] [error] [client 10.1.103.215] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/inc/leginon.inc on line 518, referer: http://pc-polara1/addgroup.php
[Thu Oct 30 18:47:12 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/addgroup.php on line 82, referer: http://pc-polara1/addgroup.php

but addgroup.php still does not add new groups.

frank

We are having trouble reproducing this problem here. There is a php script in dbem that is supposed to create a few tables automatically the first time you go to admin.php. That is where GroupData should be created. Most of the tables you currently have were created when you started Leginon for the first time. Only your tables viewer_comment and viewer_update where created by php.

Here is what to try next:

- start over by dropping all tables from the database

- go to the admin.php web page before running Leginon

- check to see what tables have been created, and if there are any errors in the log files.

"pulokas" wrote: We are having trouble reproducing this problem here. There is a php script in dbem that is supposed to create a few tables automatically the first time you go to admin.php. That is where GroupData should be created. Most of the tables you currently have were created when you started Leginon for the first time. Only your tables viewer_comment and viewer_update where created by php.

Here is what to try next:
- start over by dropping all tables from the database
- go to the admin.php web page before running Leginon
- check to see what tables have been created, and if there are any errors in the log files.

OK. I dropped the tables and started admin.php. The following tables were created:

mysql> show tables;
+--------------------+
| Tables_in_dbemdata |
+--------------------+
| viewer_comment     | 
| viewer_update      | 
+--------------------+
2 rows in set (0.00 sec)

mysql> 

No MySQL, system or http errors.

When I click on the "Users" icon, the following http error messages are issued:

[Tue Nov 04 12:36:37 2008] [error] [client 10.1.103.215] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/inc/leginon.inc on line 518, referer: http://pc-polara1/admin.php
[Tue Nov 04 12:36:37 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 118, referer: http://pc-polara1/admin.php
[Tue Nov 04 12:36:37 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 165, referer: http://pc-polara1/admin.php

...then I enter a username, type tab to go the next field, and the following error messages are issued:

[Tue Nov 04 12:37:09 2008] [error] [client 10.1.103.215] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/inc/leginon.inc on line 518, referer: http://pc-polara1/adduser.php
[Tue Nov 04 12:37:09 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 118, referer: http://pc-polara1/adduser.php
[Tue Nov 04 12:37:09 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 165, referer: http://pc-polara1/adduser.php

...then I type the users' full name and click "Save" and the following http error messages are issued:

[Tue Nov 04 12:37:33 2008] [error] [client 10.1.103.215] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/inc/leginon.inc on line 518, referer: http://pc-polara1/adduser.php
[Tue Nov 04 12:37:33 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 118, referer: http://pc-polara1/adduser.php
[Tue Nov 04 12:37:33 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/adduser.php on line 165, referer: http://pc-polara1/adduser.php

No user is created!

When I add a group, the following http error message is issued:

[Tue Nov 04 12:40:33 2008] [error] [client 10.1.103.215] PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/inc/leginon.inc on line 518, referer: http://pc-polara1/addgroup.php
[Tue Nov 04 12:40:33 2008] [error] [client 10.1.103.215] PHP Warning:  Invalid argument supplied for foreach() in /var/www/html/addgroup.php on line 82, referer: http://pc-polara1/addgroup.php

No group is created.

/var/www/html/config.php is OK.

Then I started start-leginon.py and - voila - some more tables are created:

mysql> show tables;
+-------------------------+
| Tables_in_dbemdata      |
+-------------------------+
| ConnectToClientsData    | 
| SessionData             | 
| SetupWizardSettingsData | 
| UserData                | 
| viewer_comment          | 
| viewer_update           | 
+-------------------------+
6 rows in set (0.00 sec)

mysql> 

Still: GroupData is missing.

Does that help to have an idea where the problem lies?

frank

Hi,

any news on that? Do you require files from me (which ones) to go on with that? Should I test/try other things? We are kind of blocked by this strange issue.

Cheers

frank

Hi Frank,

Sorry, I have been out for a few weeks with a new baby and trying to get caught up again. One thing to try is the newer version of dbem (1.4.5) that we now have available on the download page: http://emg.nysbc.org/software/dbemtools/

Also, can you gather some information about your apache/php installation and send it to us. For instance, create a php script called info.php in your top level web server directory with the following:

<?
phpinfo();
?>

Go to that page with your browser and send us the generated output. I'm not sure if it is easier to post your info here or send it direct to our email. You may want to send it directly to Denis, since he will understand it better than me, and I am not sure he checks these messages very often).

Jim

Hi Jim,

sorry for the looooong delay in my answer.

"pulokas" wrote: One thing to try is the newer version of dbem (1.4.5) that we now have available on the download page: http://emg.nysbc.org/software/dbemtools/

Updating to 1.4.5. in fact resolved the problem. I also had to enable mrc.so in /etc/php.d/mrc.ini (I had to disable this with dbem 1.4.2 for a reason I don't remember any more). Users and groups are now created and edited w/o problems.

Thanks a lot and merry christmas and a happy new year.

frank

btw: After admin.php of dbem 1.4.5 has been accessed once, also dbem 1.4.2's admin.php started working. It was merely a matter of the initial table creation that didn't work with 1.4.2.

frank