Problem with XP web publishing Problem with XP web publishing
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Problem with XP web publishing

Started by chtouprute, July 14, 2007, 09:09:42 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

chtouprute

Hello,
First, I'm french and sorry if my english is not so good.

I've got a problem when I'm trying to upload pictures via the XP web publishing wizard.
The wizard asks me to enter the login and password to authenticate, after enter them, the wizard searchs and searchs always.

To explain what I have done. The server is at my home, and freshly installed by my own. Here is my config.
Debian server
Apache 1.3.34-4.1
php 5.2.0-8+etch
mysql 5.0.32-7etch
coppermine 1.4.12

After many trials and after editing the xp_publish.php script, I indentified that the wizard does not receive the confirmation of the authentification.
The script does not execute the process_login function after the login and password entered.

Can you help me ?
Is there a problem with the version of mysql, or php, or other ?
I can give you all rights you want on the gallery or the server, just ask me.

Thanks

Here is the debug informations:

USER:
------------------
Array
(
    [ID] => eb4a71592b72d17b2ba56bb8ea897220
    [am] => 1
    [lang] => french
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => root
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg1411_filetypes; (0.001s)
    [1] => select * from cpg1411_plugins order by priority asc; (0.001s)
    [2] => delete from `album`.cpg1411_sessions where time<1184392932 and remember=0; (0.001s)
    [3] => delete from `album`.cpg1411_sessions where time<1183186932; (0.001s)
    [4] => select user_id from `album`.cpg1411_sessions where session_id=md5("915e1229bf6c51ba92b9637cf654c530b38d87a0c202450bf73338491dbd777b"); (0.002s)
    [5] => select user_id as id, user_password as password from `album`.cpg1411_users where user_id=1 (0.002s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `album`.cpg1411_users AS u INNER JOIN `album`.cpg1411_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.002s)
    [7] => SELECT user_group_list FROM `album`.cpg1411_users AS u WHERE user_id='1' and user_group_list <> ''; (0.002s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg1411_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  cpg1411_usergroups WHERE group_id= 1 (0.001s)
    [10] => update `album`.cpg1411_sessions set time='1184396532' where session_id=md5('915e1229bf6c51ba92b9637cf654c530b38d87a0c202450bf73338491dbd777b'); (0.002s)
    [11] => SELECT user_favpics FROM cpg1411_favpics WHERE user_id = 1 (0.001s)
    [12] => DELETE FROM cpg1411_banned WHERE expiry < '2007-07-14 07:02:14' (0.001s)
    [13] => SELECT * FROM cpg1411_banned WHERE (ip_addr='192.168.137.1' OR ip_addr='192.168.137.1' OR user_id=1) AND brute_force=0 (0.001s)
    [14] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = ''  ORDER BY pos (0.002s)
    [15] => SELECT aid FROM cpg1411_albums as a WHERE category>=10000 (0.001s)
    [16] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [17] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '1'  ORDER BY pos (0.001s)
    [18] => SELECT aid FROM cpg1411_albums WHERE category = 2 (0.001s)
    [19] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.001s)
    [20] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '2'  ORDER BY pos (0.001s)
    [21] => SELECT aid FROM cpg1411_albums WHERE category = 3 (0.001s)
    [22] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0.001s)
    [23] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '3'  ORDER BY pos (0.001s)
    [24] => SELECT aid FROM cpg1411_albums WHERE category = 4 (0.001s)
    [25] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 4 (0.001s)
    [26] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '4'  ORDER BY pos (0.001s)
    [27] => SELECT aid FROM cpg1411_albums WHERE category = 5 (0.001s)
    [28] => SELECT count(*) FROM cpg1411_pictures as p, cpg1411_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 5 (0.001s)
    [29] => SELECT cid, name, description, thumb FROM cpg1411_categories WHERE parent = '5'  ORDER BY pos (0.001s)
    [30] => SELECT aid FROM cpg1411_albums as a WHERE category = '0' (0.001s)
    [31] => SELECT count(*) FROM cpg1411_albums as a WHERE 1 (0.001s)
    [32] => SELECT count(*) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
    [33] => SELECT count(*) FROM cpg1411_comments as c LEFT JOIN cpg1411_pictures as p ON c.pid=p.pid LEFT JOIN cpg1411_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
    [34] => SELECT count(*) FROM cpg1411_categories WHERE 1 (0.001s)
    [35] => SELECT sum(hits) FROM cpg1411_pictures as p LEFT JOIN cpg1411_albums as a ON p.aid=a.aid WHERE 1 (0.001s)
    [36] => SELECT COUNT(*) FROM cpg1411_pictures WHERE approved = 'NO' (0.001s)
    [37] => SELECT count(*) FROM cpg1411_albums as a WHERE category = '0' (0.001s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.0-8+etch4 - OK
------------------
mySQL version: 5.0.32-Debian_7etch1-log
------------------
Coppermine version: 1.4.12(stable)
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.32
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.1
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/php:/usr/share/pear | .:/usr/share/php:/usr/share/pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 2.05 seconds - 38 queries in 0.044 seconds - Album set : ; Meta set: ;

Joachim Müller

Don't post debug_output unless requested. Specify what client browser you use. Do exactly as suggested in the upload troubleshooting section of the docs. Moving to upload board.

chtouprute

I have reposted my problem this morning because I had not seen that it has been moved, sorry.

I have done everythings written in the doc, but it does not work.
I explain again.
The informations about the gallery have been correctly written in the registry by the script, the gallery is correctly seen by the wizard, I select it, the wizard displays the login form, I enter the login and password, and then nothing arrives.

It's not a problem of upload of pictures, when I activate the debug in the coppermine gallery, there is no file created because the xp_publish.php script never reachs the lines where an information can be written in the log file. Because the log concerns exclusively the upload of the pictures and not what it was done before (login form, authentification, ...).

The xp_publish.php script, when called by XP, executes correctly the form_login() function, but never enters in the process_login() or form_publish() functions, because it does not have the authentification return status.

Joachim Müller

Quote from: chtouprute on July 16, 2007, 11:55:34 AM
I have reposted my problem this morning because I had not seen that it has been moved, sorry.
Double postings cause double moderation effort. Please read more carefully next time. I have deleted your other, identical thread.

Quote from: chtouprute on July 16, 2007, 11:55:34 AMI have done everythings written in the doc
No you have not. Let me quote the upload troubleshooting section of the docs, highlighting the stuff you apparently failed to read:
Quote4.11.4 Upload troubleshooting

If you are experiencing issues with coppermine's upload process, temporarily change your coppermine settings as suggested below to get more detailed error messages:

    * Go to your coppermine page and log in as admin
    * Go to the config screen
    * Scroll to the bottom of the page
    * Expand the "Maintenance settings" section by clicking on it
    * Enable debug mode for everyone
    * Leave display of notices switched off
    * Save the new settings by clicking on "Save new configuration"
    * Go to the "groups" panel
    * Set the upload form configuration for all groups to "Single file uploads only" (set File upload boxes to "1", URI upload boxes to "0" and No. of boxes to "fixed")
    * Save your new settings

Then try to upload (using http uploads, even if you experienced troubles using another upload method) - you should get a more detailed error message that tells you what exactly goes wrong with your uploads. If the error message doesn't mean anything to you, search the support board for the error message you get.
When asking for support on the coppermine forum, post a link to your site and a test user account (the test user mustn't be in the admin group!) with upload privileges, with the above mentioned settings in place - this way, supporters can see the error messages as well. Do not post debug_output unless requested.

When people have issues with uploading and decide to post their question on the Coppermine support board, they usually are told to read this upload troubleshooting section. Many of them fail to do so properly, which results in frustration both for users as well as supporters. To make this absolutely clear: the above mentioned steps are absolutely mandatory, no matter what skill level you have, no matter what upload method you have troubles with. Failing to do exactly as suggested will result in your request for help being ignored. Yes, this applies to you. We mean it!
Do exactly as suggested if you want help.

chtouprute

Thanks for your answer.

Now I did all as suggested.
I have created a user account with the good privileges.
The http upload method works fine with the user account, there is no error message.

Here is the user account:
login : testuser
password : usertest

And here is the web link of the site:
http://spirit.dynalias.net/album/