UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21. Read more.
UPDATE! The community will be go into read-only on April 19, 8am Pacific in preparation for migration on April 21.Read more.
Knowledge Partner Knowledge Partner
Knowledge Partner
1041 views

read connection tables?

Does anyone know of a method to read the OES Connection table...maybe
with an ldap search or something similar? I'm trying to replace an
old unsupported piece of software and I need to be able to use PHP to
query the connection table to compare users and ip addresses. I can
manually view the table in iMonitor, but is there a way to do it
programmatically?

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
Labels (2)
0 Likes
16 Replies
Fleet Admiral
Fleet Admiral

On 11/05/18 18:19, KeN Etter wrote:

> Does anyone know of a method to read the OES Connection table...maybe
> with an ldap search or something similar? I'm trying to replace an
> old unsupported piece of software and I need to be able to use PHP to
> query the connection table to compare users and ip addresses. I can
> manually view the table in iMonitor, but is there a way to do it
> programmatically?


You don't say which version of OES you're using but I'm fairly certain
that this information is not available via LDAP queries for any version
of OES. Instead this is available via Novell Remote Manager[1] and the
"ncpcon connection" command[2] - could you not call the latter from your
PHP script?

HTH.

[1] https://www.novell.com/documentation/oes11/file_ncp_lx/data/abug8tb.html
[2]
https://www.novell.com/documentation/oes11/file_ncp_lx/data/ba456t4.html#ba54twe
--
Simon
Micro Focus Knowledge Partner

------------------------------------------------------------------------
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.
------------------------------------------------------------------------
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

On Mon, 14 May 2018 11:13:01 GMT, Simon Flood
<smflood@no-mx.forums.microfocus.com> wrote:

>On 11/05/18 18:19, KeN Etter wrote:
>
>> Does anyone know of a method to read the OES Connection table...maybe
>> with an ldap search or something similar? I'm trying to replace an
>> old unsupported piece of software and I need to be able to use PHP to
>> query the connection table to compare users and ip addresses. I can
>> manually view the table in iMonitor, but is there a way to do it
>> programmatically?

>
>You don't say which version of OES you're using but I'm fairly certain
>that this information is not available via LDAP queries for any version
>of OES. Instead this is available via Novell Remote Manager[1] and the
>"ncpcon connection" command[2] - could you not call the latter from your
>PHP script?
>
>HTH.
>
>[1] https://www.novell.com/documentation/oes11/file_ncp_lx/data/abug8tb.html
>[2]
>https://www.novell.com/documentation/oes11/file_ncp_lx/data/ba456t4.html#ba54twe


Simon
Thanks! I learned something new today...if only that meant I could
head home now. 🙂 One more question if you don't mind. If I type
"ncpcon connection list" at the console, I see what I need. But
instead of displaying the results on the screen, I need to return it
to a variable or array. I can script simple things, but I would never
call myself a programmer. Any suggestions for how to get that list
back so I can act on it with my PHP script? Thanks again!

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

Forgot to include in my reply, I am running OES 2015 SP1

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Fleet Admiral
Fleet Admiral

On 14/05/18 13:56, KeN Etter wrote:

> Thanks! I learned something new today...if only that meant I could
> head home now. 🙂 One more question if you don't mind. If I type
> "ncpcon connection list" at the console, I see what I need. But
> instead of displaying the results on the screen, I need to return it
> to a variable or array. I can script simple things, but I would never
> call myself a programmer. Any suggestions for how to get that list
> back so I can act on it with my PHP script? Thanks again!


You should be able to use PHP's shell_exec function - see
http://php.net/manual/en/function.shell-exec.php .

HTH.
--
Simon
Micro Focus Knowledge Partner

------------------------------------------------------------------------
If you find this post helpful and are logged into the web interface,
please show your appreciation and click on the star below. Thanks.
------------------------------------------------------------------------
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

ketter;2480799 wrote:
Does anyone know of a method to read the OES Connection table.


Would some bash scripts using neocon be of use to you for this? I have a bunch that I created for various diagnostics that might help. I can send them your way once I'm able to connect with a real system.
___
“i’ve sworn an oath of solitude til the blight is purged from these lands”
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

On Wed, 23 May 2018 20:26:01 GMT, konecnya
<konecnya@no-mx.forums.microfocus.com> wrote:

>
>ketter;2480799 Wrote:
>> Does anyone know of a method to read the OES Connection table.

>
>Would some bash scripts using neocon be of use to you for this? I have a
>bunch that I created for various diagnostics that might help. I can
>send them your way once I'm able to connect with a real system.


Possibly...any assistance would be appreciated. I started working on
this but got interrupted with other things and haven't jumped back on
it yet.

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

In article <c4lbgdlmo3jnv0q65h7iajnbknv663usf4@4ax.com>, KeN Etter
wrote:
> Possibly...any assistance would be appreciated. I started working on
> this but got interrupted with other things and haven't jumped back on
> it yet.


Temp Link sent to you via the forum PM. Eventually I will figure out
GIThub figured enough to share them properly here.


Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!

___
“i’ve sworn an oath of solitude til the blight is purged from these lands”
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

On Thu, 24 May 2018 17:05:27 GMT, Andy Konecny
<konecnya@no-mx.forums.microfocus.com> wrote:

>In article <c4lbgdlmo3jnv0q65h7iajnbknv663usf4@4ax.com>, KeN Etter
>wrote:
>> Possibly...any assistance would be appreciated. I started working on
>> this but got interrupted with other things and haven't jumped back on
>> it yet.

>
>Temp Link sent to you via the forum PM. Eventually I will figure out
>GIThub figured enough to share them properly here.


Got it. Thanks!

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

On Mon, 14 May 2018 16:39:09 GMT, Simon Flood
<smflood@no-mx.forums.microfocus.com> wrote:

>On 14/05/18 13:56, KeN Etter wrote:
>
>> Thanks! I learned something new today...if only that meant I could
>> head home now. 🙂 One more question if you don't mind. If I type
>> "ncpcon connection list" at the console, I see what I need. But
>> instead of displaying the results on the screen, I need to return it
>> to a variable or array. I can script simple things, but I would never
>> call myself a programmer. Any suggestions for how to get that list
>> back so I can act on it with my PHP script? Thanks again!

>
>You should be able to use PHP's shell_exec function - see
>http://php.net/manual/en/function.shell-exec.php .


Simon,
This works if I call the php script from the command line while logged
in as root. But if I run the script on the site, it does not work. I
assume this may be because the web server user doesn't have necessary
rights. Any suggestions for how to make this work without causing a
security risk?

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

On Fri, 11 May 2018 17:19:38 GMT, KeN Etter
<ketter@no-mx.forums.microfocus.com> wrote:

>Does anyone know of a method to read the OES Connection table...maybe
>with an ldap search or something similar? I'm trying to replace an
>old unsupported piece of software and I need to be able to use PHP to
>query the connection table to compare users and ip addresses. I can
>manually view the table in iMonitor, but is there a way to do it
>programmatically?


Simon, Andy, or anyone else...

I have done some testing with the ncpcon connection command...both in
PHP scripts and from Andy's scripts. The problem I see is that this
is a very slow process. That command has to scroll through all the
connections and outputs everything to the screen. I don't have access
to the source code to know how my current NLM is doing this, but the
response is instantaneous. I am using this to query a user for our
intranet and I need immediate response...waiting for ncpcon connection
to run is going to take way too long. Any thoughts or suggestions?
Thanks!

--
Ken
Knowledge Partner

If this post was helpful and you are logged into the web interface,
please show your appreciation and click on the star below... Thanks!

Create and vote for enhancements!
https://www.microfocus.com/products/enhancement-request.html
--
Ken
Knowledge Partner

Create and vote for enhancements in the Idea Exchange forums!
Don't forget to Like helpful posts and mark Solutions!
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

In article <62a5jdprvfqgvnnv0h5ep4v4ufhl41ujpe@4ax.com>, KeN Etter
wrote:
> I have done some testing with the ncpcon connection command...both in
> PHP scripts and from Andy's scripts. The problem I see is that this
> is a very slow process.


Perhaps lets go back to what is it that you are actually trying to do
instead of articulating some of the nuts and bolts?
Is it that you just want to know what is the last IP address a
specified user used?
WebSense does something basic like that with LDAP, so I could do some
traces to see what exactly is the query.


Andy of
http://KonecnyConsulting.ca in Toronto
Knowledge Partner
http://forums.novell.com/member.php/75037-konecnya
If you find a post helpful and are logged in the Web interface, please
show your appreciation by clicking on the star below. Thanks!

___
“i’ve sworn an oath of solitude til the blight is purged from these lands”
Andy of Konecny Consulting in Toronto
Knowledge Partner Profile
If you find a post helpful, click the Like button below. Thanks!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.