[web2py] Re: Problems using Restful method PUT

[Dave S]

On Friday, June 19, 2020 at 4:32:04 PM UTC-7, Ariel Antunez wrote:
>
> Hi everyone, I am working in a application using vue.js on vue-cli and 
> axios. I need to use the method PUT, but I get the error, METHOD NOT 
> ALLOWED, I write a headers in the controllers. POST and GET work perfect. 
> How can I resolve that Problem? Thanks


If that's an error from web2py, please post the important information from 
the ticket, including the stack trace.  If that's an error from the 
browser, you may need to use the browser developer tools to find the 
request or response that comes from, and post those details.

/dps
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/3f55e1d2-e072-439c-b107-4d044d157ef4o%40googlegroups.com.

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Dave S]

On Thursday, June 18, 2020 at 10:44:53 PM UTC-7, Davidiam wrote:
>
> Good Morning,
>
> I would like to know what I would have to modify in order to connect to MS 
> SQL from web2py with TLS 1.2.  We are running web2py 2.18.5 on a Windows 
> 2016 IIS server.
>
> Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and 
> enable TLS 1.2 and now all our MS SQL DB connections are failing.
>
> Thank you very much for your help on this, I would appreciate a rapid 
> reply as our development in web2py is now blocked due to this.
>
> Kind Regards,
> David
>

I don't think I can help you; I'm not on either IIS or MSSQL.  One of our 
long-time experts and contributors   Niphlod's (er, Stephane) was involved 
with IIS environments, so web2py has been well wrung out on IIS, but he's 
been busy elsewhere lately.

BTW, please don't be confused by Google Groups form having a check-box for 
"show on top".  In this group, that is used primariy for major 
announcements, usually by Massimo, such as the "New py4web group" post.  
Since GG defaults to showing posts in order of recent activity, new posts 
are near the top anyway.

/dps

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ab9db1ee-6ab5-4ba0-8d5d-a0882e3b4e9fo%40googlegroups.com.

[web2py] Problems using Restful method PUT

[Ariel Antunez]

Hi everyone, I am working in a application using vue.js on vue-cli and axios. I 
need to use the method PUT, but I get the error, METHOD NOT ALLOWED, I write a 
headers in the controllers. POST and GET work perfect. How can I resolve that 
Problem? Thanks

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/a2f3c667-cf63-494d-9862-984389fc0b8fo%40googlegroups.com.

[web2py] Re: Problem with upload field

[Dave S]

On Friday, June 19, 2020 at 4:30:12 AM UTC-7, Константин Комков wrote:
>
> I am very happy today! I can find user who can't load file and talk with 
> him. User can't load file with name:
> ФГБОУ ВО Липецкий государственный педагогический университет им. П.П. 
> Семенова-Тян-Шанского
>
> filename in error for that file is 
>
> doc_images.file.9bbb3bdd72dc6f61.d0a4d093d091d09ed0a320d092d09e20d09bd0b8d0bfd0b5d186d0bad0b8d0b920d0b3d0bed181d183d0b4d0b0d180d181d182d0b2d0b5d0bdd0bdd18bd0b920d0bfd0b5d0b4d0b0d0b3d0bed0b3d0b8d187d0b5d181d0bad0b8d0b920d183d0bdd0b8d0b2d0b5d180d181d0b8d182d0b5d18220d0b8d0bc2e20d09f2ed09f2e20d0a1d0b5d0bcd0b5d0bdd0bed0b2d0b02dd0a2d18fd0bd2dd0a8d0b0d0bdd181d0bad0bed0b3d0be2e6a7067.jpg
>
> How can I validate it? As I understand I need to set maximal length for 
> filename, yes?
>


In the book,
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Field-types>
it says there is no default validator for upload fields, and there is a 
remark that "default length is 512 bytes" , but the name-encoding process 
is likely to cross the 512 byte boundary somewhere around 200-240 original 
characters (depending on how many multi-byte characters there are).  In 
addition to the DB limits, the OS is likely to have a maximum size of file 
name (I don't remember what it is for NTFS, but it is likely smaller than 
the maximum permissable path; a quick goo-search indicates both are 260 
unless you have W10 *and* you have changed a registry setting)..  If the 
filesystem isn't allowing the encoded name because of length, I'd have 
expected the ticket to occur before the not-found error, but I haven't 
checked out how that try-except is set up.

I haven't tried setting a validator, but you've already done that.  
IS_UPLOAD_FILENAME() seems not to have a filename length check.  You could 
try making your regex not fit names that exceed a limit, or you could do a 
ON_VALIDATE hook to check the length directly.

/dps



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/1feabe7b-aac8-44c8-9186-98ebf7d63ac7o%40googlegroups.com.

[web2py] Re: Problem with upload field

[Константин Комков]

I am very happy today! I can find user who can't load file and talk with 
him. User can't load file with name:
ФГБОУ ВО Липецкий государственный педагогический университет им. П.П. 
Семенова-Тян-Шанского

filename in error for that file is 
doc_images.file.9bbb3bdd72dc6f61.d0a4d093d091d09ed0a320d092d09e20d09bd0b8d0bfd0b5d186d0bad0b8d0b920d0b3d0bed181d183d0b4d0b0d180d181d182d0b2d0b5d0bdd0bdd18bd0b920d0bfd0b5d0b4d0b0d0b3d0bed0b3d0b8d187d0b5d181d0bad0b8d0b920d183d0bdd0b8d0b2d0b5d180d181d0b8d182d0b5d18220d0b8d0bc2e20d09f2ed09f2e20d0a1d0b5d0bcd0b5d0bdd0bed0b2d0b02dd0a2d18fd0bd2dd0a8d0b0d0bdd181d0bad0bed0b3d0be2e6a7067.jpg

How can I validate it?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/c0d405b0-1196-4bdb-9cca-85da2242b1dfo%40googlegroups.com.

Re: [web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Davidiam]

The reason that I put it here is that that web2py pydal uses the pyodbc 
driver and I thought that there may be version requirements or connection 
parameters that would resolve this.
I will now also look at the link that you sent.

On Friday, June 19, 2020 at 9:35:30 AM UTC+2, Nico Zanferrari wrote:
>
> Hi David,
>
> if I understand right you are not anymore able to connect to an external 
> MS SQL database from a Windows server. This does not seem a web2py issue ;-)
>
> Anyhow, have you checked that your web2py server and your  external MS SQL 
> database are compatible with TLS 1.2? Have you verified it? See here 
> 
>  
> for details. 
>
> Nico
>
>
> Il giorno ven 19 giu 2020 alle ore 07:45 Davidiam  > ha scritto:
>
>> Good Morning,
>>
>> I would like to know what I would have to modify in order to connect to 
>> MS SQL from web2py with TLS 1.2.  We are running web2py 2.18.5 on a Windows 
>> 2016 IIS server.
>>
>> Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and 
>> enable TLS 1.2 and now all our MS SQL DB connections are failing.
>>
>> Thank you very much for your help on this, I would appreciate a rapid 
>> reply as our development in web2py is now blocked due to this.
>>
>> Kind Regards,
>> David
>>
>> -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to web...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/bd3335e9-c0e6-4fdb-9eaa-5ee210deaa37o%40googlegroups.com.

Re: [web2py] We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

[Nico Zanferrari]

Hi David,

if I understand right you are not anymore able to connect to an external MS
SQL database from a Windows server. This does not seem a web2py issue ;-)

Anyhow, have you checked that your web2py server and your  external MS SQL
database are compatible with TLS 1.2? Have you verified it? See here

for details.

Nico


Il giorno ven 19 giu 2020 alle ore 07:45 Davidiam 
ha scritto:

> Good Morning,
>
> I would like to know what I would have to modify in order to connect to MS
> SQL from web2py with TLS 1.2.  We are running web2py 2.18.5 on a Windows
> 2016 IIS server.
>
> Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and
> enable TLS 1.2 and now all our MS SQL DB connections are failing.
>
> Thank you very much for your help on this, I would appreciate a rapid
> reply as our development in web2py is now blocked due to this.
>
> Kind Regards,
> David
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/e03e78e7-24fd-494c-ab66-47f899260c82o%40googlegroups.com
> 
> .
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAAE8D_C-%2B-rH3YB4WtxBMK7PnGc7Fp1yM146m1-y_S-fSEKZ5Q%40mail.gmail.com.

[web2py] Re: Problem with upload field

[Константин Комков]

*Dave*, hello and thank you for attention!
You are right my user (my colleague) load file with name in web2py format 
and don't tell me about it (:
But I have error in any way becouse there is users which can't load file 
with web2py format and I don't know how they are doing that.
I have examples filenames of that users from errors:

doc_images.file.b293994694c6d81d.32303230303631375f31393231343920d09fd0b0d181d0bfd0bed180d18220d09fd0bed0b4d0bed181d0b8d0bdd0bdd0b8d0bad0bed0b2d0b020d09bd0b5d0bdd0b020d181d182d18020d0be20d0b7d0b0d0b3d180d0b0d0bdd0bfd0b0d181d0bfd0bed180d182d0b52e6a7067.jpg
doc_images.file.aefe38bc2064002c.d0a3d0b4d0bed181d182d0bed0b2d0b5d180d0b5d0bdd0b8d0b520d0ba20d0b7d0bed0bbd0bed182d0bed0b920d0bcd0b5d0b4d0b0d0bbd0b820d09fd0bed0b4d0bed181d0b8d0bdd0bdd0b8d0bad0bed0b2d0b020d09bd0b5d0bdd0b02e706466.pdf

That filenames looks like previous, but I don't sure.

There is file with name 
(doc_images.file.80bde2fc22f5afc8.31353932333930313839373638363033373433343035313436333933353834312e6a7067)
 
in upload folder.
That file with name (
doc_images.file.b520635e438be8d7.646f635f696d616765732e66696c652e383062646532666332326635616663382e33313335333933323339333033313338333933373336333833363330333733343334333033353331333433363339333533383334333132653661373036372e6a7067.jpg)
 
are absent.
Current situation 137 users with success and 5 users can't load files (For 
that 5 users > 100 tikets was created on server with one type of error: No 
such file or directory)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f7084a73-8da1-4a14-ba25-cef7489acecao%40googlegroups.com.