Problem:
You deploy a fortigate-vm and apply correct licence. After firewall restart, you try to login and receive the following message:
Solution:
Applied to: Fortigate-VM
To resolve it try login on CLI and execute command “execute update-now”
Best Regards,
ITquadro consulenti informatici specializzati in ambienti VMware vCloud Director. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
INSERT INTO databasename.TargetTable (column_list) SELECT column_list FROM databasename.SourceTable
INSERT INTO newproject.content (desc,author,`fulltext`) SELECT desc,author,`fulltext` FROM oldproject.content
If you have fulltext field in your column_list, you have to use the quote (`fulltext`) otherwise you meet a mysql error.
Well done!
Best Regards,
ITquadroBlog
ITquadro sistemisti specializzati su Bologna ed Emilia-Romagna esperti in installazione e configurazione di MySQL ed apache su distribuzioni basate su Debian, CentOS, ecc
SHOW TABLE STATUS FROM `DatabaseName` LIKE 'TableName' ;
Well done!
Best Regards,
ITquadroBlog
ITquadro sistemisti specializzati su Bologna ed Emilia-Romagna esperti in installazione e configurazione di MySQL ed apache su distribuzioni basate su Debian, CentOS, ec
Applied to: fortigate 40c and others.
If Log hard disk: Need format
fortigate # execute formatlogdisk
Then enable logging
fortigate # config log disk setting
fortigate (setting) # set status enable
fortigate (setting) # end
Best Regards,
ITquadro consulenti informatici specializzati in reti di computer microsoft windows server 2008 R2 e Microsoft Windows Server 2012. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
Siamo un’azienda di consulenza informatica a Bologna
Problem:
How to kill all processes on Microsoft SQL Server database ?
Solution:
Applied to: Microsoft SQL Server
Execute the follow query on master database and change ‘MyDB’ with your DB:
DECLARE @kill varchar(8000) = ”;
SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), spid) + ‘;’
FROM master..sysprocesses
WHERE dbid = db_id(‘MyDB’)
EXEC(@kill);
Best Regards,
ITquadro consulenti informatici specializzati in ambienti microsoft windows server 2008 R2 e Microsoft Windows Server 2012. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
Siamo un’azienda di consulenza informatica a Bologna
http://kb.vmware.com/kb/2051575
|
Port
|
Protocol
|
Description
|
|
80
|
TCP
|
vCenter Server requires port 80 for direct HTTP connections. Port 80 redirects requests to HTTPS port 443. This redirection is useful if you accidentally use http://server instead of https://server.
Note: Microsoft Internet Information Services (IIS) also use port 80. For more information, see theConflict Between vCenter Server and IIS for Port 80 section in the vSphere Installation and Setup guide.
|
|
88
|
TCP
|
vCenter Single Sign-On – VMware Kdc Service |
|
389
|
TCP/UDP
|
This port must be open in the local and all remote instances of vCenter Server. This is the LDAP port number for the Directory Services for the vCenter Server group. The vCenter Server system needs to bind to port 389, even if you are not joining this vCenter Server instance to a Linked Mode group. If another service is running on this port, it might be preferable to remove it or change its port to a different port. You can run the LDAP service on any port from 1025 through 65535.
If this instance is serving as the Microsoft Windows Active Directory, change the port number from 389 to an available port from 1025 through 65535.
|
| 443 | TCP | The default port that the vCenter Server system uses to listen for connections from the vSphere Client. To enable the vCenter Server system to receive data from the vSphere Client, open port 443 in the firewall.
The vCenter Server system also uses port 443 to monitor data transfer from SDK clients. This port is also used for the these services:
|
|
636
|
TCP
|
This is the SSL port of the local instance for vCenter Server Linked Mode. If another service is running on this port, it might be preferable to remove it or change its port. You can run the SSL service on any port from 1025 through 65535.
|
|
902
|
TCP/UDP
|
This is the default port used by the vCenter Server system to send data to managed hosts. Managed hosts also send a regular heartbeat over UDP port 902 to the vCenter Server system. This port must not be blocked by firewalls between the server and the hosts or between hosts.
|
| 903 | TCP | Access a virtual machine console from the vSphere Client when the vSphere Client is connected directly to the ESXi host (no vCenter Server). |
|
2012
|
TCP
|
vCenter Single Sign-On – VMware Directory Service |
|
2013
|
TCP
|
vCenter Single Sign-On – VMware Kdc Service |
|
2014
|
TCP
|
vCenter Single Sign-On – VMware Certificate Service |
|
8080
|
TCP
|
Web Services HTTP. Used for the VMware VirtualCenter Management Web Services.
|
|
8443
|
TCP
|
Web Services HTTPS. Used for the VMware VirtualCenter Management Web Services.
|
|
60099
|
TCP
|
Web Service change service notification port
|
|
6501
|
TCP
|
Auto Deploy service
|
|
6502
|
TCP
|
Auto Deploy management
|
|
7080
|
TCP
|
vCenter Single Sign-On HTTP Port
|
| 7331 | TCP |
vSphere Web Client – HTML5 Remote Console
|
|
7343
|
TCP
|
vSphere Web Client – HTML5 Remote Console, HTTPS (vCenter 5.5 Update 2 and later)
|
|
7444
|
TCP
|
vCenter Single Sign-On – VMware Secure Token Service
|
|
9443
|
TCP
|
vSphere Web Client HTTPS
|
| 9875 – 9877 | TCP | vSphere Web Client Java Management Extension (JMX). Dynamically acquired upon the vSphere Web Client service starting. |
|
9090
|
TCP
|
vSphere Web Client HTTP
|
|
10080
|
TCP
|
vCenter Inventory Service HTTP
|
|
10109
|
TCP
|
vCenter Inventory Service Management
|
|
10111
|
TCP
|
vCenter Inventory Service Linked Mode Communication
|
|
10443
|
TCP
|
vCenter Inventory Service HTTPS
|
| 11711 |
TCP
|
vCenter Single Sign-On – VMware Directory Service (LDAP)
|
| 11712 |
TCP
|
vCenter Single Sign-On – VMware Directory Service (LDAPS)
|
| 12721 |
TCP
|
vCenter Single Sign-On – VMware Identity Management Service
|
| 49000 – 65000 |
TCP
|
vCenter Single Sign-On – VMware Identity Management Service. Dynamically acquired upon the VMware Identity Management Service starting.
|
| 8190 |
TCP
|
Storage Policy Server HTTP |
| 8191 |
TCP
|
Storage Policy Server HTTPS |
| 22000 |
TCP
|
vCenter Server Storage Monitoring Service HTTP |
| 22100 |
TCP
|
vCenter Server Storage Monitoring Service HTTPS |
| 21000 |
TCP
|
VMware vSphere Profile-Driven Storage Service HTTP |
| 21100 |
TCP
|
VMware vSphere Profile-Driven Storage Service HTTPS |
| 12443 |
TCP
|
Log Browser |
Problem:
How to view the password of a known Wi-Fi network
Solution:
Applied to: Microsoft Windows 8.1
Once you connect to a Wi-Fi network, Windows will automatically save the password, so that you don’t have to enter it at each connection.
Best Regards,
ITquadro consulenti informatici specializzati in ambienti microsoft windows server 2008 R2 e Microsoft Windows Server 2012. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
Siamo un’azienda di consulenza informatica a Bologna
Problem:
How to calculate page file size
Solution:
Applied to: Microsoft Windows Server 2008 R2 and 2012
http://support.microsoft.com/kb/889654
Use one or more of the following methods to help you calculate page file size.
Use the log that you collect during typical computer use to understand the paging activity on your computer. Then, adjust the page file size accordingly.
To determine the approximate minimum page file that is required by your system, calculate the sum of peak private bytes that are used by each process on the system. Then, subtract the amount of memory on the system.
To determine the approximate maximum page file space that is required for your system, calculate the sum of peak private bytes that are used by each process on the system. Then, add a margin of additional space. Do not subtract the amount of memory on the system. The size of the additional margin can be adjusted based on your confidence in the snapshot data that is used to estimate page file requirements.
Note This estimate is accurate only if the snapshot of data that is used to make the calculations is accurate.
Best Regards,
ITquadro consulenti informatici specializzati in ambienti microsoft windows server 2008 R2 e Microsoft Windows Server 2012. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
Siamo un’azienda di consulenza informatica a Bologna
Problem:
SCRIPT438: Object doesn’t support property or method ‘preventDefault’
Solution:
Applied to: Internet Explorer 9 and Internet Explorer 10 (but it’s similar for the other).
Put the following instructions on your javascript code:
if (e.preventDefault) {
e.preventDefault();
} else {
e.returnValue = false;
}If you need more information look on microsoft website (http://msdn.microsoft.com/en-us/library/ie/ms534372(v=vs.85).aspx)
Best Regards,
ITquadro consulenti informatici specializzati in ambienti microsoft. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.
Siamo un’azienda di consulenza informatica a Bologna
Solution:
Applied to: Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 (but it’s similar for the other).
To reset auto incremental field in SQL Server you have to execute the following query:
DBCC CHECKIDENT (mytable, RESEED, 0)Best Regards,
ITquadro consulenti informatici specializzati in ambienti microsoft sql server. Ci trovate su Bologna ed Emilia-Romagna ma anche su Milano e Roma.