google cloud Stackdriver Metrics to scale an Manage instance group – Regional

What are the Stackdriver Metrics we can use to autoscale Regional Manage instance groups ?
When i check the docs it says
Regional managed instance groups do not support filtering for per-instance metrics.
Regional managed instance groups do not support autoscaling using per-group metrics.

Is that mean I can not use any Stackdriver Metrics other than CPU ?

How can i end SharePoint Designer workflow instance inside stage 1

I have created one workflow in SharePoint designer which is pausing for 24 hrs and then again going back to "stage 1" to check Ageing field value. How i can end the workflow instance automatically if Status is "complete and published". Right now "End of workflow" is not coming inside "stage 1" when i am trying to add that inside status "complete and published" statement and workflow instance keeps on running although status is complete and published.

enter image description here

amazon web services – AWS billing for EC2 instance bandwidth

I have two AWS accounts. In the first Account, I have data in S3. And I have an application running on Ec2 instance in 2nd Account. Both are in the same region

I have mounted the s3 of the first account to Ec2 instance in the second account.

I’m able to witness the data transfer in glances if I create or duplicate(copy existing file) any file on mounted s3 which is pretty obvious.

My question is will AWS charge for the data transfer from Ec2 to S3 which are in same region but different accounts.

findinstance – What should I do to find an instance that meets the requirements

In a non-obtuse triangle $triangle ABC$, the sides of the triangle satisfy the following conditions a^2 > b*c , b^2 > a*c and c^2 > a*b. Now we need to verify whether the inequality $$(a + b + c) (b^2*c + c^2*a + a^2*b + b*c^2 + c*a^2 + a*b^2) <= 6 (a^2*b^2 + b^2*c^2 + c^2*a^2)$$ always holds.

triangle = 
  a > 0 && b > 0 && c > 0 && a + b > c && a + c > b && b + c > a;
nonObtuseAngle = 
  a^2 + b^2 >= c^2 && a^2 + c^2 >= b^2 && b^2 + c^2 >= a^2;
additionalConditions = a^2 > b*c && b^2 > a*c && c^2 > a*b;
FindInstance(
 triangle && nonObtuseAngle && 
  additionalConditions && (a + b + c) (b^2*c + c^2*a + a^2*b + b*c^2 +
       c*a^2 + a*b^2) <= 6 (a^2*b^2 + b^2*c^2 + c^2*a^2), {a, b, 
  c}, Reals, WorkingPrecision -> 100)
ForAll({a, b, c}, 
 triangle && nonObtuseAngle && 
  additionalConditions, (a + b + c) (b^2*c + c^2*a + a^2*b + b*c^2 + 
     c*a^2 + a*b^2) <= 6 (a^2*b^2 + b^2*c^2 + c^2*a^2))
Resolve(%)

I use the above method to verify that this inequality heng is established, but the FindInstance function cannot find an instance that meets the requirements.

What should I do to find an instance that meets the requirements.

sql server – AG listener with MultiSubnetfailover True on Named Instance

Stack Exchange Network


Stack Exchange network consists of 177 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

debian – Sending a file to a remote clamd instance

I may be misunderstanding how to utilize clamd. I’ve got a situation where I have a media server that isn’t quite powerfull enough to scan files as well as host the other services it is running (raspberry pi). While I was looking through clamd.conf and man pages, it looks like there is an option to have clamd listen on a specified IP address and socket. Is there a way to stream files from a remote file server to another machine running clamd to be scanned?

I’ve also come accross this “remote clamd scanning” though it even points out in the code

You must be using a local socket to scan local files

(it also is designed to scan a single file at a time, rather than a directory which would be nice)

A similar question has been asked here though as sandroid was pointing out

Clamd sits and listens for instructions on what files need to be scanned, that is the communication it receives via TCP. We need to know how it accesses the mail files to be scanned…

So, is remote file scanning not supported by clamd? If not, what would be the best approach to scan remote files? I could rsync over the files temporarly and scan them or configure raspbian as a file server and mount it to the machine I am hosting the clamd service. If there are better recomendations, it would be much appreciated.

ssh – VM instance down suddenly and fail to restart, showing ‘serviceAccount’ was not found

I have a django server running in VM instance, the server working fine before this, but in this morning the server was unable to access. So I tried to SSH into the VM instance, but it took long time and shows error that SSH cant be connected.

I then tried to restart the VM instance by “stop” the VM instance in GCP, then “start” it back up. But it can’t be start up and showing this error.


Start VM instance “earthent”
The resource ‘755754197401-compute@developer.gserviceaccount.com’ of type ‘serviceAccount’ was not found.


I also noticed that some of my others VM instance having same error, but it is weird most of the VM instances in the same GCP just working fine.

Reference The defails of VM instance

MySQL Workbench connection to a MySQL server running in a Google Cloud VM instance

I have a google cloud vm instance running a Ubuntu OS and I have installed a mysql server there. The server is running and I can check the status by sudo service mysql status

I have modified the mysql my.cnf file as,

[mysql]
bind-address=0.0.0.0

I have setup the firewall of my instance as follows,

IP                  Protocol
*******************************************
127.0.0.1/32        all
0.0.0.0/32          all
10.128.0.0/9        tcp, udp, icmp
0.0.0.0/0           tcp:22,3389,443,80 icmp

Click here for the screenshot

Now in the Mysql connection settings, I have filled up the following,

Connection Method: Standard TCP/IP over SSH
Parameter:
SSH Hostname: <vm external ip>:22
SSH Username: <vm username>
SSH Key File: <vm public key file>
MySQL Hostname: 127.0.0.1
MySQL Server Port: 3306
Username: <mysql username>
Password: <mysql password>

Click here for the screenshot

But the test connection is giving the error,
Access denied for 'none'. Authentication that can continue: publickey

Click here for the screenshot

Now, I have created a public key-private key pair by puttygen and successfully established the Winscp connection by that.

ip address – Point Subdomain in Google Domains to Google Compute Instance running WordPress

I have installed wordpress (the bitnami multi-site version) to a compute instance from the marketplace. I’ve also recently moved my domain registration to domains.google.com. Everything is working fine with the top-level domain. I also set up a subdomain, wp.mydomain.com in the domains interface pointed to the static external IP I configured for the compute instance running wordpress. When I go to wp.mydomain.com it redirects me to http://.xip.io/.

How do I get this set up so that I stay on wp.mydomain.com instead of going to my ip address as the url?

tnsnames – Oracle 19c database instance doesn’t register with listener

I have just installed an oracle 19c (19.3.0.0.0 to be exact) database on a centOS 8 virtual machine. The databases instances can all be started with sqlplus on the host machine. I have set up listener.ora and tnsnames.ora based on an existing (functioning) oracle 12c, which has a very similar setup.

I did the initial installation using the .rpm from Oracle, thinking that would make things easier. It probably didn’t make things any more difficult, but it meant that the directory structure was not what I’d have expected. Still, it isn’t as though it is unusable, just located differently. Having done that, I did a basic install of the DB instances I wanted (using pretty much all default settings) with dbca.

Finally, I setup listener.ora and tnsnames.ora based on the working 12c installation. The problem is, no matter what I do, the DB instances don’t seem to be registering themselves with the listener.

The tnsnames.ora looks like this:

## initially copied from linuxoracle12 (20200617-1112)

LISTENER_TEMP =
  (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))


TMF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tmf.my-company-name.com)
    )
  )

LISTENER_TMFDE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))


LISTENER_TMF =
  (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))


TEMP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEMP.my-company-name.com)
    )
  )


TMFDE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TMFDE.my-company-name.com)
    )
  )

The listener.ora looks like this:

## initially copied from linuxoracle12 (20200617-1117)

SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
   (GLOBAL_DBNAME = TMF)
   (ORACLE_HOME = /opt/oracle/product/19c/dbhome_1)
   (SID_NAME = TMF)
  )
  (SID_DESC =
   (GLOBAL_DBNAME = TEMP)
   (ORACLE_HOME = /opt/oracle/product/19c/dbhome_1)
   (SID_NAME = TEMP)
  )
  (SID_DESC =
   (GLOBAL_DBNAME = TMFDE)
   (ORACLE_HOME = /opt/oracle/product/19c/dbhome_1)
   (SID_NAME = TMFDE)
  )
 )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

As an example the initTEMP.ora looks like this:

## initially generated with dbca
## 20200617 added: *.local_listener='LISTENER_TEMP'
TEMP.__data_transfer_cache_size=0
TEMP.__db_cache_size=855638016
TEMP.__inmemory_ext_roarea=0
TEMP.__inmemory_ext_rwarea=0
TEMP.__java_pool_size=0
TEMP.__large_pool_size=16777216
TEMP.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
TEMP.__shared_io_pool_size=0
TEMP.__shared_pool_size=301989888
TEMP.__streams_pool_size=0
TEMP.__unified_pga_pool_size=0
*.audit_file_dest='/opt/oracle/admin/TEMP/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/opt/oracle/oradata/temp/TEMP/controlfile/o1_mf_hgkpt5t0_.ctl','/opt/oracle/fast_recovery_area/TEMP/controlfile/o1_mf_hgkpt5w0_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/opt/oracle/oradata/temp/'
*.db_domain='ubs-hainer.com'
*.db_name='TEMP'
*.db_recovery_file_dest='/opt/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8256m
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TEMPXDB)'
*.local_listener='LISTENER_TEMP'
*.open_cursors=300
*.pga_aggregate_target=378m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1134m
*.undo_tablespace='UNDOTBS1'

So far so good… I thought. But regardless of what I try, I cannot get the DB instances to register with the listener. When I run lsnrctl services, I get the following:

(oracle@linuxoracle19 admin)$ lsnrctl services

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-JUN-2020 12:11:01

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linuxoracle19.my-company-name.com)(PORT=1521)))
Services Summary...
Service "TEMP" has 1 instance(s).
  Instance "TEMP", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "TMF" has 1 instance(s).
  Instance "TMF", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "TMFDE" has 1 instance(s).
  Instance "TMFDE", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

In various posts and what not, I have read that status UNKNOWN, whilst not seriously bad, actually means that the service in question is not registered with the listener. This is exemplified when I try to connect using NetBeans or SQLDeveloper. In both cases I get the error:

IO Error: The Network Adapter could not establish the connection

Before anybody asks, yes, I did try tnsping. When I did, I got:

(oracle@linuxoracle19 dbhome_1)$ tnsping TEMP 5

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 17-JUN-2020 16:02:19

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/opt/oracle/product/19c/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linuxoracle19.my-company-name.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEMP.my-company-name.com)))
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
(oracle@linuxoracle19 dbhome_1)$ trcroute TEMP

Trace Route Utility for Linux: Version 19.0.0.0.0 - Production on 17-JUN-2020 16:05:39

Copyright (c) 1995, 2019, Oracle.  All rights reserved.

Route of TrcRoute:
------------------

Node: Client        Time and address of entry into node:
-------------------------------------------------------------
17-JUN-2020 16:05:39 ADDRESS= PROTOCOL=TCP  HOST=linuxoracle19.my-company-name.com  PORT=1521

Node: Server        Time and address of entry into node:
-------------------------------------------------------------
17-JUN-2020 16:05:39 ADDRESS= PROTOCOL=TCP  HOST=linuxoracle19.my-company-name.com  PORT=1521

Can anybody out there tell me what is going wrong? I really have no idea why the current setup doesn’t work.