I am out of the office until 03/23/2012.
Backups for DBMS are Derek Jackson and Andrew Sharp, Web UID Parser is Mark
Stevens.
Note: This is an automated response to your message Re: [Catalyst] New
catalystframework.org sent on 3/21/12 3:17:33.
This is the only notification you will receive
./script/myapp_create.pl model DB2 DBIC::Schema MyApp::Schema
create=static dbi:DB2:dbname:server.com:port 'user' 'pass'
I have tried various permutations of this connection string and the error
I get most often is [IBM][CLI Driver] CLI0124E Invalid argument value.
SQLSTATE=HY009.
this tells
.
-- Edsger Dijkstra
[attachment signature.asc deleted by Kenneth S Mclane/Dubuque/IBM]
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive:
http://www.mail
From:
Cosimo Streppone cos...@streppone.it
To:
Kenneth S Mclane/Dubuque/IBM@IBMUS
Cc:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
03/28/2012 03:59 AM
Subject:
Re: [Catalyst] DB2 Connection string problem
On Tue, 27 Mar 2012 21:32:12 +0200, Kenneth S Mclane ksmcl...@us.ibm.com
From:
Kenneth S Mclane/Dubuque/IBM@IBMUS
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
03/28/2012 08:27 AM
Subject:
Re: [Catalyst] DB2 Connection string problem
From:
Cosimo Streppone cos...@streppone.it
To:
Kenneth S Mclane/Dubuque/IBM@IBMUS
Cc:
The elegant MVC web
On 28 Mar 2012, at 16:33, Kenneth S Mclane wrote:
Update, I was successful in creating a connection. For future reference
if anyone else is trying to accomplish this:
Can we fix some docs here, rather than leaving something in a vague
mailing list thread?
http://www-01.ibm.com/support
I am getting the following error: Caught exception in
dbms::Controller::AccountView-list Can't call method all on an
undefined value at
/tmp/catalyst/dbms/script/../lib/dbms/Controller/AccountView.pm line 7.
this is the referenced sub:
sub list : Local {
my ($self, $c) = @_;
the model? if so, try re-running
the create script so it can pick up the changes.
Also, to avoid fatal errors, you should attempt to load the model first,
and then send to the template a data structure only if it loads properly.
On Apr 4, 2012, at 7:28 AM, Kenneth S Mclane wrote:
I am getting
From:
Eden Cardim edencar...@gmail.com
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
04/04/2012 11:13 AM
Subject:
Re: [Catalyst] Error loading data from schema
Kenneth == Kenneth S Mclane ksmcl...@us.ibm.com writes:
Kenneth I am getting the following error: Caught
I am trying to duplicate a .aspx website. I have succeeded in getting a
page based on a db view. In the original site you can click on a row and a
details view appears at the bottom of the page. I don't know if this is
possible, but I have been trying to simply get a second page to come up
for some
reason, perhaps I needed to wrap it in double quotes. It wasn't
interpolating it.
and why -search and not -find if its one record... you need find
Kenneth good to know.
good luck
-hernan
On Thu, Apr 5, 2012 at 3:07 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
I am trying to duplicate
I do not understand this error at all. It is tacking the DB user name onto
the model name. Any hints why this is happening?
This is my list sub:
sub list :Local {
my ($self, $c) = @_;
$c-stash(accounts = $c-model('ORANGES::AccountView')-all);
$c-stash(template =
OK, I still can't get -all to work, but this:
$c-stash(accounts = [
$c-model('ORANGES::AccountView')-find({account_name = 'GHODB2'}) ]);
returns one row, as it should, but there is no data showing in my page.
Obviously the query is successful, so the data must exist or it could not
match, but
: [Catalyst] No data showing
It looks to me like you're returning a list.
On 4/27/2012 10:07 AM, Kenneth S Mclane wrote:
OK, I still can't get -all to work, but this:
$c-stash(accounts = [
$c-model('ORANGES::AccountView')-find({account_name = 'GHODB2'}) ]);
returns one row, as it should
it account (singular) and stick the row
directly in it, instead of a list? That way, in your template you can
access it just by [% account %] (if usint TT), instead of having to
traverse the list (with for, next, etc.) or index the first element...
Regards
J.
El 27/04/12 16:07, Kenneth S
again.
From:
Will Crawford billcrawford1...@gmail.com
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
04/27/2012 09:55 AM
Subject:
Re: [Catalyst] No data showing
On 27 April 2012 15:50, Kenneth S Mclane ksmcl...@us.ibm.com wrote:
This was a test to make sure I
S Mclane wrote:
[% accounts.department_id %]
___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive:
http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http
ok, I used bits from all over and have this sub now:
sub list :Local {
my ($self, $c) = @_;
my $page = 1;
my $rs = $c-model('ORANGES::AccountView')-search_rs(undef, {
order_by = 'account_code',
rows = 15,
page = $page,
/2012 02:49 PM
Subject:
Re: [Catalyst] Paging problem
On Fri, 2012-04-27 at 14:22 -0500, Kenneth S Mclane wrote:
ok, I used bits from all over and have this sub now:
[...]
my $page = 1;
[...]
when clicking any link the data doesn't change.
That seems reasonable. You need to change
@lists.scsys.co.uk
Date:
04/27/2012 03:17 PM
Subject:
Re: [Catalyst] Paging problem
On 04/28/12 00:05, Kenneth S Mclane wrote:
ok, I tried this:
my ($self, $c, $page) = @_;
and my template code is issueing uri's like this:
http://localhost:3000/accountview/list?page=4
Do I need to remove this line
:
04/27/2012 03:20 PM
Subject:
Re: [Catalyst] Paging problem
Alex Povolotsky wrote:
On 04/28/12 00:05, Kenneth S Mclane wrote:
ok, I tried this:
my ($self, $c, $page) = @_;
and my template code is issueing uri's like this:
http://localhost:3000/accountview/list?page=4
http://localhost
I have this statement in each result file for ny DB. I am currently
accessing a other than default schema on a DB2 server, which has no way to
set a different schema as default for a user.
__PACKAGE__-table(ACCOUNT_DETAILS);
To get my data out of the DB, I have been forced to change this to
I am having a problem with my code and I cannot figure out why it is doing
what it is doing. I have this sub:
sub list :Local {
my ($self, $c, $page) = @_;
$page = $c-req-param('page') || 1;
my $rs = $c-model('ORANGES::Account')-search({}, {
join =
Hitchcock
From:
Will Crawford billcrawford1...@gmail.com
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
05/08/2012 10:32 AM
Subject:
Re: [Catalyst] Getting hashref instead of value
On 8 May 2012 16:13, Kenneth S Mclane ksmcl...@us.ibm.com wrote:
I am having a problem
', and that
is what you are referencing currently in your template.
On 5/8/2012 11:13 AM, Kenneth S Mclane wrote:
I am having a problem with my code and I cannot figure out why it is
doing what it is doing. I have this sub:
sub list :Local {
my ($self, $c, $page) = @_;
$page = $c-req-param('page
field.
From:
Alexander Hartmaier alexander.hartma...@t-systems.at
To:
catalyst@lists.scsys.co.uk
Date:
05/08/2012 10:35 AM
Subject:
Re: [Catalyst] Getting hashref instead of value
Am 2012-05-08 17:25, schrieb Ari Constancio:
On Tue, May 8, 2012 at 4:13 PM, Kenneth S Mclane ksmcl...@us.ibm.com
framework catalyst@lists.scsys.co.uk
Date:
05/08/2012 10:49 AM
Subject:
Re: [Catalyst] Getting hashref instead of value
On 8 May 2012 16:44, Kenneth S Mclane ksmcl...@us.ibm.com wrote:
The Catalyst helper script created most of the relationships. I added a
few at the bottom of the Account.pm
alexander.hartma...@t-systems.at
To:
catalyst@lists.scsys.co.uk
Date:
05/08/2012 11:07 AM
Subject:
Re: [Catalyst] Getting hashref instead of value
Am 2012-05-08 17:46, schrieb Kenneth S Mclane:
In checking through docs on line I find that prefetch is a better way to
go so I have changed ny sub thusly
11:07 AM
Subject:
Re: [Catalyst] Getting hashref instead of value
Am 2012-05-08 17:46, schrieb Kenneth S Mclane:
In checking through docs on line I find that prefetch is a better way to
go so I have changed ny sub thusly:
sub list :Local {
my ($self, $c, $page) = @_;
$page
I am trying to port this query to Catalyst:
SELECT
s.server_id,
a.account_code,
s.server_name,
s.server_type,
s.os_name,
(select count(*) from server ss, subsystem sb
where ss.server_id =
@lists.scsys.co.uk
Date:
05/10/2012 09:29 AM
Subject:
Re: [Catalyst] Query not working
On 10 May 2012, at 15:17, Kenneth S Mclane wrote:
I am trying to port this query to Catalyst:
You mean DBIx::Class - Catalyst is totally database agnositc (no database
is even required)
Whilst a lot of people here
I am continuing on my journey to duplicate a web app for administering a
db. I have all my pages up and running, as well as search functionality. I
decided to attack authentication next. I am using a php pages from a
different web app to get the settings for our LDAP server.
//Connect to ldap
From:
Tomas Doran bobtf...@bobtfish.net
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
05/21/2012 09:47 AM
Subject:
Re: [Catalyst] LDAP question
On 21 May 2012, at 15:20, Kenneth S Mclane wrote:
I am continuing on my journey to duplicate a web app for administering a
db
10:57 AM
Subject:
Re: [Catalyst] LDAP question
On 21 May 2012, at 16:42, Robert Wohlfarth wrote:
On Mon, May 21, 2012 at 9:20 AM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
They are apparently doing the initial bind with the credentials
submitted by the user, I am getting invalid
I must apologize for my companies insistence on using Lotus Notes as a
mail client, they are kind of stuck on it since they made it.___
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable
settings are really broken!
You are not quoting anyone else's email, but just changing it's font -
which means that anyone using a text mail client without fonts can't see
the quoting..
On 21 May 2012, at 16:18, Kenneth S Mclane wrote:
You can turn on LDAP debugging and get a print out of what
Ok, found it. Thanks, I hate this program so much I give up shortly after
trying to figure it out. ;-)
Len Jaffe lenja...@jaffesystems.com wrote on 05/21/2012 11:40:06 AM:
On Mon, May 21, 2012 at 12:05 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
I must apologize for my companies
On May 21, 2012, at 12:02 PM, Kenneth S Mclane wrote:
I have no control over the LDAP server, How would I change things
so the submitted username and password would be inserted as the
credentials to be used as the initial bind?
You use that from the client.
Below is a snippet from
they are
encrypting the password in? It defaults to SHA-1, but I do not know if
that is correct.
Kenneth S Mclane/Dubuque/IBM@IBMUS wrote on 05/21/2012 03:34:48 PM:
From:
Kenneth S Mclane/Dubuque/IBM@IBMUS
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
05/21/2012 03:36 PM
, at 5:12 PM, Kenneth S Mclane wrote:
I'm getting closer. I'm wondering if I need to find out what form
they are encrypting the password in? It defaults to SHA-1, but I do
not know if that is correct.
You do not need that because you're not dealing with the hashes
directly. By asking
question
On 21 May 2012, at 22:24, Kenneth S Mclane wrote:
So I should leave it as self_check?
No.
You set it as plain / don't set it at all, as the password needs to
be passed through Catalyst un-mangled - as the auth is done by
logging in _as the user_ (and therefore
I have succeeded in getting my LDAP Auth working. I setup three tables in
the DB I am working with for Users, Roles, and Users_to_Roles. I setup
some rudimentary role checking, but the Authorization module is
complaining about needing to configure rolebasedn. I can't use the LDAP
server for
I am having difficulty in getting my user to authenticate against the
second realm. After successfully authenticating against the ldap server, I
want to authenticate against the dbic realm as well as that is where the
roles are stored. It seems to ignore a second call to $c-.authenticate.
I
catalyst@lists.scsys.co.uk
Date:
05/23/2012 11:07 AM
Subject:
Re: [Catalyst] Role problems, Still
On 23 May 2012, at 16:37, Kenneth S Mclane wrote:
I am having difficulty in getting my user to authenticate against
the second realm. After successfully authenticating against
Doran bobtf...@bobtfish.net wrote on 05/24/2012 10:06:33 AM:
From:
Tomas Doran bobtf...@bobtfish.net
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
05/24/2012 10:11 AM
Subject:
Re: [Catalyst] Role problems, Still
On 24 May 2012, at 13:45, Kenneth S
I have my authentication working through the company LDAP server. I am
attempting to check for the existence of the user in a sqlite table and
add them and their role if they are not found. I do this during the login:
if ($username $password) {
# Attempt to log the user in
if
= $username });
$user-create_related('user_roles', {role='1'});
On Wed, May 30, 2012 at 3:09 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
I have my authentication working through the company LDAP server. I am
attempting to check for the existence of the user in a sqlite table and
add them
I have an LDAP server authenticating my users. The look up returns a ton
of fields in a hash. My questions are as follows:
1. What happens to this data/information? Is it stored in the $c-user
object?
2. If it is, how do I access it?
3. Is there a simple way to look at what is stored in the
and session questions
On 31 May 2012, at 14:00, Kenneth S Mclane wrote:
I have an LDAP server authenticating my users. The look up returns
a ton of fields in a hash. My questions are as follows:
1. What happens to this data/information? Is it stored in the
$c-user object?
Yes
I am getting this error Deep recursion on subroutine Storable::nfreeze
at /usr/local/share/perl5/DBIx/Class/ResultSourceHandle.pm line 95. in my
debug output and then the connection is reset after the authentication
while getting the user role with this sql:
SELECT role.role, user.id,
Ok, I found that the recursion error is happening when trying to store the
role in the session.
my $roles = $c-model('authdb::User')-find( { 'username' = $username },
{
prefetch = 'roles',
columns = 'roles.role',
, 2012 at 10:38 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
Ok, I found that the recursion error is happening when trying to
store the role in the session.
my $roles = $c-model('authdb::User')-find( { 'username' = $username
}, {
prefetch = 'roles
Can someone tell me why this:
my $rs1 = $c-model('ORANGES::File')-search({'report_id' = $rptcode}, {
rows = 1,
page = $page,
});
Results in the following SQL?
SELECT COUNT( * ) FROM HCDB_TEST.FILE me WHERE ( report_id = ? ): '541861'
When it used to
On Fri, Jun 1, 2012 at 6:55 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
Can someone tell me why this:
my $rs1 = $c-model('ORANGES::File')-search({'report_id' =
$rptcode}, {
rows = 1,
page = $page,
});
Results in the following SQL?
SELECT
On Fri, Jun 1, 2012 at 8:10 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
I did use .next in my template, but this code should (and did) return
4
rows. I am also using a pager on the resultset, which still shows 4
pages
when I display the template, however I get no column data, just the
count
I am trying to get the value from a model call into a variable so I can
use it for creating a DB record. I have tried multiple ways and cannot get
the value to return. Here is my current attempt:
my $dept = $c-model('ORANGES::Departments')-search_rs({'department_code'
= $departmentcode}, {
question
anyways, what is the output of ...
if ( $dept ) {
warn REF: . ref $dept . DEPT_ID: . $dept-department_id;
} else {
warn No dept found;
}
... after your query?
On 13 June 2012 22:54, Kenneth S Mclane ksmcl...@us.ibm.com wrote:
I am trying to get the value from a model
I need to export my data to an Excel file on demand. I have been looking
around and it looks like DBIx::Dumper should do it, but the docs are a bit
sparse. Has anyone done this with it or something else? I need to have a
link the user can click on which will dump the current recordset in the
:29 PM
Subject:
Re: [Catalyst] Data export question
On Mon, Jul 2, 2012 at 1:11 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote:
I need to export my data to an Excel file on demand. I have been
looking around and it looks like DBIx::Dumper should do it, but the
docs are a bit sparse
/2012 01:54:28 PM:
From:
Len Jaffe lenja...@jaffesystems.com
To:
The elegant MVC web framework catalyst@lists.scsys.co.uk
Date:
07/02/2012 01:56 PM
Subject:
Re: [Catalyst] Data export question
On Mon, Jul 2, 2012 at 1:45 PM, Kenneth S Mclane ksmcl...@us.ibm.com
wrote
60 matches
Mail list logo
