Raúl Marín
47f06f40df
Remove leftover plpython warnings
2020-03-26 12:49:15 +01:00
manmorjim
b9615a912f
Adding debug for _CDB_Group_API_Auth
2020-02-12 18:55:44 +01:00
manmorjim
c8410541a4
Fix variable naming
2020-02-12 10:09:07 +01:00
manmorjim
55ebc73f9e
Remove comments to fix syntax errors
2020-02-11 19:31:37 +01:00
manmorjim
027256dbb7
Make cartodb-postgresql python3 compatible
...
- encoding string with python3
- adapt HTTPConnection signature to python3
2020-02-11 18:51:24 +01:00
Raul Marin
093e0bcb36
Always use @@plpythonu@@ as variable
2019-12-26 17:59:29 +01:00
Raul Marin
ca1d5b0c91
Avoid outputting python error messages in regress tests
2019-12-26 17:46:10 +01:00
Raúl Marín
ecf0a06448
Merge remote-tracking branch 'carto/master' into 2273_support
2019-12-24 14:14:33 +01:00
Raúl Marín
dfd26d930e
Add huge warnings
2019-12-24 00:59:11 +01:00
Raúl Marín
9010642326
Revert "Revert 0.33.0"
...
This reverts commit 24cb6cf9c1
2019-12-24 00:33:35 +01:00
Raúl Marín
24cb6cf9c1
Revert 0.33.0
2019-12-23 20:23:02 +01:00
Alberto Romeu
1c7b0c71ec
use literal substitution instead of identifier
2019-12-20 16:27:03 +01:00
Raúl Marín
6ebffe1b2c
PR review improvements
2019-12-17 11:26:56 +01:00
Raúl Marín
b3503ea429
FederatedTableList: Fix column parsing with default names
2019-12-12 15:52:50 +01:00
Raúl Marín
3c869e3d5a
FServer list: Return the username if the user has been granted access to the server
2019-12-11 18:37:26 +01:00
Raúl Marín
dac135890d
CDB_Federated_Table_Register: Reuse webmercator_column if geom_column is NULL
2019-12-10 18:08:25 +01:00
Raúl Marín
9372c9f4e0
FederatedServer: Fix a bug when extracting the webmercator column from the view definition
2019-12-05 16:26:37 +01:00
Raúl Marín
da570c50aa
Merge remote-tracking branch 'carto/master' into federated_functions
2019-11-15 13:50:21 +01:00
Raúl Marín
d549ecced4
Merge pull request #385 from CartoDB/federated_functions_permissions
...
Federated functions permissions
2019-11-15 13:47:16 +01:00
Raúl Marín
fde12c818a
Update comments
2019-11-15 13:09:52 +01:00
Raúl Marín
e99e4a02c9
Remove TODO
...
Since the server registration requires superadmin priviledges
it doesn't make sense to over protect the role creation
2019-11-14 19:00:09 +01:00
Raúl Marín
fa5f0bcbc1
CDB_Federated_Server_Grant_Access: comment about search_path
2019-11-14 18:55:38 +01:00
Raúl Marín
adca727169
Revert "Go back to public user mappings"
...
This reverts commit 64e185b841
2019-11-14 18:46:45 +01:00
Raúl Marín
0893fae025
Revert "CDB_Federated_Server_Unregister: Drop owned in cascade"
...
This reverts commit 1b86517007
2019-11-14 18:46:02 +01:00
Raúl Marín
e69d3b1c30
Place all views in a shared schema
2019-11-14 18:45:09 +01:00
Rafa de la Torre
a57431a04d
Merge pull request #384 from CartoDB/federated_diagnostics_latency
...
Federated diagnostics latency
2019-11-14 18:29:25 +01:00
Rafa de la Torre
064cc2a76b
Fix for missing port in pg_foreign_server: default to standard 5432
2019-11-14 17:57:05 +01:00
Raúl Marín
6e455efcdd
Improve warning
2019-11-14 14:15:56 +01:00
Raúl Marín
1b86517007
CDB_Federated_Server_Unregister: Drop owned in cascade
...
Since now views might be owned by other roles, we need to drop them
in cascade to force deletion
2019-11-14 14:07:41 +01:00
Raúl Marín
64e185b841
Go back to public user mappings
2019-11-14 13:43:28 +01:00
Raúl Marín
38d8a470bc
Federated Server: Grant all over postgis and cartodb schemas
2019-11-14 13:24:32 +01:00
Raúl Marín
4920029560
CDB_FederatedServerTables: Improve permission handling and error messages
2019-11-14 13:10:21 +01:00
Rafa de la Torre
9b91704480
Calculate stats only when they make sense
2019-11-13 19:27:56 +01:00
Rafa de la Torre
57dcfc2a35
Add a bunch of statistics
2019-11-13 18:55:09 +01:00
Rafa de la Torre
3ae7b1fe05
Fix bug: do not initialize samples in every iter
2019-11-13 18:27:14 +01:00
Rafa de la Torre
f7d10adbc2
Fix another python2/3 incompat: xrange
2019-11-13 17:16:53 +01:00
Rafa de la Torre
203bd64058
Fix python2/3 compat issue
2019-11-13 17:02:22 +01:00
Rafa de la Torre
19c6de2096
Comment out suspected line
...
This may be causing the error
ERROR: could not compile PL/Python function "__cdb_fs_tcp_foreign_server_latency"
DETAIL: SyntaxError: invalid syntax (<string>, line 26)
when testing in PG12 + plpythonu3
2019-11-13 14:52:24 +01:00
Raúl Marín
e231500c46
Give permissions over cartodb to the FS role
2019-11-13 14:20:08 +01:00
Rafa de la Torre
4b9c048235
Close socket properly before the next iteration
...
This avoid the errors `[Errno 106] Transport endpoint is already
connected` which are due to connections kept in TIME_WAIT state.
We don't use socket.SO_REUSEADDR as it would make the first connection
a special case compared to the following ones.
2019-11-13 12:25:41 +01:00
Rafa de la Torre
5897d8a9cb
Fix timer start in measurements
2019-11-13 12:24:59 +01:00
Rafa de la Torre
980657c4a4
Do not add None to samples in case of connection error
...
Otherwise we get `TypeError: unsupported operand type(s) for +: 'float'
and 'NoneType'` when calculating the average.
2019-11-13 12:16:21 +01:00
Rafa de la Torre
a4a4a1dff1
Honor n_samples param
2019-11-13 12:13:42 +01:00
Rafa de la Torre
0362825b8c
Encapsulate python in __CDB_FS_TCP_Foreign_Server_Latency
...
Instead of having a generic function, merge
__CDB_FS_TCP_Network_Latency and __CDB_FS_Foreign_Server_Host_PG into
one function so that it can only "ping" federated servers.
2019-11-13 11:44:24 +01:00
Raúl Marín
9eab5e2533
__CDB_FS_Generate_Server_Role_Name: set to STABLE
...
current_database() is stable, not immutable
2019-11-12 18:15:20 +01:00
Raúl Marín
0d455d9521
__CDB_FS_List_Foreign_Schemas_PG: Remove extra role generation
2019-11-12 18:14:36 +01:00
Rafa de la Torre
18f9f79fe8
Rename key to server_latency_ms to be self-explanatory
2019-11-12 15:08:26 +01:00
Rafa de la Torre
a032cc08e0
Measure latency as the avg of n_samples
2019-11-12 15:01:56 +01:00
Rafa de la Torre
d3ae4b808c
Remove default port 5432 in generic function
2019-11-12 13:27:42 +01:00
Rafa de la Torre
26f91001ee
Retrieve port from the catalog
2019-11-12 13:06:14 +01:00
