Visitors: 16996081

Latest Articles

Blogs

Building python packages using AIXTOOLS python PDF Print E-mail
User Rating: / 0
PoorBest 
Written by Michael Felt   
My starting point is AIXL 5.3 TL7 - the TL/SP packaging that came out together with AIX 6.1.
There are some key differences - don't ask me what - but applications compiled on AIX 5.3 TL6 and earlier may have issues on AIX 5.3 TL7 and later. This process will also work with later versions of AIX.

Starting point

So - fresh install, plus xlc compiler. And no "RPM" packages, other than what the rpm.rte fileset installs.

*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 5.3!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************
root@x065:[/]rpm -qa
AIX-rpm-5.3.7.0-1
root@x065:[/]


Initially - nothing from AIXTOOLS - so first I'll get python installed. See http://www.aixtools.net/index.php/python

+-----------------------------------------------------------------------------+
                         Installing Software...
+-----------------------------------------------------------------------------+

installp:  APPLYING software for:
        aixtools.python.rte 2.7.12.3
        aixtools.python.man.en_US 2.7.12.3

Restoring files, please wait.
4438 files restored.
+------- ensurepip: embedded install of pip and setuptools -------------------+
Ignoring indexes: https://pypi.python.org/simple
Collecting setuptools
Collecting pip
Installing collected packages: setuptools, pip
Successfully installed pip-8.1.1 setuptools-20.10.1
Finished processing all filesets.  (Total time:  50 secs).

+-----------------------------------------------------------------------------+
                                Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name                        Level           Part        Event       Result
-------------------------------------------------------------------------------
aixtools.python.rte         2.7.12.3        USR         APPLY       SUCCESS
aixtools.python.man.en_US   2.7.12.3        USR         APPLY       SUCCESS

AIXTOOLS python comes with pip ready to go!

Installing the man pages is optional. BUT, notice that unlike the BULL/Perzl/IBM packaging pip is available.

To build a package such as cifs - the easy starting point is to let pip download the packages.

Note: before you begin - make sure your filesystems are large enough as pip and
make do not enlarge your filesystems automatically. My defaults are very small:
root@x065:[/]df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           0.12      0.11    9%     1104     4% /
/dev/hd2           0.88      0.13   86%    13601    31% /usr
/dev/hd9var        0.12      0.12    7%      317     2% /var
/dev/hd3           0.12      0.12    2%       46     1% /tmp
/dev/hd1           0.12      0.12    1%        5     1% /home
/proc                 -         -    -         -     -  /proc
/dev/hd10opt       0.25      0.10   59%     5733    19% /opt

This generally gives me enough room to build stuff.

root@x065:[/]chfs -a size=2G /opt
Filesystem size changed to 4194304
root@x065:[/]chfs -a size=1G /tmp
Filesystem size changed to 2097152
root@x065:[/]chfs -a size=1G /var
Filesystem size changed to 2097152
root@x065:[/]chfs -a size=512M /
Filesystem size changed to 1048576

Also make sure your umask is not too strict

root@x065:[/]umask
022

Ready to start:

First we test that pip is able to talk to the outside and see what python dependancies exist, if any.

root@x065:[/]mkdir /tmp/build
root@x065:[/]cd /tmp/build

root@x065:[/tmp/build]pip download cffi
Collecting cffi
  Downloading cffi-1.10.0.tar.gz (418kB)
    100% |################################| 419kB 81kB/s
  Saved ./cffi-1.10.0.tar.gz
Collecting pycparser (from cffi)
  Downloading pycparser-2.18.tar.gz (245kB)
    100% |################################| 256kB 678kB/s
  Saved ./pycparser-2.18.tar.gz
Successfully downloaded cffi pycparser
You are using pip version 8.1.1, however version 9.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

Upgrade pip

Using pip to upgrade itself is a good test that everything is working - and it gets rid of this message!

root@x065:[/tmp/build]pip install --upgrade pip
Collecting pip
  Downloading pip-9.0.1-py2.py3-none-any.whl (1.3MB)
    100% |################################| 1.3MB 158kB/s
Installing collected packages: pip
  Found existing installation: pip 8.1.1
    Uninstalling pip-8.1.1:
      Successfully uninstalled pip-8.1.1
Successfully installed pip-9.0.1

Well, that did not actually test everything - because the C complier was not needed.

So, next try - let's first build the cffi dependency - pycparser.

root@x065:[/tmp/build]pip build pycparser
ERROR: unknown command "build"

Unlike CPAN (think perl) pip(2) does not have a build command - so we just try install.

root@x065:[/tmp/build]pip install pycparser
Collecting pycparser
  Using cached pycparser-2.18.tar.gz
Installing collected packages: pycparser
  Running setup.py install for pycparser ... done
Successfully installed pycparser-2.18

Again - no C compiler needed - so all is good. However, the next step is going to fail because cffi has 'other' dependencies, such as libffi.
But let's pretend we did not know about that!

root@x065:[/tmp/build]pip install cffi
Collecting cffi
  Using cached cffi-1.10.0.tar.gz
Requirement already satisfied: pycparser in /opt/lib/python2.7/site-packages (from cffi)
Installing collected packages: cffi
  Running setup.py install for cffi ... error
    Complete output from command /opt/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-3pvK6g/cffi/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-eaJlQ0-record/install-record.txt --single-version-externally-managed --compile:
    "_configtest.c", line 1.1: 1506-731 (S) The '__thread' keyword is not supported on the target platform.  The keyword is ignored.
    Note: will not use '__thread' in the C code
    ***** The above error message can be safely ignored.

    ld: 0711-736 ERROR: Input file _configtest.o:
        XCOFF64 object files are not allowed in 32-bit mode.
    Note: will not use '__sync_synchronize()' in the C code
    ***** The above error message can be safely ignored.

    running install
    running build
    running build_py
    creating build
    creating build/lib.aix-5.3-2.7
    creating build/lib.aix-5.3-2.7/cffi
    copying cffi/vengine_cpy.py -> build/lib.aix-5.3-2.7/cffi
...
    creating build/temp.aix-5.3-2.7/c
    xlc_r -I/opt/include -O3 -qmaxmem=-1 -qarch=pwr5 -q64 -I/opt/buildaix/includes -DNDEBUG -I/usr/include/ffi -I/usr/include/libffi -I/opt/include/python2.7 -c c/_cffi_backend.c -o build/temp.aix-5.3-2.7/c/_cffi_backend.o
    "c/_cffi_backend.c", line 15.10: 1506-296 (S) #include file <ffi.h> not found.
    "c/malloc_closure.h", line 6.10: 1506-296 (S) #include file <ffi.h> not found.
    "c/malloc_closure.h", line 81.5: 1506-046 (S) Syntax error.
...
    "c/_cffi_backend.c", line 4923.26: 1506-098 (E) Missing argument(s).
    error: command 'xlc_r' failed with exit status 1

    ----------------------------------------
Command "/opt/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-3pvK6g/cffi/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-eaJlQ0-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-build-3pvK6g/cffi/

What can I learn from all those messages?

OK. This failed. HOWEVER - there are some important bits in the error messages.

  1. ld: 0711-736 ERROR: Input file _configtest.o:
    XCOFF64 object files are not allowed in 32-bit mode.

    ♦ The aixtools version of python is compiled in 64-bit mode, so you need to "export OBJECT_MODE=64" before running 'pip install'
  2. xlc_r -I/opt/include -O3 -qmaxmem=-1 -qarch=pwr5 -q64 -I/opt/buildaix/includes -DNDEBUG -I/usr/include/ffi -I/usr/include/libffi -I/opt/include/python2.7

    ♦ the command to build packages is practically hardwired into the packaging. KNOW that you can change these settings in the file /opt/lib/python2.7/_sysconfigdata.py
  3. "c/_cffi_backend.c", line 15.10: 1506-296 (S) #include file <ffi.h> not found.
    ♦ libffi is missing. Either find and download, and compile libffi - or install aixtools.libffi (at http://download.aixtools.net/tools/aixtools.libffi.3.2.1.1.I )

Installation Summary
--------------------
Name                        Level           Part        Event       Result
-------------------------------------------------------------------------------
aixtools.libffi.share       3.2.1.1         USR         APPLY       SUCCESS
aixtools.libffi.rte         3.2.1.1         USR         APPLY       SUCCESS
aixtools.libffi.man.en_US   3.2.1.1         USR         APPLY       SUCCESS

Again man pages are optional.

For "just in case" my packaging has both the 32-bit and 64-bit libraries. And the include file is in /opt/include.

root@x065:[/opt/lib/python2.7]lslpp -f aixtools.libffi.rte
  Fileset               File
  ----------------------------------------------------------------------------
Path: /usr/lib/objrepos
  aixtools.libffi.rte 3.2.1.1
                        /opt/lib/pkgconfig/libffi.pc
                        /opt/include
                        /opt/lib/pkgconfig
                        /opt/include/ffitarget.h
                        /opt/lib/libffi.a
                        /opt/lib
                        /opt/include/ffi.h

root@x065:[/opt/lib/python2.7]ls -l /usr/include/*ffi*
ls: 0653-341 The file /usr/include/*ffi* does not exist.

And, as the (nerly) hardwired xlc command does not have /opt/include (it has /opt/buildaix/includes) - I edit and update the file /opt/lib/python2.7/_sysconfigdata.py

And, now try again...

There are several compiler warnings - I am choosing to ignore - but a loader error catches me:

    /opt/lib/python2.7/config/ld_so_aix xlc_r -bI:/opt/lib/python2.7/config/python.exp build/temp.aix-5.3-2.7/c/_cffi_backend.o -lffi -o build/lib.aix-5.3-2.7/_cffi_backend.so
    ld: 0706-006 Cannot find or open library file: -l ffi
        ld:open(): A file or directory in the path name does not exist.
    error: command '/opt/lib/python2.7/config/ld_so_aix' failed with exit status 255

So, again - my first thought is to edit the /opt/lib/python2.7/_sysconfigdata.py and add /opt/lib to the LDFLAGS definitions. However, that is already there.
Sadly, it seems there is an error in how that ld_so_aix command is called. So, to "make it happen" - the quick path is to also export LDFLAGS.

root@x065:[/opt/lib/python2.7]export LDFLAGS="-L/opt/lib"
root@x065:[/opt/lib/python2.7]pip install cffi
Collecting cffi
  Using cached cffi-1.10.0.tar.gz
Requirement already satisfied: pycparser in ./site-packages (from cffi)
Installing collected packages: cffi
  Running setup.py install for cffi ... done
Successfully installed cffi-1.10.0

Closing

So, I hope this helps - and just enough wandering so that you will be able to resolve future issues on your own!

p.s. - don't forget to verify the install is really there.

root@x065:[/opt/lib/python2.7]pip list --format=columns
Package    Version
---------- -------
cffi       1.10.0
pip        9.0.1
pycparser  2.18
setuptools 20.10.1
 

 
< Prev   Next >

Popular Articles

Legacy PDFs

AIX 5.2
AIX 5.1
122 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 = 89 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1544942086' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1544942086' ) 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 = 89
12 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content' 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.id = 812 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND a.access <= 0
13 SELECT a.id FROM jos_content AS a WHERE a.catid = 74 AND a.state = 1 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) ORDER BY a.created DESC
14 SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM jos_content AS a LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE a.id = 812
15 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '812'
16 SELECT hits FROM jos_core_log_items WHERE time_stamp = '2018-12-16' AND item_table = '#__content' AND item_id = '812'
17 UPDATE jos_core_log_items SET hits = ( hits + 1 ) WHERE time_stamp = '2018-12-16' AND item_table = '#__content' AND item_id = '812'
18 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
19 SELECT value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' AND name = 'urlkey'
20 SELECT value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' AND name = 'snapshotactiv'
21 SELECT value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' AND name = 'snapshotother'
22 SELECT id FROM jos_mambots WHERE element = 'mosbookmarks' AND folder = 'content'
23 SELECT * FROM jos_mambots WHERE id = '32'
24 SELECT name, value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' ORDER BY name
25 SELECT c.id, c.parent FROM jos_bookmarks_categories as c WHERE c.id = -1
26 SELECT * FROM jos_bookmarks_columns WHERE category='' AND custom='0'
27 SELECT * FROM jos_bookmarks_columns WHERE category='' ORDER BY ordering
28 SELECT * FROM jos_bookmarks_columns WHERE category='admin'
29 SELECT * FROM jos_bookmarks_columns WHERE category='admin' ORDER BY ordering
30 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
31 SELECT * FROM jos_mambots WHERE id = '27'
32 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
33 SELECT * FROM jos_mambots WHERE id = '27'
34 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
35 SELECT * FROM jos_mambots WHERE id = '27'
36 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
37 SELECT * FROM jos_mambots WHERE id = '27'
38 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
39 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'
40 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1
41 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 = 89 ) ORDER BY ordering
42 SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND a.catid = 44 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering LIMIT 15
43 SELECT id FROM jos_mambots WHERE element = 'mosbookmarks' AND folder = 'content'
44 SELECT * FROM jos_mambots WHERE id = '32'
45 SELECT name, value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' ORDER BY name
46 SELECT c.id, c.parent FROM jos_bookmarks_categories as c WHERE c.id = -1
47 SELECT * FROM jos_bookmarks_columns WHERE category='' AND custom='0'
48 SELECT * FROM jos_bookmarks_columns WHERE category='' ORDER BY ordering
49 SELECT * FROM jos_bookmarks_columns WHERE category='admin'
50 SELECT * FROM jos_bookmarks_columns WHERE category='admin' ORDER BY ordering
51 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
52 SELECT * FROM jos_mambots WHERE id = '27'
53 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
54 SELECT * FROM jos_mambots WHERE id = '27'
55 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
56 SELECT * FROM jos_mambots WHERE id = '27'
57 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
58 SELECT * FROM jos_mambots WHERE id = '27'
59 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
60 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
61 SELECT m.* FROM jos_menu AS m WHERE menutype='rt_splitSuckerFish' AND m.published='1'
62 SELECT * FROM jos_banner WHERE showBanner=1
63 SELECT a.id, a.title, a.sectionid, a.catid, a.created, a.hits FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND ((TO_DAYS('2018-12-16') - TO_DAYS(a.created)) <= '360') AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.hits DESC LIMIT 3
64 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 807 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
65 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 821 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
66 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 822 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
67 SELECT id FROM jos_mambots WHERE element = 'mosbookmarks' AND folder = 'content'
68 SELECT * FROM jos_mambots WHERE id = '32'
69 SELECT name, value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' ORDER BY name
70 SELECT c.id, c.parent FROM jos_bookmarks_categories as c WHERE c.id = -1
71 SELECT * FROM jos_bookmarks_columns WHERE category='' AND custom='0'
72 SELECT * FROM jos_bookmarks_columns WHERE category='' ORDER BY ordering
73 SELECT * FROM jos_bookmarks_columns WHERE category='admin'
74 SELECT * FROM jos_bookmarks_columns WHERE category='admin' ORDER BY ordering
75 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
76 SELECT * FROM jos_mambots WHERE id = '27'
77 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
78 SELECT * FROM jos_mambots WHERE id = '27'
79 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
80 SELECT * FROM jos_mambots WHERE id = '27'
81 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
82 SELECT * FROM jos_mambots WHERE id = '27'
83 SELECT SUM( hits ) AS count FROM jos_stats_agents WHERE type = 1
84 SELECT a.id, a.title, a.sectionid, a.catid, a.created FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND ( a.catid=29 OR a.catid=74 OR a.catid=47 OR a.catid=49 OR a.catid=50 OR a.catid=51 OR a.catid=19 OR a.catid=54 OR a.catid=30 OR a.catid=7 OR a.catid=41 OR a.catid=37 OR a.catid=27 OR a.catid=28 OR a.catid=3 OR a.catid=76 OR a.catid=1 OR a.catid=45 OR a.catid=46 ) AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC LIMIT 3
85 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 832 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
86 SELECT a.id, a.title, a.sectionid, a.catid, a.created FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND ( a.catid=48 OR a.catid=77 ) AND s.published = 1 AND cc.published = 1 ORDER BY a.created DESC LIMIT 3
87 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 838 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
88 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 831 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
89 SELECT name, value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' ORDER BY name
90 SELECT c.id, c.parent FROM jos_bookmarks_categories as c WHERE c.id = -1
91 SELECT * FROM jos_bookmarks_columns WHERE category='' AND custom='0'
92 SELECT * FROM jos_bookmarks_columns WHERE category='' ORDER BY ordering
93 SELECT * FROM jos_bookmarks_columns WHERE category='admin'
94 SELECT * FROM jos_bookmarks_columns WHERE category='admin' ORDER BY ordering
95 SELECT DISTINCT b.*, u.name AS username FROM jos_bookmarks_itemcat AS i LEFT JOIN jos_bookmarks AS b ON b.id = i.itemid LEFT JOIN jos_bookmarks_categories AS bc ON bc.id = i.catid LEFT JOIN jos_users AS u ON u.id = b.created_by WHERE ((b.published=1 AND b.approved=1) OR b.id IS NULL) AND i.catid IN (4) AND b.access <= '0' AND bc.published = '1' AND bc.access <= '0' AND ((b.private = 0) OR (b.private = 1 AND b.created_by = '0')) ORDER BY b.title ASC
96 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 298) ORDER BY bc.name ASC
97 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 265) ORDER BY bc.name ASC
98 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 297) ORDER BY bc.name ASC
99 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 296) ORDER BY bc.name ASC
100 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 248) ORDER BY bc.name ASC
101 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 246) ORDER BY bc.name ASC
102 SELECT name, value FROM jos_bookmarks_prefs WHERE userid = '-1' AND category = 'params' ORDER BY name
103 SELECT c.id, c.parent FROM jos_bookmarks_categories as c WHERE c.id = -1
104 SELECT * FROM jos_bookmarks_columns WHERE category='' AND custom='0'
105 SELECT * FROM jos_bookmarks_columns WHERE category='' ORDER BY ordering
106 SELECT * FROM jos_bookmarks_columns WHERE category='admin'
107 SELECT * FROM jos_bookmarks_columns WHERE category='admin' ORDER BY ordering
108 SELECT DISTINCT b.*, u.name AS username FROM jos_bookmarks_itemcat AS i LEFT JOIN jos_bookmarks AS b ON b.id = i.itemid LEFT JOIN jos_bookmarks_categories AS bc ON bc.id = i.catid LEFT JOIN jos_users AS u ON u.id = b.created_by WHERE ((b.published=1 AND b.approved=1) OR b.id IS NULL) AND i.catid IN (34) AND b.access <= '0' AND bc.published = '1' AND bc.access <= '0' AND ((b.private = 0) OR (b.private = 1 AND b.created_by = '0')) ORDER BY b.title ASC LIMIT 6
109 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 142) ORDER BY bc.name ASC
110 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 289) ORDER BY bc.name ASC
111 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 242) ORDER BY bc.name ASC
112 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 294) ORDER BY bc.name ASC
113 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 284) ORDER BY bc.name ASC
114 SELECT bc.name as category FROM jos_bookmarks_itemcat i LEFT OUTER JOIN jos_bookmarks_categories bc ON (i.catid = bc.id) WHERE (i.itemid = 293) ORDER BY bc.name ASC
115 SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year FROM jos_content WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 ) GROUP BY created_year DESC, created_month DESC LIMIT 12
116 SELECT a.id, a.title, a.sectionid, a.catid, a.created, a.hits FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND ((TO_DAYS('2018-12-16') - TO_DAYS(a.created)) <= '75') AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.hits DESC LIMIT 3
117 SELECT a.id, a.title, a.sectionid, a.catid FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND a.sectionid > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-16 07:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-16 07:49' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY a.hits DESC LIMIT 3
118 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 174 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
119 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 281 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
120 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 431 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
121 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Products' AND published = 1 AND access <= 0 ORDER BY parent, ordering
122 SELECT m.* FROM jos_menu AS m WHERE menutype = 'PDF Documents' AND published = 1 AND access <= 0 ORDER BY parent, ordering