joshbrews.com
Linux and Beer Brews

I received a box from NorthernBrewer containing 4 ounces of Whole Styrian Goldings hops (vaccum packed), an in line hepa filter and a 2 micron stainless steel diffusion stone for wort aeration. (I still need to purchase an air pump. I can’t wait to brew another batch.

I change upped the memory_limit to 128M in /etc/php5/apache2/php.ini . This has fixed it so that I can run the metadata script from a web browser. I was suprised that I needed to set it this high, but it seems to work ok.

I changed the memory settings in my /etc/php5/cli/php.ini (upped it to 64m) and was able to execute the metadata script by executing the following command as root. I still can not execute it through the GUI.
>php index.php search_metadata

I was having issues with Jinzora not displaying a few buttons on some of the menus. I found that I had to chmod -R 0777 the jinzora directory on my webserver (it was 0755). I hate doing that. BTW the buttons display just fine now. The metadata download still does not work.. it just spins and the page completes loading in about 10 seconds.. whatever script is running in the background is not picking up and actually fetching metadata.

While I was bottling on Friday, a few bottle caps really did not crimp well onto some bottles. Investigation this afternoon revealed that the capper that I am using does not work well with Guiness, Harp, and Bass bottles because the thick part at the top of the bottle is not long enough. The capper does not have anything it can grab onto while it is trying to crimp the cap. If I can find time tomorrow I will post pictures of a good bottle and a bad bottle side by side.

I tried one of these tonght. It was very slightly carbonated, but I did get a little “ffhhtt” when I uncapped it. It is delicious without being too bitter. The hop flavor lingers on a bit, I really like it. I am thinking about the next batch I brew of this one, I will use only 1/2 lb of 10L crystal malt, and make up the difference with Maris Otter. I can really only mash about 4 lbs of grain in my little 9 quart cooler masher. I wish I could go all grain, but that will have to wait a while.

Well… I did a dist-upgrade on my linux box (was running debian stable 3.1), and upgraded to 4.0. After the upgrade Jinzora would not work. I uninstalled all apache, apache2, php4 and mysql5 packages with the –purge option and reinstalled php5, mysql5, and apache2. I then installed php-dev and compiled/installed eaccelerator to help out my ancient celeron. After I got Jinzora setup I enabled all the previously mentioned tweaks, but started receiving an error after I enabling page caching. I found the following fix on the Jinzora forums posted by
Quasimodo on April 11 2007
In frontend/display.php line 158 change

Code:
$signature .= $moreargs[$i];

to

Code:
if(!is_object($moreargs[$i])) {
$signature .= $moreargs[$i];
}

This code change fixed the caching problem. With the upgrade to php5, mysql5, and all the tweaks, jinzora is night and day…way way way … Way faster on this old celeron. My cross my fingers that the new kernel and modules will play well with my raided /boot and /root partitions.

I noticed when I was building indexes for the database that most of these indexes are setup by default now with v 2.7.5 the only index that was not built was the last line of. I tried building the other indexes but I received an error stating something about a duplicate index.
mysql> create index node_art on jz_nodes(main_art);

So I added it

I also edited the settings.php file in the Jinzora directory and changed the line

$enable_page_caching = “false”;

to

$enable_page_caching = “true”;

Seems to be a little better now.

I am installing the new version of Jinzora 2.7.5 and decided to tweak the installation to make it run a bit faster on my old celeron 1ghz linux server. I found the following information on the Jinzora forums.

Information on creating mysql indexes to speed up Jinzora.
posted by Ben August 21 2006 – 19:29
# mysql -u[username] -p [database]
— rock out our nodes:
mysql> create index node_level on jz_nodes(level);
mysql> create index node_hidden on jz_nodes(hidden);
mysql> create index node_featured on jz_nodes(featured);
mysql> create index node_leaf on jz_nodes(leaf);
— rock out our tracks:
mysql> create index track_level on jz_tracks(level);
mysql> create index track_hidden on jz_tracks(hidden);
— these are mostly for charts:
mysql> create index node_viewcount on jz_nodes(viewcount desc);
mysql> create index node_dateadded on jz_nodes(date_added desc);
mysql> create index node_dlcount on jz_nodes(dlcount desc);
mysql> create index node_playcount on jz_nodes(playcount desc);
mysql> create index node_lastplayed on jz_nodes(lastplayed desc);
mysql> create index node_rating on jz_nodes(rating_val desc);
— not sure if this does anything:
mysql> create index node_art on jz_nodes(main_art);

I also made the following changes to the mysql configuration file /etc/mysql/my.cnf

# * Fine Tuning
#
#key_buffer = 16M
#thread_stack = 128K
#thread_cache_size = 80

key_buffer = 64M
max_allowed_packet = 16M
table_cache = 1024
join_buffer_size = 2M
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 768K
myisam_sort_buffer_size = 64M
thread_concurrency = 2

#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

These settings have speed up Jinzora a lot.