openupload-devel Mailing List for Open Upload (Page 23)
Status: Beta
Brought to you by:
tsdogs
Menu
▾
▴
openupload-devel — Development and general discussion
You can subscribe to this list here.
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(11) |
Dec
(11) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2009 |
Jan
(11) |
Feb
(9) |
Mar
(1) |
Apr
(32) |
May
(31) |
Jun
(6) |
Jul
(9) |
Aug
(108) |
Sep
(27) |
Oct
|
Nov
(9) |
Dec
(9) |
| 2010 |
Jan
(16) |
Feb
(38) |
Mar
(24) |
Apr
(2) |
May
(15) |
Jun
(2) |
Jul
(3) |
Aug
(4) |
Sep
(12) |
Oct
(21) |
Nov
(4) |
Dec
(17) |
| 2011 |
Jan
(7) |
Feb
(6) |
Mar
(26) |
Apr
(35) |
May
(6) |
Jun
(7) |
Jul
(1) |
Aug
(12) |
Sep
(5) |
Oct
(17) |
Nov
(6) |
Dec
(7) |
| 2012 |
Jan
(28) |
Feb
(17) |
Mar
(18) |
Apr
(2) |
May
(6) |
Jun
(15) |
Jul
(3) |
Aug
(3) |
Sep
(13) |
Oct
|
Nov
(6) |
Dec
(6) |
| 2013 |
Jan
(13) |
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
(3) |
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2014 |
Jan
(2) |
Feb
|
Mar
(2) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(4) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Alessandro B. <ts...@br...> - 2009-08-18 21:28:56
|
actually there is no source for it, you can take a .po from one of the translations already done, they also contain the english wording. or you can grab them from here: http://www.openupload.org/openupload.po http://www.openupload.org/template.po I suggest u to use gettext tools (poedit, lokalize, or vi ) and then convert them to php with the locale/tools/po2php.php Hope this helps. Alessandro Weir, Jason ha scritto: > Ok - I must be slow today but for the life of me I cannot find the > config file to change "wording" > > I see the translation files where wording is translated but where is the > english file that I can change those configurable items.. > > Thanks, > -J > > > _____________________________________________________________________________________________ > > Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 20:23:22
|
No big deal - I just went through the setup again... Everything seems to be working great... Now to let my users break it... Thanks, -J -----Original Message----- From: Weir, Jason [mailto:jas...@nh...] Sent: Tuesday, August 18, 2009 4:06 PM To: OpenUpload Delvel and General talk Subject: [openupload-devel] Group Rights During the initial install I selected Public as the pre-defined rights.. After testing I want to use the Restricted pre-defined rights any way I can do this easily are they listed somewhere in the docs? Thanks, -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 20:06:04
|
During the initial install I selected Public as the pre-defined rights.. After testing I want to use the Restricted pre-defined rights any way I can do this easily are they listed somewhere in the docs? Thanks, -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 19:54:47
|
I added the following line to ldap.inc.php right after line 42 in the authenticate function $password = addslashes($password, '!\',+"\\<>;*'); It fixed my problem - hope it helps someone else. -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 18:58:07
|
Ok - I must be slow today but for the life of me I cannot find the config file to change "wording" I see the translation files where wording is translated but where is the english file that I can change those configurable items.. Thanks, -J _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 18:14:01
|
After the LDAP config was correct - this works as advertised as well.. Thanks! -J -----Original Message----- From: Alessandro Briosi [mailto:ts...@br...] Sent: Tuesday, August 18, 2009 12:04 PM To: OpenUpload Delvel and General talk Subject: Re: [openupload-devel] From Email Address This should already be like that. OpenUpload sends an e-mail to the owner with the main e-mail address. (if requested) Then it sends an e-mail (if requested) to the destination e-mail specified with the sender e-mail which has uploaded the file. With LDAP if the e-mail field is empty, it should ask for the e-mail address, otherwise it uses the one that was given by the AD User lookup info. Alessandro Weir, Jason ha scritto: > Sorry to have a bunch of these in a row - but I've got them on the > brain.. > > Because I'm doing LDAP auth - I'd like outgoing emails to be addressed > from the user that uploaded them. That way replies go to the correct > person.. > > Thanks again... > > -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 18:13:27
|
Re-running setup and having the LDAP config correct worked perfectly. For reference here is my LADP config for Win2k3 AD $CONFIG['ldap']['host'] = '*********'; $CONFIG['ldap']['type'] = 'AD'; $CONFIG['ldap']['user'] = '*********'; $CONFIG['ldap']['password'] = '*********'; $CONFIG['ldap']['domain'] = 'nhrs.org'; $CONFIG['ldap']['basedn'] = 'dc=nhrs,dc=org'; $CONFIG['ldap']['userdn'] = 'dc=nhrs,dc=org'; $CONFIG['ldap']['userclass']='user'; $CONFIG['ldap']['uid']='samaccountname'; $CONFIG['ldap']['userfields'] = array ( 'cn' => 'login', 'name' => 'name', 'memberof' => 'group_id', 'mail' => 'email'); $CONFIG['ldap']['groupdn'] = 'dc=nhrs,dc=org'; $CONFIG['ldap']['groupclass']='group'; $CONFIG['ldap']['gid']='distinguishedname'; $CONFIG['ldap']['groupfields'] = array ( 'cn' => 'name', 'name' => 'description' ); The password cache issue went away - not sure what was going on there.. I'm still having the password issue - I'll poke around and see if I can escape the password.. Thanks! -Jason -----Original Message----- From: Alessandro Briosi [mailto:ts...@br...] Sent: Tuesday, August 18, 2009 11:59 AM To: ope...@li... Subject: Re: [openupload-devel] LDAP Password\Group Issues Hi, I defenatly need to write some documentation on this one :) Weir, Jason ha scritto: > I've got OpenUpload installed on a Debian machine authenticating to > Win2K3 AD via LDAP - I'm seeing a couple issues. > > 1. Does OpenUpload cache the passwords - after I did a password > change I could no longer log in unless I used the old password. No, it only authenticates the user against AD at the login and then checks for the user information with the user specified in the configuration (the user remains authenticated until the logout or session expires) OpenUpload uses the standard ldap functions to authenticate, so probably it must be something with AD or Linux caching... I suppose you change the password with AD :) > 2. Seems to be an issue with long\complicated passwords, my password > contains spaces and special characters and always fails at login, if I > change it to "simple" I log in just fine. Any ideas? Hmm, no idea. It shouldn't as far as Open Upload gets the password, it tries to authenticate against AD, and if it succeeds it looks up user info and groups using the lookup user configured in the config.inc.php Maybe the password needs to be escaped in the code before authenticating. I'll check if this is OpenUpload fault or something else. > 3. The read-me was unclear how I setup user and admin groups in AD.. > I've got 2 groups "OpenUpload Admins" and "OpenUpload Users" created > and populated in AD - how do I configure OpenUpload to reference those > groups? > Here is the best way to setup Open Upload with LDAP/AD. 1. Run the setup and change 'admins' and 'registered' group names to the ones corresponding to the ones of your AD. (Using the default authentication with users in the database). This will populate the ACL with the correct group names in the database. i.e. admins => "OpenUpload Admins" and registered => "OpenUpload Users" 2. Once the setup is as you wish, change the config.inc.php (lookup the config.inc.php.example) and copy over the AD part, adapting the configuration. (which I suppose you already did) 3. Change the authentication module change the authentication method in the config.inc.php to ldap 4. Probably you would need to change the 'cn' to 'samaccountname' with active directory in user and group fields. 5. Login with an administrator, and then login with a User, to verify that eveything is working Alessandro ------------------------------------------------------------------------ ------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Openupload-devel mailing list Ope...@li... https://lists.sourceforge.net/lists/listinfo/openupload-devel ________________________________________________________________________ _____________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 16:38:45
|
Andy, you mean change the configuration via the admin page? Users and Groups should be disabled when using AD/LDAP... Alessandro Weir, Jason ha scritto: > Good tip - I definitely would have screwed that one up.. > > -J > > -----Original Message----- > From: Andy Hester [mailto:and...@eu...] > Sent: Tuesday, August 18, 2009 12:04 PM > To: OpenUpload Delvel and General talk > Subject: Re: [openupload-devel] LDAP Password\Group Issues > > > Alessandro Briosi wrote: >> Hi, >> I defenatly need to write some documentation on this one :) >> >> >> > Also, once you've gotten it working, don't click on users or groups in > the Admin page... It will overwrite parts of the config. > > -Andy > > > _____________________________________________________________________________________________ > > Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 16:19:02
|
Good tip - I definitely would have screwed that one up.. -J -----Original Message----- From: Andy Hester [mailto:and...@eu...] Sent: Tuesday, August 18, 2009 12:04 PM To: OpenUpload Delvel and General talk Subject: Re: [openupload-devel] LDAP Password\Group Issues Alessandro Briosi wrote: > Hi, > I defenatly need to write some documentation on this one :) > > > Also, once you've gotten it working, don't click on users or groups in the Admin page... It will overwrite parts of the config. -Andy _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Andy H. <and...@eu...> - 2009-08-18 16:16:44
|
Alessandro Briosi wrote: > Hi, > I defenatly need to write some documentation on this one :) > > > Also, once you've gotten it working, don't click on users or groups in the Admin page... It will overwrite parts of the config. -Andy |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 16:16:19
|
I did change my password via AD - I'll do some more testing... As for the complicated password - no doubt there are some characters in my password that would need to be escaped.. I run into this issues all the time with PHP and Perl... I'll go back through your directions to get the LDAP groups setup again.. Thanks, -J -----Original Message----- From: Alessandro Briosi [mailto:ts...@br...] Sent: Tuesday, August 18, 2009 11:59 AM To: ope...@li... Subject: Re: [openupload-devel] LDAP Password\Group Issues Hi, I defenatly need to write some documentation on this one :) Weir, Jason ha scritto: > I've got OpenUpload installed on a Debian machine authenticating to > Win2K3 AD via LDAP - I'm seeing a couple issues. > > 1. Does OpenUpload cache the passwords - after I did a password > change I could no longer log in unless I used the old password. No, it only authenticates the user against AD at the login and then checks for the user information with the user specified in the configuration (the user remains authenticated until the logout or session expires) OpenUpload uses the standard ldap functions to authenticate, so probably it must be something with AD or Linux caching... I suppose you change the password with AD :) > 2. Seems to be an issue with long\complicated passwords, my password > contains spaces and special characters and always fails at login, if I > change it to "simple" I log in just fine. Any ideas? Hmm, no idea. It shouldn't as far as Open Upload gets the password, it tries to authenticate against AD, and if it succeeds it looks up user info and groups using the lookup user configured in the config.inc.php Maybe the password needs to be escaped in the code before authenticating. I'll check if this is OpenUpload fault or something else. > 3. The read-me was unclear how I setup user and admin groups in AD.. > I've got 2 groups "OpenUpload Admins" and "OpenUpload Users" created > and populated in AD - how do I configure OpenUpload to reference those > groups? > Here is the best way to setup Open Upload with LDAP/AD. 1. Run the setup and change 'admins' and 'registered' group names to the ones corresponding to the ones of your AD. (Using the default authentication with users in the database). This will populate the ACL with the correct group names in the database. i.e. admins => "OpenUpload Admins" and registered => "OpenUpload Users" 2. Once the setup is as you wish, change the config.inc.php (lookup the config.inc.php.example) and copy over the AD part, adapting the configuration. (which I suppose you already did) 3. Change the authentication module change the authentication method in the config.inc.php to ldap 4. Probably you would need to change the 'cn' to 'samaccountname' with active directory in user and group fields. 5. Login with an administrator, and then login with a User, to verify that eveything is working Alessandro ------------------------------------------------------------------------ ------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Openupload-devel mailing list Ope...@li... https://lists.sourceforge.net/lists/listinfo/openupload-devel ________________________________________________________________________ _____________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 16:05:34
|
OK - let me check the LDAP\AD settings.. -J -----Original Message----- From: Alessandro Briosi [mailto:ts...@br...] Sent: Tuesday, August 18, 2009 12:04 PM To: OpenUpload Delvel and General talk Subject: Re: [openupload-devel] From Email Address This should already be like that. OpenUpload sends an e-mail to the owner with the main e-mail address. (if requested) Then it sends an e-mail (if requested) to the destination e-mail specified with the sender e-mail which has uploaded the file. With LDAP if the e-mail field is empty, it should ask for the e-mail address, otherwise it uses the one that was given by the AD User lookup info. Alessandro Weir, Jason ha scritto: > Sorry to have a bunch of these in a row - but I've got them on the > brain.. > > Because I'm doing LDAP auth - I'd like outgoing emails to be addressed > from the user that uploaded them. That way replies go to the correct > person.. > > Thanks again... > > -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 16:03:47
|
This should already be like that. OpenUpload sends an e-mail to the owner with the main e-mail address. (if requested) Then it sends an e-mail (if requested) to the destination e-mail specified with the sender e-mail which has uploaded the file. With LDAP if the e-mail field is empty, it should ask for the e-mail address, otherwise it uses the one that was given by the AD User lookup info. Alessandro Weir, Jason ha scritto: > Sorry to have a bunch of these in a row - but I've got them on the > brain.. > > Because I'm doing LDAP auth - I'd like outgoing emails to be addressed > from the user that uploaded them. That way replies go to the correct > person.. > > Thanks again... > > -Jason > > > _____________________________________________________________________________________________ > > Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 16:00:15
|
Its in the todo list :) Weir, Jason ha scritto: > Just a feature request - when uploading a file be able to give an > automatic delete date option and a automatic delete after x number of > downloads options. > > Thanks! > -Jason > > > _____________________________________________________________________________________________ > > Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 15:59:45
|
Hi, I defenatly need to write some documentation on this one :) Weir, Jason ha scritto: > I've got OpenUpload installed on a Debian machine authenticating to > Win2K3 AD via LDAP - I'm seeing a couple issues. > > 1. Does OpenUpload cache the passwords - after I did a password change > I could no longer log in unless I used the old password. No, it only authenticates the user against AD at the login and then checks for the user information with the user specified in the configuration (the user remains authenticated until the logout or session expires) OpenUpload uses the standard ldap functions to authenticate, so probably it must be something with AD or Linux caching... I suppose you change the password with AD :) > 2. Seems to be an issue with long\complicated passwords, my password > contains spaces and special characters and always fails at login, if I > change it to "simple" I log in just fine. Any ideas? Hmm, no idea. It shouldn't as far as Open Upload gets the password, it tries to authenticate against AD, and if it succeeds it looks up user info and groups using the lookup user configured in the config.inc.php Maybe the password needs to be escaped in the code before authenticating. I'll check if this is OpenUpload fault or something else. > 3. The read-me was unclear how I setup user and admin groups in AD.. > I've got 2 groups "OpenUpload Admins" and "OpenUpload Users" created and > populated in AD - how do I configure OpenUpload to reference those > groups? > Here is the best way to setup Open Upload with LDAP/AD. 1. Run the setup and change 'admins' and 'registered' group names to the ones corresponding to the ones of your AD. (Using the default authentication with users in the database). This will populate the ACL with the correct group names in the database. i.e. admins => "OpenUpload Admins" and registered => "OpenUpload Users" 2. Once the setup is as you wish, change the config.inc.php (lookup the config.inc.php.example) and copy over the AD part, adapting the configuration. (which I suppose you already did) 3. Change the authentication module change the authentication method in the config.inc.php to ldap 4. Probably you would need to change the 'cn' to 'samaccountname' with active directory in user and group fields. 5. Login with an administrator, and then login with a User, to verify that eveything is working Alessandro |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 15:52:29
|
Sorry to have a bunch of these in a row - but I've got them on the brain.. Because I'm doing LDAP auth - I'd like outgoing emails to be addressed from the user that uploaded them. That way replies go to the correct person.. Thanks again... -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Weir, J. <jas...@nh...> - 2009-08-18 15:50:32
|
Just a feature request - when uploading a file be able to give an automatic delete date option and a automatic delete after x number of downloads options. Thanks! -Jason _____________________________________________________________________________________________ Please visit www.nhrs.org to subscribe to NHRS email announcements and updates. |
|
From: Alessandro B. <ts...@br...> - 2009-08-18 07:25:55
|
Leonardo F. Cardoso ha scritto: > Alessandro, > > nice idea. What's the best way to contribute with my mssql module and > translation? > If you can generate a patch that would be nice, of course the mssql code and the translation can also be files... > I think I've corrected the TXTDB select folder bug in setup scripts > (but file copy is still necessary). Do you want this little code too? > sure. > Sds > Leonardo > > ----------------------------------------- > Leonardo F. Cardoso > leonardo.f.cardoso "at" gmail.com <http://gmail.com> > leofcar "at" ig.com.br <http://ig.com.br> (Alternativo) > MSN: lfc...@ho... <mailto:lfc...@ho...> > ----------------------------------------- > > > On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi <ts...@br... > <mailto:ts...@br...>> wrote: > > Well, that was my first thought, but reading the documentation, PDO > simply > abstracts the _query, _connect, etc, but not the SQL syntax which is not > always the same, so probably extending the current classes (mysql, > pgsql, > mssql) to support PDO (maybe even in the base class) would do the trick, > and have a config option to decide which to use PDO or native methods. > > Something like: > > class_method_query($sql) { > > if ($this->config['use_pdo']) { > $this->PDO->query($sql); > <fetch the rows> > } else { > $result = native_query($sql); > <fetch the rows> > } > } > > class_method_read() { > > <prepare the sql statement according to the database syntax> > $this->class_method_query($sql); > } > > _connect would call the different methods (PDO or native), and so on. > > Alessandro > > On Mon, 17 Aug 2009 16:25:50 -0300, "Leonardo F. Cardoso" > <leo...@gm... <mailto:leo...@gm...>> > wrote: > > Hi Alessandro, > > > > you mean code a DB class with PDO methods inside (insert, read, > readex > > etc) > > ? > > > > Sds > > Leonardo > > > > On Mon, Aug 17, 2009 at 14:58, Alessandro Briosi > <ts...@br... <mailto:ts...@br...>> > > wrote: > > > >> Hi again, > >> I have checked PDO documentation and it souldn't be that dificult to > >> implement a PDO version of the modules. Though PDO does not > provide SQL > >> statement abstraction, so it would be probably best to extend > the sql > >> module to use one or the other functions, and not as I sateted > before > >> creating a general PDO module. > >> > >> Wrapping the connect, query and exec PDO methods into a couple of > >> functions and using PDO or not, depending on a config options > should be > >> trivial imho. > >> > >> Alessandro > >> > >> Alessandro Briosi ha scritto: > >> > hi, > >> > > >> > Leonardo F. Cardoso ha scritto: > >> >> Hi there, > >> >> > >> >> thanks for the reply, Alessandro. > >> >> > >> >> I'm working in Brazilian Portuguese translation. Will send > it to you > >> soon. > >> >> > >> > great > >> > > >> >> I could code SQL Server port for the 0.4 version. It works!! :-) > >> >> > >> > cool ;-P > >> > > >> >> By now, I'm interested in run OpenUpload inside Quercus. > Quercus is > a > >> >> Java PHP implementation. Unfortunatelly, Quercus doesn't > support SQL > >> >> Server with normal mssql PHP package, the only support is > with PDO > >> >> implementation. In the new database scheme, will be support > for PDO? > >> >> > >> > > >> > Well, I have been thinking about it, but am not too sure if I > can use > >> > it. > >> > One of the features is txtdb, which (Afair) is not supported > by PDO, > so > >> > probably will stick to project modules for now, which might also > evolve > >> > into something simpler (some kind of little wrapper). > >> > Though I suppose you could also code a PDO version which would > support > >> > multiple backends, but have not much experience with it. > >> > If needed I might have a look at it (as I'm also interested to > do some > >> > PDO research) > >> > > >> > Let me know. > >> > Alessandro > >> > > >> > > >> > > >> > ------------------------------------------------------------------------------ > >> > Let Crystal Reports handle the reporting - Free Crystal > Reports 2008 > >> 30-Day > >> > trial. Simplify your report design, integration and deployment > - and > >> focus on > >> > what you do best, core application coding. Discover what's new > with > >> > Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> > _______________________________________________ > >> > Openupload-devel mailing list > >> > Ope...@li... > <mailto:Ope...@li...> > >> > https://lists.sourceforge.net/lists/listinfo/openupload-devel > >> > >> > >> > ------------------------------------------------------------------------------ > >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > >> 30-Day > >> trial. Simplify your report design, integration and deployment - and > >> focus > >> on > >> what you do best, core application coding. Discover what's new with > >> Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> _______________________________________________ > >> Openupload-devel mailing list > >> Ope...@li... > <mailto:Ope...@li...> > >> https://lists.sourceforge.net/lists/listinfo/openupload-devel > >> > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > trial. Simplify your report design, integration and deployment - and > focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > <mailto:Ope...@li...> > https://lists.sourceforge.net/lists/listinfo/openupload-devel > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > > ------------------------------------------------------------------------ > > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-18 01:01:56
|
Alessandro, nice idea. What's the best way to contribute with my mssql module and translation? I think I've corrected the TXTDB select folder bug in setup scripts (but file copy is still necessary). Do you want this little code too? Sds Leonardo ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- On Mon, Aug 17, 2009 at 19:18, Alessandro Briosi <ts...@br...> wrote: > Well, that was my first thought, but reading the documentation, PDO simply > abstracts the _query, _connect, etc, but not the SQL syntax which is not > always the same, so probably extending the current classes (mysql, pgsql, > mssql) to support PDO (maybe even in the base class) would do the trick, > and have a config option to decide which to use PDO or native methods. > > Something like: > > class_method_query($sql) { > > if ($this->config['use_pdo']) { > $this->PDO->query($sql); > <fetch the rows> > } else { > $result = native_query($sql); > <fetch the rows> > } > } > > class_method_read() { > > <prepare the sql statement according to the database syntax> > $this->class_method_query($sql); > } > > _connect would call the different methods (PDO or native), and so on. > > Alessandro > > On Mon, 17 Aug 2009 16:25:50 -0300, "Leonardo F. Cardoso" > <leo...@gm...> wrote: > > Hi Alessandro, > > > > you mean code a DB class with PDO methods inside (insert, read, readex > > etc) > > ? > > > > Sds > > Leonardo > > > > On Mon, Aug 17, 2009 at 14:58, Alessandro Briosi <ts...@br...> > > wrote: > > > >> Hi again, > >> I have checked PDO documentation and it souldn't be that dificult to > >> implement a PDO version of the modules. Though PDO does not provide SQL > >> statement abstraction, so it would be probably best to extend the sql > >> module to use one or the other functions, and not as I sateted before > >> creating a general PDO module. > >> > >> Wrapping the connect, query and exec PDO methods into a couple of > >> functions and using PDO or not, depending on a config options should be > >> trivial imho. > >> > >> Alessandro > >> > >> Alessandro Briosi ha scritto: > >> > hi, > >> > > >> > Leonardo F. Cardoso ha scritto: > >> >> Hi there, > >> >> > >> >> thanks for the reply, Alessandro. > >> >> > >> >> I'm working in Brazilian Portuguese translation. Will send it to you > >> soon. > >> >> > >> > great > >> > > >> >> I could code SQL Server port for the 0.4 version. It works!! :-) > >> >> > >> > cool ;-P > >> > > >> >> By now, I'm interested in run OpenUpload inside Quercus. Quercus is > a > >> >> Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL > >> >> Server with normal mssql PHP package, the only support is with PDO > >> >> implementation. In the new database scheme, will be support for PDO? > >> >> > >> > > >> > Well, I have been thinking about it, but am not too sure if I can use > >> > it. > >> > One of the features is txtdb, which (Afair) is not supported by PDO, > so > >> > probably will stick to project modules for now, which might also > evolve > >> > into something simpler (some kind of little wrapper). > >> > Though I suppose you could also code a PDO version which would support > >> > multiple backends, but have not much experience with it. > >> > If needed I might have a look at it (as I'm also interested to do some > >> > PDO research) > >> > > >> > Let me know. > >> > Alessandro > >> > > >> > > >> > > >> > > ------------------------------------------------------------------------------ > >> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > >> 30-Day > >> > trial. Simplify your report design, integration and deployment - and > >> focus on > >> > what you do best, core application coding. Discover what's new with > >> > Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> > _______________________________________________ > >> > Openupload-devel mailing list > >> > Ope...@li... > >> > https://lists.sourceforge.net/lists/listinfo/openupload-devel > >> > >> > >> > > ------------------------------------------------------------------------------ > >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > >> 30-Day > >> trial. Simplify your report design, integration and deployment - and > >> focus > >> on > >> what you do best, core application coding. Discover what's new with > >> Crystal Reports now. http://p.sf.net/sfu/bobj-july > >> _______________________________________________ > >> Openupload-devel mailing list > >> Ope...@li... > >> https://lists.sourceforge.net/lists/listinfo/openupload-devel > >> > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel > |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 22:19:30
|
Well, that was my first thought, but reading the documentation, PDO simply
abstracts the _query, _connect, etc, but not the SQL syntax which is not
always the same, so probably extending the current classes (mysql, pgsql,
mssql) to support PDO (maybe even in the base class) would do the trick,
and have a config option to decide which to use PDO or native methods.
Something like:
class_method_query($sql) {
if ($this->config['use_pdo']) {
$this->PDO->query($sql);
<fetch the rows>
} else {
$result = native_query($sql);
<fetch the rows>
}
}
class_method_read() {
<prepare the sql statement according to the database syntax>
$this->class_method_query($sql);
}
_connect would call the different methods (PDO or native), and so on.
Alessandro
On Mon, 17 Aug 2009 16:25:50 -0300, "Leonardo F. Cardoso"
<leo...@gm...> wrote:
> Hi Alessandro,
>
> you mean code a DB class with PDO methods inside (insert, read, readex
> etc)
> ?
>
> Sds
> Leonardo
>
> On Mon, Aug 17, 2009 at 14:58, Alessandro Briosi <ts...@br...>
> wrote:
>
>> Hi again,
>> I have checked PDO documentation and it souldn't be that dificult to
>> implement a PDO version of the modules. Though PDO does not provide SQL
>> statement abstraction, so it would be probably best to extend the sql
>> module to use one or the other functions, and not as I sateted before
>> creating a general PDO module.
>>
>> Wrapping the connect, query and exec PDO methods into a couple of
>> functions and using PDO or not, depending on a config options should be
>> trivial imho.
>>
>> Alessandro
>>
>> Alessandro Briosi ha scritto:
>> > hi,
>> >
>> > Leonardo F. Cardoso ha scritto:
>> >> Hi there,
>> >>
>> >> thanks for the reply, Alessandro.
>> >>
>> >> I'm working in Brazilian Portuguese translation. Will send it to you
>> soon.
>> >>
>> > great
>> >
>> >> I could code SQL Server port for the 0.4 version. It works!! :-)
>> >>
>> > cool ;-P
>> >
>> >> By now, I'm interested in run OpenUpload inside Quercus. Quercus is
a
>> >> Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL
>> >> Server with normal mssql PHP package, the only support is with PDO
>> >> implementation. In the new database scheme, will be support for PDO?
>> >>
>> >
>> > Well, I have been thinking about it, but am not too sure if I can use
>> > it.
>> > One of the features is txtdb, which (Afair) is not supported by PDO,
so
>> > probably will stick to project modules for now, which might also
evolve
>> > into something simpler (some kind of little wrapper).
>> > Though I suppose you could also code a PDO version which would support
>> > multiple backends, but have not much experience with it.
>> > If needed I might have a look at it (as I'm also interested to do some
>> > PDO research)
>> >
>> > Let me know.
>> > Alessandro
>> >
>> >
>> >
>>
------------------------------------------------------------------------------
>> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> > trial. Simplify your report design, integration and deployment - and
>> focus on
>> > what you do best, core application coding. Discover what's new with
>> > Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> > _______________________________________________
>> > Openupload-devel mailing list
>> > Ope...@li...
>> > https://lists.sourceforge.net/lists/listinfo/openupload-devel
>>
>>
>>
------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> Openupload-devel mailing list
>> Ope...@li...
>> https://lists.sourceforge.net/lists/listinfo/openupload-devel
>>
|
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-17 19:26:09
|
Hi Alessandro, you mean code a DB class with PDO methods inside (insert, read, readex etc) ? Sds Leonardo On Mon, Aug 17, 2009 at 14:58, Alessandro Briosi <ts...@br...> wrote: > Hi again, > I have checked PDO documentation and it souldn't be that dificult to > implement a PDO version of the modules. Though PDO does not provide SQL > statement abstraction, so it would be probably best to extend the sql > module to use one or the other functions, and not as I sateted before > creating a general PDO module. > > Wrapping the connect, query and exec PDO methods into a couple of > functions and using PDO or not, depending on a config options should be > trivial imho. > > Alessandro > > Alessandro Briosi ha scritto: > > hi, > > > > Leonardo F. Cardoso ha scritto: > >> Hi there, > >> > >> thanks for the reply, Alessandro. > >> > >> I'm working in Brazilian Portuguese translation. Will send it to you > soon. > >> > > great > > > >> I could code SQL Server port for the 0.4 version. It works!! :-) > >> > > cool ;-P > > > >> By now, I'm interested in run OpenUpload inside Quercus. Quercus is a > >> Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL > >> Server with normal mssql PHP package, the only support is with PDO > >> implementation. In the new database scheme, will be support for PDO? > >> > > > > Well, I have been thinking about it, but am not too sure if I can use it. > > One of the features is txtdb, which (Afair) is not supported by PDO, so > > probably will stick to project modules for now, which might also evolve > > into something simpler (some kind of little wrapper). > > Though I suppose you could also code a PDO version which would support > > multiple backends, but have not much experience with it. > > If needed I might have a look at it (as I'm also interested to do some > > PDO research) > > > > Let me know. > > Alessandro > > > > > > > ------------------------------------------------------------------------------ > > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 > 30-Day > > trial. Simplify your report design, integration and deployment - and > focus on > > what you do best, core application coding. Discover what's new with > > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > _______________________________________________ > > Openupload-devel mailing list > > Ope...@li... > > https://lists.sourceforge.net/lists/listinfo/openupload-devel > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel > -- ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 17:58:54
|
Hi again, I have checked PDO documentation and it souldn't be that dificult to implement a PDO version of the modules. Though PDO does not provide SQL statement abstraction, so it would be probably best to extend the sql module to use one or the other functions, and not as I sateted before creating a general PDO module. Wrapping the connect, query and exec PDO methods into a couple of functions and using PDO or not, depending on a config options should be trivial imho. Alessandro Alessandro Briosi ha scritto: > hi, > > Leonardo F. Cardoso ha scritto: >> Hi there, >> >> thanks for the reply, Alessandro. >> >> I'm working in Brazilian Portuguese translation. Will send it to you soon. >> > great > >> I could code SQL Server port for the 0.4 version. It works!! :-) >> > cool ;-P > >> By now, I'm interested in run OpenUpload inside Quercus. Quercus is a >> Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL >> Server with normal mssql PHP package, the only support is with PDO >> implementation. In the new database scheme, will be support for PDO? >> > > Well, I have been thinking about it, but am not too sure if I can use it. > One of the features is txtdb, which (Afair) is not supported by PDO, so > probably will stick to project modules for now, which might also evolve > into something simpler (some kind of little wrapper). > Though I suppose you could also code a PDO version which would support > multiple backends, but have not much experience with it. > If needed I might have a look at it (as I'm also interested to do some > PDO research) > > Let me know. > Alessandro > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 17:42:23
|
hi, Leonardo F. Cardoso ha scritto: > Hi there, > > thanks for the reply, Alessandro. > > I'm working in Brazilian Portuguese translation. Will send it to you soon. > great > I could code SQL Server port for the 0.4 version. It works!! :-) > cool ;-P > By now, I'm interested in run OpenUpload inside Quercus. Quercus is a > Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL > Server with normal mssql PHP package, the only support is with PDO > implementation. In the new database scheme, will be support for PDO? > Well, I have been thinking about it, but am not too sure if I can use it. One of the features is txtdb, which (Afair) is not supported by PDO, so probably will stick to project modules for now, which might also evolve into something simpler (some kind of little wrapper). Though I suppose you could also code a PDO version which would support multiple backends, but have not much experience with it. If needed I might have a look at it (as I'm also interested to do some PDO research) Let me know. Alessandro |
|
From: Leonardo F. C. <leo...@gm...> - 2009-08-17 17:23:18
|
Hi there, thanks for the reply, Alessandro. I'm working in Brazilian Portuguese translation. Will send it to you soon. I could code SQL Server port for the 0.4 version. It works!! :-) By now, I'm interested in run OpenUpload inside Quercus. Quercus is a Java PHP implementation. Unfortunatelly, Quercus doesn't support SQL Server with normal mssql PHP package, the only support is with PDO implementation. In the new database scheme, will be support for PDO? Sds Leonardo On Mon, Aug 17, 2009 at 13:44, Alessandro Briosi <ts...@br...> wrote: > Hi Leonardo, > > Leonardo F. Cardoso ha scritto: > > Hi All, > > > > first post to this list. I'm very interested in this project. > > perfect :) > > > > Sorry if it was already discussed, but couldn't find in the archives. > > > No it wasn't :) > > > 1) Is there any work in progress of translation for Portuguese (Brazil)? > Nope. > > > > > 2) What's the best way to introduce SQL Server support? > > > I'm in the slow process to create a v0.5 release, which probably will > change some code in the sql backends, but it would be pretty easy to > port the v0.4 version. > > I'd suggest you to look at the mysql.inc.php file in lib/modules/db > > basically you should change the sql syntax to match SQL server's one, > and use sql server functions. (it shouldn't be that hard, I might be > able to create it and test it, though I have limited time right now) > > The connection parameters should be the same (afair), so use standard ones. > > Then you should have at least a sql to create the database tables. and > maybe the user (though sql server mainly uses the windows authentication) > Don't bother with the setup script right now, as I'll revisit it deeply. > > Of course you need sql server support in yout php installation :) > > Let me know if you need further information about this. > > Greetz. > Alessandro > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Openupload-devel mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/openupload-devel > -- ----------------------------------------- Leonardo F. Cardoso leonardo.f.cardoso "at" gmail.com leofcar "at" ig.com.br (Alternativo) MSN: lfc...@ho... ----------------------------------------- |
|
From: Alessandro B. <ts...@br...> - 2009-08-17 16:45:05
|
Hi Leonardo, Leonardo F. Cardoso ha scritto: > Hi All, > > first post to this list. I'm very interested in this project. perfect :) > > Sorry if it was already discussed, but couldn't find in the archives. > No it wasn't :) > 1) Is there any work in progress of translation for Portuguese (Brazil)? Nope. > > 2) What's the best way to introduce SQL Server support? > I'm in the slow process to create a v0.5 release, which probably will change some code in the sql backends, but it would be pretty easy to port the v0.4 version. I'd suggest you to look at the mysql.inc.php file in lib/modules/db basically you should change the sql syntax to match SQL server's one, and use sql server functions. (it shouldn't be that hard, I might be able to create it and test it, though I have limited time right now) The connection parameters should be the same (afair), so use standard ones. Then you should have at least a sql to create the database tables. and maybe the user (though sql server mainly uses the windows authentication) Don't bother with the setup script right now, as I'll revisit it deeply. Of course you need sql server support in yout php installation :) Let me know if you need further information about this. Greetz. Alessandro |
23 messages has been excluded from this view by a project administrator.
