openbd / openbd-administrator Goto Github PK

Two more enhancement requests on the scheduled task page (this will be the
last, I promise).

1. Sort the task list by clicking the column headers:

We have a number of sites running the same core application, and they all require the same 6-8 scheduled jobs per site (some daily, weekly, and monthly). Our scheduled task list already has over 40 tasks. We like to spread out the big nightly jobs through the night so everything doesn't run at once. Adding a new site is tedious trying to organize the time slots for the new tasks (some jobs for each site need to run close to midnight, others later, so the sites have intermixed tasks by time). Being able to sort the task list by start time, name, frequency, etc., would be a major help to us. Could the column titles be made into links that sort the list and re-display the table?

2. A new input field for each task called 'Group':

If there were one more optional input field for a task called 'Group', we could use that field as a common label for all the tasks for a single site, then we could also use the sort function to sort by Group, listing all the tasks for that site together. Right now we pre-pend the site name to the task name, but we can't then sort by task name to view all the same tasks for all sites (this would also be useful to make sure we didn't leave out a task for a new site).

These ideas may be too specific to our setup, but I could imagine that there might be others with a similar production setup as we have. Anyway, thanks for considering these suggestions, and thanks again for your work on
the project.

Add "jump to page" or even "jump to entry" functionality to the log viewer. Also might be nice to be able to configure the number of entries per page. Search functionality might be nice as well.

To make things a bit easier for people, add some of the common database-specific connection options for databases to the datasource configuration forms.

Migrate admin to use Mach-II. After some discussion, Matt and I decided that things like i18n and other items would be easier if we just used Mach-II instead.

The "threads" monitoring page didn't make it in the 1.0 release, so this should be added in a future release.

When configuring/editing CFX tags, depending on the order in which you click around that section of the admin, a CFX tag struct may get put in the session and then not get cleared out when you go, for example, from the C++ tag to the Java tag page. This causes unexpected behavior (such as the edit form being populated when clicking on the link to add a new tag) or errors to be thrown (such as when the Java CFX tag form is hit and a C++ CFX tag is in the session).

The page showing runtime state for datasources did not make it into the 1.0 release. Need to add this to a future release.

Enhance the admin API for easy HTTP and remote access to administrator functionality. For example, being able to reload the server config using a tools like fetch and a URL such as fetch http://foo.com/bluedragon/administrator/reloadcfg?passwd=foo

Need to add proxy user and proxy password fields to scheduled task form since they are in the cfschedule tag now

There was an addition to the OpenBD core on July 9, 2015 that added the function of isUserLoggedIn to the core. This function is used in the Administrator Base.cfc and called by the root Application.cfc. Because of the conflict, the Administrator always thinks that you are not logged in. By changing the function in the Base.cfc and application.cfc to something like isAdminUserLoggedIn, this solves the issue.

Not a huge deal, but things with working paths will be a bit cleaner if they're all built using cfEngine.getWorkingDirectory() since that will be pretty foolproof regardless of the particulars of the setup.

As of latest version of OpenBD the count shows up as -1 for some reason.

Since the background process to check for session/application timeouts only runs every two minutes, add a note to the application/session timeout screen letting people know that values below 2 minutes won't have any effect.

Might be worth adding this as a configurable setting in the engine I suppose, with a default of 2 minutes, but then if people really need something with more precision and want to accept the overhead involved with the background process running more frequently, they could configure it.

Latest OpenBD source, latest Administrator source, Tomcat 7.0.42, ROOT web application:

https://www.dropbox.com/s/u5zfmo826ssn2po/Screenshot%202015-04-22%2018.14.58.png?dl=0

The requested SESSION scope is not enabled.
Request /bluedragon/administrator/index.cfm
File Trace /Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/administrator/index.cfm
|
+-- /Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/administrator/Application.cfc
|
+-- /Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/adminapi/Administrator.cfc
Type Application
Function(s) onApplicationStart (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/administrator/Application.cfc, Line=32, Column=2)
|
+--setInitialSecurity (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/adminapi/Administrator.cfc, Line=30, Column=151)
Tag Context CFSET (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/adminapi/Administrator.cfc, Line=46, Column=7)
|
+-- CFIF (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/adminapi/Administrator.cfc, Line=44, Column=5)
|
+-- CFFUNCTION (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/adminapi/Administrator.cfc, Line=30, Column=151)
|
+-- CFSCRIPT (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/administrator/Application.cfc, Line=33, Column=3)
|
+-- CFFUNCTION (/Developer/apache-tomcat-7.0.42/webapps/ROOT/bluedragon/administrator/Application.cfc, Line=32, Column=2)
Source
43:
44:
45: <!--- need to log in briefly to be able to call setConfig() --->
46:
47:
^ Snippet from underlying CFML source

Admin console is currently English only. Look into adding i18n, likely using the i18n functionality in Mach-II 1.9 when we move things to Mach-II.

Need an easy way to copy/paste the info under Server -> System Info to share for troubleshooting purposes.

I built a fedex web service that was working at one point (March 30) I updated to October 17 build a while back and never realized a problem arrose. I just tried the recent build and it is still occuring. I reduced the code to a simplier test, and all it does is go into a loop and eventual eats all the system resources.

Here is a simple page I was testing.

The Verify of a datasource does not work any more... Nightlybuild after v2.0.2

No such function exists - cachedeleteall.

Request /bluedragon/administrator/settings/_controller.cfm

File Trace /opt/OpenBD/webapps/openbd/bluedragon/administrator/settings/_controller.cfm
|
+-- /opt/OpenBD/webapps/openbd/bluedragon/adminapi/Caching.cfc

Derrick Jackson and I were working through some issues with huge numbers of sessions being spawned on some servers for various reasons, and we took the simple route of fixing it since sessions weren't needed on these boxes of setting the session timeout globally to 1 second.

The problem is the session timeout also affects the OpenBD admin app so it too had a session timeout of 1 second, so Derrick set a timeout of 20 minutes specific to the OpenBD admin app in its Application.cfc.

I'm thinking this should become part of the code to avoid issues like this in the future.

Reported by dothebizznow, Jan 18, 2012
Is there a reasonable reason why Datasource Name and Task Name is converted to lower case when one of these is edited ?
Creating a New Datasource or a New Scheduled Task keeps the formatting they way you put the name in.

"3Day-Price Report" will be changed to
"3day-price report" as an example.

This is a cosmetic issue but still somewhat annoying.

/Mats/

Comment 1 by project member [email protected], Jan 18, 2012
I'd have to check with Andy on this one--it's been a loooong time at this point since this came up when I was first working on the admin console, but for some reason (at that point anyway) internally the engine wanted everything lowercase.

I swear there's code in there for that does the name and the displayName so at least on the pages in the admin console it retains the case as you entered it but maybe I'm thinking of another area of the code.

Thanks for filing this--I'll look into it when I do the next round of updates.

Rework all the front-end (HTML/CFML) URLs to use cfbase or cgi.context_path to more easily set the base URL for front-end pages, images, etc.

If the user's login times out but the admin is still open in the browser, and they hit a link, take the user to the screen requested after they log in.

Sort scheduled tasks by start time, or look into using tablesorter, datatables, etc. to sort on all displayed columns

Add functionality to allow users to manage spooled and undeliverable mail from within the admin console. Currently all undelievered mail may be respooled but this does not allow user to view the mail messages before doing so.

Currently when errors occur the user is notified of the fields that caused the error (or the backend error that occurred), but the form data the user may have provided is not repopulated in the form.

Info is available via SessionCount('appname')

Currently if a datasource is modified the changes may not be picked up immediately since there may be open connections in the pool that will be reused, which depending on what is changed and the state of things when changes are made may necessitate an openbd restart for the changes to be picked up. Look into nuking all connections for the datasource in the pool if the datasource is updated.

In circumstances where you have Open bluedragon administrator running either under a folder not called bluedragon/administrator e.g. openbd/administrator or via a context path /bluedragon in situations where you want to use virtual hosts and have the bluedragon admin accessible then the references to bluedragon.api in path names will not work.

This can be fixed by changing the referneces to CFCs in Application.cfc to not have the bluedragon in front this makes it relative to the application.cfc which works in more circumstances.

I will produce a patch and upload

A