http://www.gossamer-threads.com/forum/ en-us gforum@gossamer-threads.com Tue, 21 May 2013 09:53:41 GMT Gossamer Forum by Gossamer Threads, Inc. http://www.rssboard.org/rss-specification http://static.gossamer-threads.com/forum/images/gforum-logo.png http://www.gossamer-threads.com/forum/ 50 50 http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BSyte%5D_DB_Man_Sql_V1.02_P314000/?page=unread#314000 Hi, Wrong forum ;) I've moved it for you. I'm afraid I don't use DBMan SQL very often, so don't know that much about it. Sorry I can't be more help. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 366c2251f2de56cccac799f01d756676 Mar 12, 2012, 4:41 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/DB_Man_Sql_V1.02_P313998/?page=unread#313998 HI anyone have the read me file for this version. I am having a few problems getting it up and running. Thanks for any time Norvin 3619d651c93c351a68992bf45cb7ba0c Mar 11, 2012, 10:59 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Starting_a_new_DBMan_SQL_session_from_another_application_-_without_Authenication_P311088/?page=unread#311088 Here is what I need help with. I have an authenicated user is another non DBMan SQL ( App1) web application/website with the same username as in DBMan SQL application (App2). That is the user already exists in the DBMan SQL user tables with all the details. What it really means that the user has the same username and password in both applications --- or the user tables are sync-ed. What I need that a user who is using App1 (Non DBMan SQL app) is authenticated & from there I want to invoke DBMan SQL App2. I need help with Perl code to start the App2 session without asking the user to login by giving Username and Password ---- a single signon. So in Perl lets say $username variable contains the username of the user, which exist in the user table of App2. I think if you look at db.cgi and home.pm files, what I am trying to do should be possible. This kind of feature might be required by many & may lead to many interesting possibilities like logging in already logged in Facebook users etc. The main subs in home.pm that we need is the sub called login(). I think login() can be leveraged to create a session and start the DBMan SQL app2 or some code from it can be taken & modified to achieve it. If you tell me - how to make a call to login() to start this session it will great help. What all information is required besides $username to create the session? if any other user details like passowrd is required it can bepulled from the user table. Here is the sub login() from home.pm. I know we need to call this login sub, but I can not figure out what information is being passed to it, that is required for starting the session. Another big question is --- do we need to do any other steps in preparation to setup any configuration details etc before calling login(). If anyone can help me with how to call this sub, and what all to pass. Any ideas or help in making this work will be greatly appreciated. If you want any further info or clarification, let me know. sub login { #--------------------------------------------------------------------------- # Login users, if login failure display login_failure else display home page # my $self = shift; if ( !$self->{cgi}->{Username} or !$self->{cgi}->{Password} ) { return $self->login_form($self->_language('AUTH_FAILURE')); } # Check that the user exists, and that the password is valid. $self->{user} = $self->_authenticate(); if ( !$self->{user} ) { $self->auth_logging ("$self->{cgi}->{Username} failed to logon") if ($self->{cfg}->{log_file}); return $self->login_form($self->_language('AUTH_FAILURE')); } return $self->login_form($self->_language('AUTH_FAIL_VAL')) if ($self->{user}->{Status} eq 'Not Validated'); my $msg = ($self->_check_pers())? $self->_language('MSG_LOGGED',$self->{cgi}->{db}): $self->_language('PER_FAILURE',$self->{cgi}->{db}); # Create session my $results = Dbsql::Authenticate::auth('create_session', {Table => $self->{cfg}->{'user_table_use'}, Username => $self->{user}->{Username}}) or return $self->error("Unable to create session!"); $self->{cgi}->{use_cookie} = $results->{use_cookie}; $self->{cgi}->{session_id} = $results->{session_id}; $self->auth_logging('log on ') if ( $self->{cfg}->{log_file} ); return ('home.html', { header => $self->_language('HEA_HOME'), msg => $msg }); } END_OF_SUB Thanks 8018acf8376c146ea2c73bb9586ba18c Oct 20, 2011, 1:52 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_what_is_column_%22pos%22%3F_P310699/?page=unread#310699 If its the same as GLinks/GForum, then its the "position" of the field. For example, pos = 1 would show up before pos = 2 in the admin forms (where they are auto generated) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 356f8f0bd38a283a97f90832dc124936 Jul 12, 2011, 10:23 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/options_for_display_P310689/?page=unread#310689 how do you use the following? in templates? # Options for display forms/views: # hide_timestamp => 1 # Do not display timestamp fields. # search_opts => 1 # Add search options boxes. # multiple => 1 # Prepend $multiple- to column names. # defaults => 1 # Use .def defaults. # values => {} # hash ref of values to use (overrides input) # table => 'string' # table properties, defaults to 0 border. # tr => 'string' # table row properties, defaults to none. # td => 'string' # table cell properties, defaults to just aligns. # extra_table => 0 # disable wrap form in extra table for looks. # col_font => 'string' # font to use for columns, defaults to $FONT. # val_font => 'string' # font to use for values, defaults to $FONT. # hide => [] # display fields as hidden tags. # view => [] # display fields as html with hidden tags as well. # skip => [] # don't display array of column names. 888074cc4968e322be6b2dcdc7d376dc Jun 30, 2011, 3:05 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/what_is_column_%22pos%22%3F_P310688/?page=unread#310688 in the routine that displays records, it refers to ordered_columns. i found the code that sorts the columns by the "pos" which i think i found in the .def file. can the pos in the def files be changed without affecting the data? Code: sub ordered_columns { # ----------------------------------------------------------- # $obj->ordered_columns; # ---------------------- # Returns the current table columns ordered # in function of the "pos" type of a given # column. # # The columns having no specified pos are # appended in lexicographical order at the # end of the result array. # my $self = shift; my @cols = (); my @append = (); my $cols = $self->{schema}->{cols}; foreach my $col (sort { $cols->{$a}->{pos} && $cols->{$b}->{pos} ? $cols->{$a}->{pos} <=> $cols->{$b}->{pos} : $cols->{$a}->{pos} && !$cols->{$b}->{pos} ? -1 : $cols->{$b}->{pos} && !$cols->{$a}->{pos} ? 1 : ($a cmp $b) } keys %{$cols}) { push @cols, $col; } return @cols; } 92384f054eefc4337990056c9d4baf2a Jun 30, 2011, 2:28 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Mysqlman_support_ft8_db_manipulating_%3F__P310212/?page=unread#310212 i wonder if DBMan SQL support tf8 coding? and would it be possible to view tf8 database directly through DBMan 's manipulating interface? how about linksql embeded MySQLMan ? Both DBMan SQL and MySQLMan support mysql 5x and mysql 6? Thanks 91ce9d67cef7cf458379053fb26cc1bd Jan 16, 2011, 6:48 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BDenise_%5D_Adding_new_tables_P310011/?page=unread#310011 i believe as long as you have all the templates for deaths in a template directory for deaths, like templates_death, you don't need to change anything in the templates at all. and if you don't need a customized appearance, you don't even need a separate template directory. the program should already know the name of the db (table) and it will pull the template directory from your setup file. 0e03d191a966d8d1c1eade69bf3b9372 Nov 19, 2010, 11:37 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BDenise_%5D_Adding_new_tables_P310003/?page=unread#310003 If I can just add a postscript to my post above: No one except me actually has access to add, amend, delete the data. People can come to site (www.manxbmd.com) and search for records - don't know if that makes a difference! 616b671fe51f52ed76c08aba6a791a8e Nov 18, 2010, 6:16 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Adding_new_tables_P310002/?page=unread#310002 Hello I have a three databases of births, marriages and death records. The births records are in a table uploaded onto my site, in use and working well. However I now have death records data I want to put up. I have created a table called deaths, assigned the template set and added some sample data. I thought that creating a copy of the search_form.html and search_results.html used for births and renaming them for use with deaths with these two lines changed from births to deaths would work: <input type=hidden name="db" value="births"> is now <input type=hidden name="db" value="deaths"> <input type=hidden name="do" value="search_results"> is now <input type=hidden name="do" value="deaths_search_results"> but it hasn't - when I go to the /cgi-bin/db.cgi?do=deaths_search_form it comes back with a standard GT template saying there is an error on births: invalid action. Looking at Setup - Paths & URLs - the default table is births, but if I change this then I'm not going to be able to use the births data am I? I've had a look at the help supplied and it implies that you can have more than one table. I'm not sure where I've gone wrong - can someone give me a clue? regards Denise 6499094eb6d64c3bbc79699e72300dd1 Nov 18, 2010, 6:13 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_mail_question_P309846/?page=unread#309846 Ah ok - yeah, they are pretty busy atm - took a while to get back to my email a little while back. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates a6ae233afe889838160b5522a3e36e28 Oct 1, 2010, 6:37 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BAndy%5D_mail_question_P309845/?page=unread#309845 yes, i emailed them sept 23 and haven't heard anything. only been a week though... 9c52b1ddcd62294c96fc87610c800b2a Oct 1, 2010, 6:32 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_mail_question_P309844/?page=unread#309844 Mmm, may be worth emailing GT about that - maybe they can shed a bit more light on the matter. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 631baf71d94f64934256b25803c03232 Oct 1, 2010, 1:36 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BAndy%5D_mail_question_P309843/?page=unread#309843 that makes sense. now do you know if anything in GT mail functions would require unique address? the only site i have that GT mail works (in dbman sql) is the one with secure certificate. all the others produce an error message although the emails are sent - in fact, the emails are sent twice. 892685c4883303b3e9bd606c0a3cfc6f Sep 30, 2010, 1:45 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_mail_question_P309839/?page=unread#309839 I think what they mean is the site is setup on a unique IP address (i.e that IP address is ONLY assigned to that domain) ALL sites have to have a static IP address (but you can share an IP with as many domains as you want, assuming they dont have a SSL certificate that needs a unique one), otherwise the nameservers around the world would never know where to find them Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates cbab8891404f44511ca075747e551514 Sep 30, 2010, 12:11 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BAndy%5D_mail_question_P309833/?page=unread#309833 well, i hadn't heard that term for hosting either, but my web host says one of my sites is on a static ip address because it has secure certificate. my other sites do not have secure certificates and have dynamic ip addresses. don't know if she was using incorrect terminology because i associate static/dynamic with dsl etc. 847ddece80112ebea943191455f8982f Sep 29, 2010, 12:16 PM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_mail_question_P309832/?page=unread#309832 Quote: requires static address instead of dynamic address of domain? What do you mean by "static" addresses? Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 58b7185f8cee8aa0ba073916f902846e Sep 29, 2010, 7:43 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5BAndy%5D_mail_question_P309831/?page=unread#309831 thank you. i keep getting error every time i test the email portion of dbman sql and cannot track it down. do you know if the email part of this script (or any other GT script) requires static address instead of dynamic address of domain? fe1547cf2daceb913e4f2249ca2e3ecb Sep 29, 2010, 5:53 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/Re%3A_%5Bdelicia%5D_mail_question_P309830/?page=unread#309830 I *think* it just tells people mail clients how the email was sent (i.e GT::Mail) ... some servers wont accept emails unless that paramater is passed in (the URL simply lets people goto GT's site, to check up on the software that emailed them - to make sure its not malicious :)) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 78ad262aacc8f49fb9b73e032c02bcc7 Sep 29, 2010, 3:21 AM http://www.gossamer-threads.com/forum/Products_C9/DBMan_SQL_C11/Discussion_F15/mail_question_P309812/?page=unread#309812 found this code in Mail.pm: Code: $self->{'X-Mailer'} = exists($opt->{'X-Mailer'}) ? delete ($opt->{'X-Mailer'}) : "GT::Mail $VERSION (Site: http://www.gossamer-threads.com; OS: $^O)"; what is it? why would code installed on my site contain reference to gossamer-threads.com ? e398ec002d5c7b3f74aba461136b5387 Sep 23, 2010, 2:52 PM