Yeah I had the same; after the next usegroup / spots update everything will be back to normal

Cool
Weird that you have to run it from /root, but glad it's fixed now

For spotnets, i think you just have to go to admin->set updating, and enable it. If not pre-configured, the group is free.pt.

Rest should be easy to configure.

Ok, I think I see the problem.

You may not have the mysql client. Install it with:

Code:

sudo apt-get install mysql-client

If this doesn't fix it, could you post the result of:

Code:

dpkg -l | grep mysql

?

Alternatively, you can copy/paste the content directly into the mysql client:

Code:

/usr/share/urd/install$ mysql -u root -p urddb
Enter password:
<enter your password>

then copy/paste this into the console:

Code:

alter table groups add column `minsetsize` bigint(16) not null default 0;

DROP TABLE IF EXISTS `nfo_files`;
CREATE TABLE `nfo_files` (
    `id` bigint(16) unsigned not null auto_increment,
        `setID` char(32) NOT NULL default '',
        `groupID` bigint(16) unsigned NOT NULL default '0',
        `binaryID` char(32) NOT NULL default '',
    PRIMARY KEY(`id`)
);


DROP TABLE IF EXISTS `spot_messages`;
CREATE TABLE `spot_messages` (
    `id` bigint(16) unsigned NOT null auto_increment,
        `message_id` char(255) NOT NULL default '',
    PRIMARY KEY(`id`)
);



DROP TABLE IF EXISTS `spots`;
CREATE TABLE spots(
   `id` bigint PRIMARY KEY AUTO_INCREMENT,
    `messageid` varchar(128) NOT NULL,
    `spotid` char(32) NOT NULL,
    `category` INTEGER DEFAULT 0 NOT NULL,
    `subcat` INTEGER DEFAULT 0 NOT NULL,
    `poster` TEXT NOT NULL,
    `subcata` VARCHAR(64) NOT NULL,
    `subcatb` VARCHAR(64) NOT NULL,
    `subcatc` VARCHAR(64) NOT NULL,
    `subcatd` VARCHAR(64) NOT NULL,
    `subcatz` VARCHAR(64) NOT NULL,
    `title` TEXT NOT NULL,
    `tag` TEXT NOT NULL,
    `url` varchar(255) NOT NULL,
    `image` varchar(255) NOT NULL,
    `stamp` INTEGER DEFAULT 0 NOT NULL,
    `filesize` bigint DEFAULT 0 NOT NULL,
    `description` TEXT DEFAULT '' NOT NULL,
    KEY `spotid_ixd` (`spotid`)
);

Now your database should be manually updated.

I'm discombobulated :B

The file is there, but you said:

Code:

/usr/share/urd/install# mysql -u root -p <  update_db_1.0.7_to_1.0.8_mysql.sql
bash: update_db_1.0.7_to_1.0.8_mysql.sql: Bestand of map bestaat niet

So somehow it's not finding a file that's really there...
This works for me:

Code:

/var/www/urd/install$ mysql -u root -p urddb < update_db_1.0.7_to_1.0.8_mysql.sql
Enter password:

(you have to specify the urd database name (in my case urddb) or mysql won't know which database you're trying to change)

Can you check you didn't make a typo?

Sorry for the inconvenience btw

Interesting

Can you post the output of :

Code:

ls -l /user/share/urd/install

?

Hey Henk,

you're trying to refer to 'install/update...' in the 'install/' folder.
Either do:

Code:

/usr/share/urd# mysql -u root -p <  install/update_db_1.0.7_to_1.0.8_mysql.sql

or

Code:

/usr/share/urd/install# mysql -u root -p <  update_db_1.0.7_to_1.0.8_mysql.sql

I've fixed it in the latest SVN version.
If you want to correct your current installation, i think this should do it:

Edit the js.js file, find the "update_widths" function.
Remove this function.
Then, go BELOW the getElementsByClassName" function and add the following new "update_widths" function:

Code:

function update_widths()
{
    var textwidth = document.getElementById("browsesubjecttd").offsetWidth;

    var setelements = getElementsByClassName('donotoverflowdamnit');
    for (var i=0; i < setelements.length; i++) {
        setelements[i].style.width= textwidth + 'px';
    }
}

I think the order was the biggest issue as the function was being called before it was defined.

I found that IE8(?) does not show the subject names, so that's a bug there. Maybe you're using firefox at work?

Will have a look at this.

Ok, lez get to the bottom of this

Try the following:

Code:

sudo -u www-data php -r 'var_dump(is_dir("/home"));'

If this works (true), then it's very likely a permission problem in /home/bcr. Make sure it is possible to enter /home/bcr with user www-data:
Option a) Add www-data to the group bcr in /etc/group
Option b) 'chmod a+r /home/bcr'
If you retry the same command, does it show (true) now?

If this doesn't work (false), it would seem that something is preventing PHP from reading files outside the 'normal directories'. This can be due to AppArmor. What OS are you running, and what is the output of 'sudo apparmor_status' ?

Were you able to use URD before the upgrade?
And what news provider do you use?

FYI:

If you're running the latest (svn) version, there's a QUERY_LOG check in db.class.php, and it will write the results to the QUERY_LOG_FILE (this should be set to '/tmp/urd_query.log' in defines.php).

After an svn up several days ago the IO wait times have increased drastically.
Server is done with the updates at ~16:00 now instead of 10:00.

Installed 'iotop' and it's purely mysql reading and writing stuff from/to disk all the time. What changed?

Some measures have been taken to stop the large number of spam-forum-registrations.

Forum registration has been set to member activated again. (Read on )

Mod HttpBL is installed, which checks the IP address of new users with the spammer-database at projecthoneypot.org. Matches are shown a warning page with a captcha in case they're actually legitimate visitors.

Mod StopSpammers is installed, which checks new registrations with the stopforumspam.com database. Matches are changed to 'admin approval' meaning that us admins need to manually approve the account before they can post stuff.

Hopefully this stems the tide

If you could give us an nzb that doesn't work in URD but does work in other clients, that would be even more awesome

awesome

Hi,
What I see is that Spearhead has older posts (30w) than you (only 3w).

(Spearhead probably filters out stuff that is incomplete as a preference).

Are you sure your newsserver has a retention that matches 30 weeks?

That's because you don't have the parts tables.
That's the reason I pasted the details of said tables earlier

You'll have to manually create them, but if URDD starts I recommend you try adding a newsgroup in the webinterface and see if that works.

Let's step back a bit here

Do you have a subscription to a usenet provider?
Because you need one to access the usenet groups/data.

What I see from your screenshots is that you first have hitnews.eu and newszilla (is dutch) selected, and at the end (after autoconfigure apparently) a south african newsserver.

Without a usenet subscription (which MAY be part of your ISP contract) you can't really use URD.

I think when a group is subscribed, there are some tables that are generated.

Code:

mysql> describe parts_60
    -> ;
+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| ID         | bigint(16) unsigned | NO   | PRI | NULL    | auto_increment |
| binaryID   | varchar(32)         | NO   | MUL |         |                |
| messageID  | varchar(255)        | NO   |     |         |                |
| subject    | varchar(512)        | NO   |     |         |                |
| fromname   | varchar(512)        | NO   |     |         |                |
| date       | int(16) unsigned    | YES  |     | 0       |                |
| partnumber | int(16) unsigned    | NO   |     | 0       |                |
| size       | int(16) unsigned    | NO   |     | 0       |                |
| groupID    | bigint(16) unsigned | NO   |     | 0       |                |
| dirty      | smallint(6)         | NO   | MUL | 0       |                |
+------------+---------------------+------+-----+---------+----------------+
10 rows in set (0.09 sec)

mysql> describe binaries_60;
+------------+---------------------+------+-----+---------+-------+
| Field      | Type                | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| binaryID   | varchar(32)         | NO   | PRI | NULL    |       |
| subject    | varchar(512)        | NO   |     |         |       |
| fromname   | varchar(512)        | NO   |     |         |       |
| date       | int(16) unsigned    | YES  |     | 0       |       |
| bytes      | bigint(16) unsigned | NO   |     | 0       |       |
| totalParts | int(16) unsigned    | NO   |     | 0       |       |
| setID      | varchar(50)         | YES  | MUL | 0       |       |
| dirty      | smallint(6)         | NO   | MUL | 0       |       |
+------------+---------------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

mysql> select * from groups where ID = '60';
+----+-----------+---------------------+-------------+--------------+--------+-------------+-----------+--------+--------------+----------------+--------------+------------+---------------+
| ID | server_ID | name                | last_record | last_updated | active | description | postcount | expire | refresh_time | refresh_period | first_record | mid_record | extset_update |
+----+-----------+---------------------+-------------+--------------+--------+-------------+-----------+--------+--------------+----------------+--------------+------------+---------------+
| 60 |         0 | alt.binaries.movies |    50959898 |   1279242930 |      1 |             |    324970 |      5 |          195 |              2 |     19770491 |   19770491 |    1279281600 |
+----+-----------+---------------------+-------------+--------------+--------+-------------+-----------+--------+--------------+----------------+--------------+------------+---------------+
1 row in set (0.00 sec)

But basically you should try to do this from the GUI
First thing to do is to get the URD daemon running. Try starting it from the command line with ./urdd_sh and see what happens.

My apologies, spearhead has been drinking

Also I made something but I can't be arsed to register just so I can submit, I'll send em to you spear :B

Hello!

If I'm right, this is what you need to do:

Admin -> Configuration
Change 'user experience level' to 'grandmaster'.
Apply.
Then, change 'download permissions' to 'Owner & Group read & write'.
Apply.

(Sorry, no execute flags )

Are you saying URD is not easy to use?

Yep

It does a string search for '/tmp' and if it finds it, it is assumed that it hasn't been moved. So in your case it always contains /tmp and hence the problem.

In the latest SVN it should be fixed.
Alternatively you can edit ajax_showpreview.php and change the relevant part to this:

Code:

       // First, do a manual check if we're not pointing to /tmp (this should always be to /preview)
        // It would be better if QUEUE_FINISHED was only set after it's moved to /preview but this is a workaround.

        $dlpath = get_dlpath($db);
        $previewpath = $dlpath . PREVIEW_PATH;
        if (substr($path, 0, strlen($previewpath)) == $previewpath)
        {
                // Everything cool, put all preview files into $files:
                $files = array();

                if ($handle = @opendir($path)) {
                        while (FALSE !== ($file = readdir($handle))) {
                                if (!in_array($file, array('.','..', URDD_DOWNLOAD_LOCKFILE))) {
                                        $files[] = /*utf8_encode*/ ($file);
                                        if (strtolower(substr($file, -4)) == '.nzb')
                                                $isnzb ++;
                                        elseif (strtolower(substr($file, -4)) == '.nfo' && $rprefs['parse_nfo'] != 0) {
                                                if ($binary_id != '' && $group_id != 0)
                                                        do_magic_nfo_extsetinfo($db, $path, $file, $binary_id, $group_id, $userID);
                                        }
                                }
                        }
                        closedir($handle);
                }
        } else {
                // Downloaded file has not yet been moved from /tmp to /preview:
                $finished = 0;
                $progress = 99;
                $files = array();
                write_log('Reached preview page while download was not yet moved to /preview', LOG_NOTICE);
        }

Hi, and yes

It gets put on 99% if the download is complete but the file has not yet been moved from the /tmp to /preview folder.

After moving is complete, status should be 100%.
Can you check that the file is actually moved to /preview?