Upgrade to quantal
upgrade process
sofficerc take new version /etc/gdm/custom.conf take new verison dpkg problem report to developers including /etc/hobbit/clientlaunch.cfg problem in xymon-client problem cannot be reported. you have already encountered this package installation failure. upgrade did not complete. rebooted came up clean xymon was not running
fixing
xymon package clean up
couldn't find any installer logs that told more about the failure or current state
ran apt-get upgrade to clean up 2 packages not fully installed or removed setting up xymon-client crash, maxreports is already reached
apt-get autoremove: 139 packages failed to configure xymon-client
dpk-reconfigure xymon-client xymon-client is broken or not fully installed
found a bug on launchpad (1069227) that said a fix was to have a process running as hobbit that the script could kill. This worked and apt-get now reports that all packages are installed.
mediawiki schema update
wiki and hobbit are not running.
trying to create a new page fails with a page reset. The apache error logs show child pid exit signal segmentation fault (11)
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT lc_value FROM `mw_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 Function: LCStore_DB::get Error: 1146 Table 'wikidb.mw_l10n_cache' doesn't exist (localhost)
php maintenance/update.php
fixed it.
xymon/hobbit name change
trying to get to xymon generates this error in apache error logs: file does not exist: /var/lib/hobbit
did apt-get remove xymon
apt-get install xymon
that didn't get me much closer I was left with lots of broken links as a result of the name change from hobbit to xymon
apt-get purge xymon apt-get install xymon that didn't seem to work either, but after five minutes it ran and showed a working clean install Now I need to restore my custom configs, but in xymon directories instead of hobbit directories
first, rewrite puppet module that pushes my config for hobbit
lost my cputemp, heater, and bandwidth scripts, so must rewrite them
puppet module is much cleaner now, controlling just custom snippets instead of files that will be overwritten with the next upgrade.
phpmyrecipebook: mysql config, session managment, yucky schema upgrade
lost ability to view the recipebook. Trying to view a page yields a blank page with no error. The apache error logs show a php seg fault: PHP Fatal error: Call to undefined function session_register() in /var/www/phprecipebook-3.01/libs/phpsm/core_API.php on line 94
The session_register() function is deprecated in php 5.3 and removed in php 5.4 I happen to be using php 5.4.6 now.
Upgraded to the latest code for phprecipebook (4.04b) and the error is still present.
The line of code is: session_register($g_sm_session_id);
phpdocs (php.net/manual/en/function.session-register.php) say that the prefered use is $_SESSION["zim"] = "An invader from another planet.";
commenting out the session_register() function got the app to come up without a session But nothing is visible in the database.
A schema upgrade is required. I found the script in sql/upgrade mysql --user=root --password=password food <recipedb-3.00-4.00.sql ERROR 1060 at line 104: Duplicate column name 'restaurant_website'
did it work? no, it appears nothing happened. Actually something happened. The script is not idempotent so I must create a new script to make the changes that were not made by the previous run.
The schema update completed after I eliminated the changes that had previously been made. But the site does not populate with any data from mysql. Apache error log shows mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysqld/mysqld.sock' (2) in /var/www/food/libs/ad0db5/drivers/adodb-mysql.inc.php on line 383, referer: http://www.finninday.net/food/index.php
has mysql changed? /etc/mysql/my.cnf looks like the new location of the socket is /var/run/mysqld/mysqld.sock making the corresponding change in custom_inc.php makes the site display all our hard-won recipes. phew.
But all my restaurant reviews are gone. Bummer.
The query that displays restaurants looks like this: select * from $db_table_restaurants left join $db_table_prices on price_id = restaurant_price where restaurant_user = '" . $DB_LINK->addq($SMObj->getUserID(), get_magic_quotes_gpc()) ."' order by restaurant_name";
That query is in modules/restaurant/index.php
select * from recipe_restaurants; shows 51 in the table.
It looks like I can't see anything without a session object. So I should work on fixing the session problem first.
xymon: load apache rewrite module
Log rotate appears wacky. The most recent apache2/access.log is access.log.1. access.log exists, but is empty.
Trying to restart apache gives a configuration error. configtest failed. syntax error on line 62 of conf.d/xymon Xymon was relying on the rewrite module being enabled, but it wasn't. Now a restart works and the log rotation looks good.
phprecipebook: fiddle with source query for restaurants
I can log into the recipebook now and make changes, but still no restaurants are displayed. When logged in the query sees me as user 3 when all the restaurants are set to user 1, so none are displayed.
Trying to log out triggers a white screen and a fatal php error: call to undefined function session_unregister() on phpSM.class.php line 265
Removing the where clause which limits by userid, I get to see all the restaurants which is the behavior I want. We should all share our restaurant reviews, not horde them to ourselves.
Commented out the session_unregister() and now login and logout function without error.
Still broken: xymon custom graphs
- more refactoring is apparently necessary
- trying to follow the custom graph instructions: http://finninday.net/xymon/help/howtograph.html for cputemp
- phprecipebook shows no ingredients
phprecipebook: ingredient auto-complete in recipe edit
When I try to enter a new recipe, auto-complete shows no ingredients.
- The code for recipe edit is modules/recipes/addedit.php
- line 299 defines the input box, but the autocompletion code is somewhere else
echo "<div class=\"ui-widget\"><input id=\"ingredientAuto_$i\" name=\"ingredientAuto_$i\" value=\"$ingredient_name\"/></div>";
echo "<input type=\"hidden\" id=\"ingredientId_$i\" name=\"ingredientId_$i\" value=\"$ingredient_id\">\n";
- autocomplete is in modules/recipes/addedit.js at line 70
function setupAutocompleteAction()
{
$(".ui-widget").find("input[id^='ingredientAuto_']").each(function()
{
$(this).autocomplete({
source: "index.php?m=ingredients&a=get&format=no",
minLength: 1,
html: true,
select: function(event, ui) {
var $target = $(event.target);
var ingredientIdName = getOtherFromName($target.attr("id"), "ingredientId");
$(ingredientIdName).val(ui.item.id);
}
});
});
- the autocomplete code is called from themes/default/header.php
- the bulk of the autocomplete code is in libs/jquery.ui.autocomplete.html.js
- the variable $incredient_name should contain the values to autocomplete against
- the previous version, where autocomplete worked correctly, looks like this:
// Show the Ingredient value, if AJAX support is enabled use the Auto-Complete Control
if ($autocomplete_enabled)
{
$ingredientText = (isset($ingList[$ingredient_id])) ? $ingList[$ingredient_id] : "";
echo "<div class=\"ui-widget\"><input id=\"ingredientAuto_$i\" name=\"ingredientAuto_$i\" value=\"$ingredientText\"/></div>";
echo "<input type=\"hidden\" id=\"ingredientId_$i\" name=\"ingredientId_$i\" value=\"$ingredient_id\">\n";
- both old and new versions of autocomplete are based on the same query:
index.php?m=ingredients&a=get&format=no
This query is in modules/ingredients/get.php and the query it uses looks like this:
$sql = "SELECT ingredient_name, ingredient_id FROM $db_table_ingredients " . ^M
"WHERE ingredient_name LIKE '%" . $DB_LINK->addq($searchText, get_magic_quotes_gpc()) . "%' AND " .^M
"ingredient_user = '" . $DB_LINK->addq($SMObj->getUserID(), get_magic_quotes_gpc()) ."' ORDER BY ingredient_name";^M
So I changed it back to a globally shared space like this:
$sql = "SELECT ingredient_name, ingredient_id FROM $db_table_ingredients " . ^M
"WHERE ingredient_name LIKE '%" . $DB_LINK->addq($searchText, get_magic_quotes_gpc()) . "%' " .
"ORDER BY ingredient_name";^M
back to fixing xymon custom graphs
- cputemp
- I have the script written and placed here: /usr/lib/xymon/client/ext/cputemp
- I also created a file called cputemp here: /usr/lib/xymon/server/etc/tasks.d
[cputemp]
ENVFILE /usr/lib/xymon/client/etc/xymonclient.cfg
CMD /usr/lib/xymon/client/ext/cputemp
INTERVAL 5m