At present, master/slave relationships in FreshPorts are not stored optimally. Each port has a field, master_port, which contains the category/port of its master_port, otherwise, it is an empty string. The ideal situation would be a table such as this: create table master_slave ( master_port_id integer not null, slave_port_id integer not null, primary key (master_port_id, slave_port_id) […]
Master/slave relationships Read More »
The tk category now has a member! This category was added to www/en/ports/categories about six months ago. It was this commit that did it. The previously reported problem with virtual categories repeated in production. That is to be expected. The proposed solution exists only on my private dev server at home. Regretably, the solution has
category tk – welcome to the Ports collection! Read More »
MASTERPORT is a tool Mark Linimon and I have used for a while. It seems to have entered into common usage now. freshports.org=# select master_port, category, name from ports_active where master_port like ‘/%’ order by category, name; master_port | category | name ———————————————–+————–+————————— /usr/home/dan/ports/devel/ocaml-camlidl | archivers | ocaml-zip /usr/home/dan/ports/devel/ocaml-camlidl | graphics | ocaml-lablgl /usr/home/dan/ports/japanese/kinput2-freewnn/ |
MASTERPORT : who uses it? Read More »
I’m looking for work. I’m a software developer with lots of sysadmin experience. My ideal job would require multiple skills and involve development of high availability strategy, some coding, database design, and some sysadmin work, although not necessarily in that order. My resume: http://www.freebsddiary.org/dan_langille.php Will consider relocation.
It was quite some time ago that I [finally] moved FreshPorts onto the new server. Today I moved FreshSource over too. Both websites use the same database instance. That is, each website is a different view of the same database. Now that FreshSource is over here, we should be able to start doing a lot
FreshSource and FreshPorts back on the same server Read More »
Late last night, I wrote about a problem with virtual categories. I’ve been unable to reproduce the problem in test. But I did find the problem in production. [dan@supernews:/usr/websites/freshports.org/scripts] $ touch ../dynamic/www.en.ports.categories [dan@supernews:/usr/websites/freshports.org/scripts] $ sh process_www_en_ports_categories.sh about to fetch: fetch -q -o /usr/websites/freshports.org/dynamic/caching/tmp/categories http://www.freebsd.org/cgi/cvsweb.cgi/~checkout~/www/en/ports/categories?rev=HEAD&content-type=text/plain Can’t locate Text/CSV_XS.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl
p5-Text-CSV_XS is missing Read More »
After all I’ve written about virtual categories, it seems I still don’t have them right. The code is there: $ grep -l www/en/ports/categories * process_www_en_ports_categories.sh special_processing_files.pm but things are still not being updated. If you look at the list of categories, sort by Description, you will find several with a description of “This is a
Virtual categories get no respect Read More »
Some people like to break into systems. Some like to find vulnerabilities. The good ones will tell you about the vulnerability so you can fix. Many won’t. Then there are the script kiddies. They don’t know much. They know how to run scripts. Lately, I’ve been seeing these requests to the FreshPorts website: /search.php?stype=http://0x00013.50webs.org/tesgcc.txt? /search.php?stype=http://0x0134.lan.io/pb.php?
Odd way to break in Read More »