Categories
Database Development

UTL_HTTP call inside trigger leads to ORA-06502 when inserting from select

In order to allow a developer to make a SOAP call from an Oracle 11gR1 (11.1.0.7 PSU 24) instance using UTL_HTTP. He created a stored procedure : CREATE OR REPLACE PROCEDURE CALL_WS (URL IN VARCHAR2, REQUEST IN VARCHAR2, RESPONSE OUT VARCHAR2, ERRLOG OUT VARCHAR2) IS L_HTTP_REQ UTL_HTTP.REQ; L_HTTP_RESP UTL_HTTP.RESP; L_HTTP_URL_V VARCHAR2 (32767); IP_INPUTDATA_V VARCHAR2 (32767); […]

Categories
Mastering Development System & Network

Generate keys for nginx, with only a public key

I have an Elasticsearch endpoint as a service (I have no access to config/server). The service provided me with a username and password, and a single "TLS certificate" file, which when decoded says that it is RSA Public-Key: (2048 bit) I am running nginx and want to use it as a reverse proxy for this […]

Categories
User Help Web Apps

How to deploy web.py app

I am completely new to web deployments, so please forgive me if these are simple and/or not well-formed questions. I am trying to deploy an app built using web.py to an A2 server. The application works fine on my development machine using python main.py where main.py has some simple Hello World code from the web.py […]

Categories
Mastering Development

React and Node application not uploading Images to Cloudinary, 404 error with no explanation

I am trying to upload an image to cloudinary. I am using this resource as my tutorial… I am able to render a preview of the image onto my screen and I console log the base64 encoded url, and it works as it is supposed to. After I select my Image, I hit upload and […]

Categories
Mastering Development

No Access-Control-Allow-Origin after many calls edit > Axios network error catch

I’ve googled this issue very often and I think I’ve inserted them all which I know is redundant but I’m desperate. In my server I’ve added: app.use(cors()) and app.use(function (req, res, next) { res.setHeader(‘Access-Control-Allow-Origin’, ‘*’); res.setHeader(‘Access-Control-Allow-Headers’, ‘Origin, X-Requested-With, Content-Type, Accept’); res.setHeader(‘Access-Control-Allow-Methods’, ‘POST, GET, PATCH, DELETE, OPTIONS’); next(); }); and in the route, I’ve added: router.use([‘/api/’, […]

Categories
Mastering Development System & Network

Nginx reverse proxy and a URL rewrite

I would like to rewrite the URL in a reverse proxy so that it removes the first segment but leaves any following segments intact. I need this to happen before it hits the proxy pass. Example: /admin/auth/local —-> (REWRITES TO) /auth/local /admin/auth/register ——-> (REWRITES TO) /auth/register My Location block: location /admin { #add_header Access-Control-Allow-Origin *; […]

Categories
Mastering Development System & Network

ERR_CERT_COMMON_NAME_INVALID on chrome

When trying to login to my website on Chrome based browsers I get the error: Failed to load resource: net::ERR_CERT_COMMON_NAME_INVALID On firefox it works fine, tho. I installed certificates by certbot. My corresponding nginx settings look like: server { listen 80; server_name pvapp.umwelt-campus.de; return 302 https://$server_name$request_uri; } server{ # SSL configuration listen 443 ssl default_server; […]

Categories
Mastering Development

net::ERR_CONNECTION_REFUSED – Problem with CORS, Heroku App and NodeJS

i’m facing a ERR_CONNECTION_REFUSED on client-side, hosted on heroku app and my node back-end server, running in my PC. i have configured CORS on server.js this way: var express = require(‘express’) var cors = require(‘cors’) var port = process.env.PORT || 5000 var app = express() app.use(cors()); app.use(express.json()) app.use(function(req, res, next) { res.header("Access-Control-Allow-Origin", "*") res.header(‘Access-Control-Allow-Methods’, ‘GET,PUT,POST,DELETE’); […]

Categories
Mastering Development

PHP cors error with headers from Angular call

my endpoint has this: <?php header(‘Access-Control-Allow-Origin: *’); header("Access-Control-Allow-Credentials: true"); header(‘Access-Control-Allow-Methods: GET, PUT, POST, DELETE, OPTIONS’); header(‘Access-Control-Max-Age: 1000’); header(‘Access-Control-Allow-Headers: Accept,Origin, Content-Type, X-Auth-Token , Authorization’); … But with my Angular Call from Localhost, I get this error: Access to XMLHttpRequest at ‘https://example.com/createuser.php?api_key=123’ from origin ‘http://localhost:8100’ has been blocked by CORS policy: Response to preflight request doesn’t pass […]

Categories
Mastering Development

Django + React Able to create new user in database, but token-auth returns 400 bad request

So I have an app that I’m writing. It’s working, for the most part, so far. I only currently have a login and signup setup, with a ‘homepage’ that just has a logout button and some text on it so I can test. When I do signup, it posts the user to the database, but […]