Tag: Server

unit tests – Jest coverage difference between local (Windows) and server in a single file

I have a Vue project with unit tests, and we have a Jenkins generation server that builds and tests feature branches before we can merge them into the development branch. Right now, I have a really strange difference between code coverage reports between when I run the tests locally and the report on the generation server. I have already tried throwing node_modules to see if this fixes something, but it is not.

For a file, when I run tests locally, I get these results:

  MyComponent.vue                  |    57.89 |       25 |    33.33 |    76.92 |          68,75,81 |

On Jenkins, I get:

  MyComponent.vue                  |       25 |      100 |      100 |       25 |          58,64,69 |

This is the only file where this occurs. For all other files, the results are identical.

One possible culprit may be the fact that I am using Windows. Mac users on my team get the same results as Jenkins. However, shouldn't the knot and the joke work the same on both platforms?

And why would this happen only for this file, and not for any other? This file is nothing unique. It is a View component. A fairly simple one. It uses javascript while most of our components use the script, but it is not the only javascript component. It imports another component, has properties, data, a calculated property, and a method. As far as I know, this file is really nothing strange.

I don't know if this is caused by Windows vs Unix (seems likely), by Jest, by Vue or by js vs ts. I am completely perplexed.

Do the following two methods get server certificates for web servers to host web applications?

What is certbot make?

certbot is a program from Let & # 39; s Encrypt, which automates the certification process. The order you published generates a certificate signing request (CSR) for domains your_domain and www.your_domain. Let & # 39; s Encrypt's servers then try to contact your instance of certbot via these areas. If successful, this proves that you own these domains well and are therefore eligible to generate certificates for it.

In addition, it automatically configures nginx to serve over HTTPS and use these certificates. These certificates will be accepted as legitimate by all modern browsers.

What is dotenv make?

dotenv generates a self-signed certificate. These are useful for development purposes, where you don't expect someone to try and spoof your connection. Most likely, you will connect to localhost anyway.

Therefore, while these certificates are indeed real certificates that you can use to test your HTTPS configuration, all browsers will warn you that these certificates are not reliable. You can ignore these warnings, some browsers even allow options to ignore untrusted certificates on localhost (for example, Chrome allow-insecure-localhost or you can manually mark this certificate as verified.

Of course, the purpose of these certificates is debugging and testing. You should never use such certificates in a production environment.

Do they run on web servers or web applications?

The task of a web server is to manage incoming connections, analyze the HTTP request, and then forward it to the web application. The server is therefore the one that manages TLS stuff, such as the TLS version to offer and the appropriate encryption.

You could, in theory, let a web application do that, but why would you do it? The app focuses on what a user does, not the technical detail of the connection.

Can the two be exchanged?

Yes. certbot and dotenv are not related to Ubuntu. You can use each app as you see fit for your use case, as described above.

Sure. certbot generates a certificate ready for production, but requires an external domain. dotenv generates a self-signed certificate for development. This one is not intended for production, but can be generated by yourself.

Your web server manages all TLS certificates and stuff. It’s your web application that handles the logic. It is completely independent of whether it is called over HTTP or HTTPS.

You can use either certbot or dotenv, or even openssl to generate a self-signed certificate. The choice is based on what you need a certificate for.

SQL server – Group by unknown ID, select all associated lines where Column X = Y and Column X = Z

I have a table that records user interactions with the following structure.

SELECT (SessionID)
      ,(Question)
      ,(Response)
      ,(DateCreated)
      ,(Terminal)
FROM (Quiz)
where Teminal in ('A1','A2','B1')

Production:

SessionID Question  Response  DateCreated              Terminal
--------- --------- --------- -----------------------  -------
123       Q1        A         2020-02-16 10:10:15.200  A1
123       Q2        A         2020-02-16 10:10:15.560  A1
123       Q3        B         2020-02-16 10:10:16.120  A1
124       Q1        B         2020-02-16 16:01:34.205  A2
124       Q2        B         2020-02-16 16:01:38.999  A2
124       Q3        A         2020-02-16 16:01:44.435  A2
125       Q1        D         2020-02-16 16:02:01.013  B1
126       Q1        A         2020-02-17 07:49:55.098  B1
126       Q2        A         2020-02-17 07:49:57.101  B1

A user reports that he had problems while interacting "the other day", but he can't tell me the date or time, only it was one of these "terminals" (which have been found to be A1, A2 or B1).

They also know that they answered "A" for "Question 1" and also "A" for "Question 2".

Is there there that I can interrogate the original table of "Quiz" (without creating a temporary table) and finish with an output something like the following which gathers the answer to each question in an associated column on a line by SessionID?

SELECT (SessionID)
    ,(Q1)
    ,(Q1DateTime)
    ,(Q2)
    ,(Q2DateTime)
    ,(Q3)
    ,(Q3DateTime)
    ,(Terminal)
FROM Quiz

Production:

SessionID  Q1     Q1DateTime               Q2     Q2DateTime               Q3     Q3DateTime               Terminal
---------  -----  -----------------------  -----  -----------------------  -----  -----------------------  -------
123        A      2020-02-16 10:10:15.200  A      2020-02-16 10:10:15.560  B      2020-02-16 10:10:16.120  A1
124        B      2020-02-16 16:01:34.205  B      2020-02-16 16:01:38.999  A      2020-02-16 16:01:44.435  A2
125        D      2020-02-16 16:02:01.013  null   null                     null   null                     B1
126        A      2020-02-17 07:49:55.098  A      2020-02-17 07:49:57.101  null   null                     B1

Or

SELECT (SessionID)
    ,(Q1)
    ,(Q1DateTime)
    ,(Q2)
    ,(Q2DateTime)
    ,(Q3)
    ,(Q3DateTime)
    ,(Terminal)
FROM Quiz
WHERE Q1 = 'A'
  and Q2 = 'A'


SessionID  Q1     Q1DateTime               Q2     Q2DateTime               Q3     Q3DateTime               Terminal
---------  -----  -----------------------  -----  -----------------------  -----  -----------------------  -------
123        A      2020-02-16 10:10:15.200  A      2020-02-16 10:10:15.560  B      2020-02-16 10:10:16.120  A1
126        A      2020-02-17 07:49:55.098  A      2020-02-17 07:49:57.101  null   null                     B1

$ 9.95 / year, best shared hosting, fast server, truly 24/7 professional support, 99.9% uptime

We are pleased to offer the following affordable shared hosting plan from fullhost.com. Don't worry about anything when you try our service, as we offer full refund within 30 days of service for all new customers

ENTRANCE

Disk space: 1 GB
Bandwidth: 100 GB
Complementary areas: UNLIMITED
FTP accounts: unlimited
MySQL database: unlimited
24/7 assistance
$ 5.95 per 6 months or $ 9.95 per year, use the coupon 50% DISCOUNT (recurrent)
Order link (multiple locations)

STANDARD

Disk space: 2 GB
Bandwidth: 100 GB
Complementary areas: UNLIMITED
FTP accounts: unlimited
MySQL database: unlimited
24/7 assistance
$ 7.95 for 6 months or $ 13.95 per year, use the coupon 50% DISCOUNT (recurrent)
Order link (multiple locations)

If you have any questions, please contact us here

VPS hosting vs reseller vs game server

Hello,

I have thought a lot about our future.
I am already selling web hosting and wondering which would be the cheapest to enter next.

Here are my options:

VPS hosting:

  • Requires a dedicated server which can be expensive
  • Very popular
  • Good profit margins
  • Short but difficult configuration

Reseller Host:

  • Requires a dedicated server
  • Popular
  • Small profit margins
  • Long installation process

Game hosting:

  • Requires dedicated server or VPS
  • Not very popular
  • Large profit margins
  • Short installation process

Tell me what you think.
I know there are other options and I wish you could help me out, but those are the top three topics I have right now.
I deliberately did not put dedicated server hosting in there because it is very expensive and difficult to start.

Thank you!

SQL Server: Help writing a query to obtain an average of 3 sliding months for a table

Up to now:

    select  month,year,vol,
    --sum(vol) over (order by month,year  ROWS BETWEEN 2 PRECEDING AND current row) sumnetvol,
    avg(vol) over ( order by  month,year  ROWS BETWEEN 2 PRECEDING AND current row) '3monthra'
    ,name
    ,cnt
    ,costx  from(SELECT  month(convert(datetime,cast(monthnumber as nvarchar(10))+'01')) as (Month), 
    year(convert(datetime,cast(monthnumber as nvarchar(10))+'01')) as (Year), 
    sum(SumOfNetAmount) as vol,
    count(*) as cnt
    ,costx
    ,name FROM (ngl_OTB) GROUP BY  costx,MONTH(convert(datetime,cast(monthnumber as nvarchar(10))+'01')),YEAR(convert(datetime,cast(monthnumber as nvarchar(10))+'01')),name,SumOfNetAmount) s where costx = '1000.002' and name = 'ngl-raw' order by month,year

I need help on how to recursively define the columns (costx) and (name) to allow a 3 month moving average of each (costx) and (name) correctly. All of the attempts provided incorrect calculations, as 3 month rolling average was bleeding into other costx and names.
My goal is to group all the data by costx and name and order by year and month, then perform a 3 month moving average on each costx using the value of (vol) for that (costx)

Any help will be greatly appreciated

sql server – XA transactions – timeout errors

We recently configured XA transactions according to the document – https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions?view=sql-server-2017

However, the app team is facing the below issues

Performance test 1: XXXX internal users [obtain the XXXX token API] – 3 simultaneous users with three different accounts for a duration of 10 minutes. [04:46 – 04:57 AM EST] – No errors

Performance test 2: XXXX federated users [obtain the XXXX token API] – 3 simultaneous users with three different accounts for a duration of 5 minutes. [05:27 – 05:33 AM EST] – No errors

Performance test 3: federated XXXX users [obtain the XXXX token API] – 3 simultaneous users with 20 different accounts. [05:47 – 05:49:36 AM EST] – Errors have been observed

and the errors said as below
{"error": "org.hibernate.exception.LockAcquisitionException: unable to execute the request"}

{"error": ": unable to acquire the lock after 10 seconds for the key f: 6038d4995878: ptuserfafn375759570511 and requestor GlobalTx: local: 754. The lock is maintained by GlobalTx: local: 732"}

I checked the DPA monitoring tool and found deadlocks and deadlocks between 05:47 – 05:49:36 AM EST. Victim and Survivor execute the same SQL, from the same machine, except for the different Txn / Owner identifier.

System / SQL Server error logs checked and validated, with nothing abnormal.

Any thoughts please?

dedicated windows server | Web Talk Hosting

Hello,

I need to set up a Windows server in October. It will run hotel management software with Remote Desktop and SQL Server. I plan to manage it myself but I haven't found any tutorials on this site. Why There are many for Linux.
I am looking at Hetzner's offers: does it make sense to add a control panel like plesk in my case?

High performance cloud server plans | 100% uptime guarantee | No contracts! | NewProxyLists

HostingSource, Inc. is a leading hosting provider, offering reliable and scalable solutions for clients of all sizes and services. We provide all the servers, software, bandwidth and management tools necessary to run almost any application hosted on the web – server solutions for small businesses.
Our staff has over 20 years of IT experience.

Our team of dedicated professionals, specializing in managed hosting solutions, software development, website design, website marketing, database integration and programming and solutions e-commerce can provide you with the service and support you need to make your online presence a reality.

HostingSource Benefits:
– Business equipment
– Dedicated support 24/7/365
– Bandwidth not measured
– Experienced staff
– 100% uptime guarantee
– Industry leading SLA
– Replacement of equipment 24/7
– No contract, cancel at any time

Save big on hosting – 50% off the 1st month on all Servers / VPS plans.

DISCOVER HostingSource DEDICATED CLOUD – SERVERS (SSD storage):

Xeon E5 2670 – 4-core CPU
RAM – 8 GB
SSD storage – 100 GB – SSD (H / W RAID – 1)
Transfer – 10 TB
Price – $ 29 / month (1st month reduced price – $ 14.5 / month)
== >>> ORDERED

Xeon E5 2670 – 8-core processor
RAM – 12 GB
SSD storage – 150 GB – SSD (H / W RAID – 1)
Transfer – 15 TB
Price – $ 39 / month (1st month reduced price – $ 19.5 / month)
== >>> ORDERED

Xeon E5 2670 – 12-core processor
RAM – 16 GB
SSD storage – 200 GB – SSD (H / W RAID – 1)
Transfer – 20 TB
Price – $ 59 / month (1st month reduced price – $ 29.5 / month)
== >>> ORDERED

Xeon E5 2670 processor – 16 cores (Includes one year FREE domain!
RAM – 24 GB
SSD storage – 250 GB – SSD (H / W RAID – 1)
Transfer – 25 TB
Price – $ 79 / month (1st month reduced price – $ 39.5 / month)
== >>> ORDERED

DISCOVER HostingSource SINGLE CPU – SERVERS (optional SSD storage):
All plans include one year FREE domain!

Dedicated server – Intel I5 (4590) – 4-core CPU
RAM: 16 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 20 TB
Price – $ 75 / month (1st month reduced price – $ 37.5 / month)
== >>> ORDERED

Dedicated server – Intel I7 (4790) – 4-core CPU
RAM: 16 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 25 TB
Price – $ 95 / month (1st month reduced price – $ 47.5 / month)
== >>> ORDERED

Dedicated server – Intel I7 (4790k) – 4-core CPU
RAM: 24 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 30 TB
Price – $ 109 / month (1st month reduced price – $ 54.5 / month)
== >>> ORDERED

Dedicated server – Xeon E3 1245v2 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 129 / month (1st month reduced price – $ 64.5 / month)
== >>> ORDERED

Dedicated server – Xeon E3 1275v2 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 149 / month (1st month reduced price – $ 74.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1620 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 169 / month (1st month reduced price – $ 84.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1650 – 6-core CPU
RAM: 48 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 189 / month (reduced price for the first month – $ 94.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1660 – 6-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 209 / month (1st month reduced price – $ 104.5 / month)
== >>> ORDERED

DISCOVER HostingSource MULTI CPU – SERVERS (optional SSD storage):
All plans include one year FREE domain!

Dedicated server – Dual Xeon X5660 – 12-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 229 / month (1st month reduced price – $ 114.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 12-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 259 / month (1st month reduced price – $ 129.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 16-core CPU
RAM: 128 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 299 / month (1st month reduced price – $ 149.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 16-core CPU
RAM: 256 GB
Storage (H / W RAID-10): 2 TB – SAS
Traffic / month: not measured
Price – $ 339 / month (1st month reduced price – $ 169.5 / month)
== >>> ORDERED

DISCOVER HostingSource STORAGE – SERVERS:
All plans include one year FREE domain!

Storage servers – Core I5 ​​Quad Core 3.4 GHz Intel processor, 6 TB (Raid1)
RAM: 8 GB; Storage: 6 TB (Raid1); Traffic / month: not measured
Price – $ 199 / month
== >>> ORDERED

Storage Servers – Core i7 Quad Core Intel 4.0 GHz, 12 TB (Raid10)
RAM: 16 GB; Storage: 12 TB (Raid10); Traffic / month: not measured
Price – $ 299 / month
== >>> ORDERED

Storage servers – Core i7 Quad Core Intel 4.0 GHz, 18 TB (Raid10)
RAM: 24 GB; Storage: 18 TB (Raid10); Traffic / month: not measured
Price – $ 399 / month
== >>> ORDERED

Storage Servers – Core i7 Quad Core Intel 4.0 GHz, 24 TB (Raid10)
RAM: 32 GB; Storage: 24 TB (Raid10); Traffic / month: not measured
Price – $ 449 / month
== >>> ORDERED

FOR MORE DETAILS, CHECK: http://www.hostingsource.com/dedicated-servers/

HostingSource, Inc., is committed to providing our customers with the highest level of service and support. We are also committed to serving future customers by responding quickly to sales or requests for information.
Please contact us at your convenience via the methods listed below:
– If you have any questions, don't hesitate to call us toll free: 1-888-586-1101
– Sales Department – For all sales requests or non-technical questions.
– Technical support department – Technical support available 24 hours a day, 7 days a week.
– Support FAQs – Use our in-depth knowledge base for additional advice. It is a great way to learn how to refine your website, improve your service and more.

High performance cloud server plans | 100% uptime guarantee | No contracts!

HostingSource, Inc. is a leading hosting provider, offering reliable and scalable solutions for clients of all sizes and services. We provide all the servers, software, bandwidth and management tools necessary to run almost any application hosted on the web – server solutions for small businesses.
Our staff has over 20 years of IT experience.

Our team of dedicated professionals, specializing in managed hosting solutions, software development, website design, website marketing, database integration and programming and solutions e-commerce can provide you with the service and support you need to make your online presence a reality.

HostingSource Benefits:
– Business equipment
– Dedicated support 24/7/365
– Bandwidth not measured
– Experienced staff
– 100% uptime guarantee
– Industry leading SLA
– Replacement of equipment 24/7
– No contract, cancel at any time

Save big on hosting – 50% off the 1st month on all Servers / VPS plans.

DISCOVER HostingSource DEDICATED CLOUD – SERVERS (SSD storage):

Xeon E5 2670 – 4-core CPU
RAM – 8 GB
SSD storage – 100 GB – SSD (H / W RAID – 1)
Transfer – 10 TB
Price – $ 29 / month (1st month reduced price – $ 14.5 / month)
== >>> ORDERED

Xeon E5 2670 – 8-core processor
RAM – 12 GB
SSD storage – 150 GB – SSD (H / W RAID – 1)
Transfer – 15 TB
Price – $ 39 / month (1st month reduced price – $ 19.5 / month)
== >>> ORDERED

Xeon E5 2670 – 12-core processor
RAM – 16 GB
SSD storage – 200 GB – SSD (H / W RAID – 1)
Transfer – 20 TB
Price – $ 59 / month (1st month reduced price – $ 29.5 / month)
== >>> ORDERED

Xeon E5 2670 processor – 16 cores (Includes one year FREE domain!
RAM – 24 GB
SSD storage – 250 GB – SSD (H / W RAID – 1)
Transfer – 25 TB
Price – $ 79 / month (1st month reduced price – $ 39.5 / month)
== >>> ORDERED

DISCOVER HostingSource SINGLE CPU – SERVERS (optional SSD storage):
All plans include one year FREE domain!

Dedicated server – Intel I5 (4590) – 4-core CPU
RAM: 16 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 20 TB
Price – $ 75 / month (1st month reduced price – $ 37.5 / month)
== >>> ORDERED

Dedicated server – Intel I7 (4790) – 4-core CPU
RAM: 16 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 25 TB
Price – $ 95 / month (1st month reduced price – $ 47.5 / month)
== >>> ORDERED

Dedicated server – Intel I7 (4790k) – 4-core CPU
RAM: 24 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: 30 TB
Price – $ 109 / month (1st month reduced price – $ 54.5 / month)
== >>> ORDERED

Dedicated server – Xeon E3 1245v2 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 129 / month (1st month reduced price – $ 64.5 / month)
== >>> ORDERED

Dedicated server – Xeon E3 1275v2 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 149 / month (1st month reduced price – $ 74.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1620 – 4-core CPU
RAM: 32 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 169 / month (1st month reduced price – $ 84.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1650 – 6-core CPU
RAM: 48 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 189 / month (reduced price for the first month – $ 94.5 / month)
== >>> ORDERED

Dedicated server – Xeon E5 1660 – 6-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 1 TB
Traffic / month: not measured
Price – $ 209 / month (1st month reduced price – $ 104.5 / month)
== >>> ORDERED

DISCOVER HostingSource MULTI CPU – SERVERS (optional SSD storage):
All plans include one year FREE domain!

Dedicated server – Dual Xeon X5660 – 12-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 229 / month (1st month reduced price – $ 114.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 12-core CPU
RAM: 64 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 259 / month (1st month reduced price – $ 129.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 16-core CPU
RAM: 128 GB
Storage (H / W RAID-1): 2 TB – SAS
Traffic / month: not measured
Price – $ 299 / month (1st month reduced price – $ 149.5 / month)
== >>> ORDERED

Dedicated server – Dual Xeon E5-2670 – 16-core CPU
RAM: 256 GB
Storage (H / W RAID-10): 2 TB – SAS
Traffic / month: not measured
Price – $ 339 / month (1st month reduced price – $ 169.5 / month)
== >>> ORDERED

DISCOVER HostingSource STORAGE – SERVERS:
All plans include one year FREE domain!

Storage servers – Core I5 ​​Quad Core 3.4 GHz Intel processor, 6 TB (Raid1)
RAM: 8 GB; Storage: 6 TB (Raid1); Traffic / month: not measured
Price – $ 199 / month
== >>> ORDERED

Storage Servers – Core i7 Quad Core Intel 4.0 GHz, 12 TB (Raid10)
RAM: 16 GB; Storage: 12 TB (Raid10); Traffic / month: not measured
Price – $ 299 / month
== >>> ORDERED

Storage servers – Core i7 Quad Core Intel 4.0 GHz, 18 TB (Raid10)
RAM: 24 GB; Storage: 18 TB (Raid10); Traffic / month: not measured
Price – $ 399 / month
== >>> ORDERED

Storage Servers – Core i7 Quad Core Intel 4.0 GHz, 24 TB (Raid10)
RAM: 32 GB; Storage: 24 TB (Raid10); Traffic / month: not measured
Price – $ 449 / month
== >>> ORDERED

FOR MORE DETAILS, CHECK: http://www.hostingsource.com/dedicated-servers/

HostingSource, Inc., is committed to providing our customers with the highest level of service and support. We are also committed to serving future customers by responding quickly to sales or requests for information.
Please contact us at your convenience via the methods listed below:
– If you have any questions, don't hesitate to call us toll free: 1-888-586-1101
– Sales Department – For all sales requests or non-technical questions.
– Technical support department – Technical support available 24 hours a day, 7 days a week.
– Support FAQs – Use our in-depth knowledge base for additional advice. It is a great way to learn how to refine your website, improve your service and more.