How to get things done working with AIX. Topics here focus on implementation of AIX features including NIM, SUMA, LDAP and RBAC. Topics focusing specifically on virtualization may be in there own sections (e.g. PowerVM, VIOS, WPAR).
Filter     Order     Display # 
Date Item Title Hits
Tuesday, 05 December 2017 How I package OpenSource Packages 5017
Thursday, 19 January 2017 HOWTO: Setup FTP with TLS support 11277
Tuesday, 29 March 2016 Rsync fix corrupt downloads HOWTO 9263
Wednesday, 23 March 2016 HOWTO: NIM server first boot example 8028
Friday, 20 November 2015 SVMON - part 1 10131
Thursday, 18 December 2014 HOWTO: Repair a NIM lppsource 11586
Wednesday, 24 September 2014 HOWTO: Setup DSH 11814
Thursday, 07 August 2014 HOWTO: Collect performance baseline statistics 15996
Monday, 30 September 2013 FAQ: What to look for when NIM boot fails? 11383
Monday, 30 September 2013 FAQ: How to fix a degraded filesystem? 23432
Wednesday, 16 May 2012 HOWTO: POWER On using expect 15441
Monday, 09 April 2012 HOWTO: Update a NIM server 22457
Thursday, 16 February 2012 HOWTO: Install a NIM server 58005
Tuesday, 03 January 2012 HOWTO: NFSv4 primer 22577
Friday, 26 August 2011 HOWTO: Manage Firmware using Inventory Scout 21482
Friday, 08 October 2010 HOWTO: Install AIX 41404
Saturday, 11 September 2010 HOWTO: Stop "PRNG is not Seeded" on AIX 25118
Thursday, 10 June 2010 HOWTO: Prepare for Performance Assessment 25721
Saturday, 03 October 2009 FAQ: Porting Opensource packages to AIX 22692
Tuesday, 08 September 2009 HOWTO: List Inactive Users 20256
 
<< Start < Prev 1 2 Next > End >>
Results 1 - 20 of 38
Login
Lost Password?
43 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 309 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1544941937' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1544941937' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'com'
 AND type = 2
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
11
SELECT *
 FROM jos_menu
 WHERE id = 309
12
SELECT *
 FROM jos_categories
 WHERE id = '19'
13
SELECT *
 FROM jos_sections
 WHERE id = '3'
14
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2018-12-16 07:47' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2018-12-16 07:47' )
 AND b.access <= 0
 WHERE c.section = '3'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
15
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 19
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-16 07:47' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-16 07:47' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
16
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 19
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-12-16 07:47' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-12-16 07:47' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 20
17
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
18
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
19
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 309 )
 ORDER BY ordering
20
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
21
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='rt_splitSuckerFish' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
22
SELECT m.* FROM jos_menu AS m
WHERE menutype='rt_splitSuckerFish' AND m.published='1'
23
SELECT *
 FROM jos_banner
 WHERE showBanner=1
24
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
25
SELECT value
  FROM jos_bookmarks_prefs
 WHERE userid = '-1' AND category = 'params' AND name = 'urlkey'
26
SELECT value
  FROM jos_bookmarks_prefs
 WHERE userid = '-1' AND category = 'params' AND name = 'snapshotactiv'
27
SELECT value
  FROM jos_bookmarks_prefs
 WHERE userid = '-1' AND category = 'params' AND name = 'snapshotother'
28
SELECT id FROM jos_mambots WHERE element = 'mosbookmarks' AND folder = 'content'
29
SELECT *
 FROM jos_mambots
 WHERE id = '32'
30
SELECT name, value
 FROM jos_bookmarks_prefs
 WHERE userid = '-1' AND category = 'params'
 ORDER BY name
31
SELECT c.id, c.parent
 FROM jos_bookmarks_categories as c
 WHERE c.id = -1
32
SELECT *
 FROM jos_bookmarks_columns
 WHERE category=''
 AND custom='0'
33
SELECT *
 FROM jos_bookmarks_columns
 WHERE category=''
 ORDER BY ordering
34
SELECT *
 FROM jos_bookmarks_columns
 WHERE category='admin'
35
SELECT *
 FROM jos_bookmarks_columns
 WHERE category='admin'
 ORDER BY ordering
36
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
37
SELECT *
 FROM jos_mambots
 WHERE id = '27'
38
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
39
SELECT *
 FROM jos_mambots
 WHERE id = '27'
40
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
41
SELECT *
 FROM jos_mambots
 WHERE id = '27'
42
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
43
SELECT *
 FROM jos_mambots
 WHERE id = '27'