Tag Info

New answers tagged

0

I have spent 5 days to understand why the variables have_openssl was always set to disable. The reason is that the server can't read the certificates (I don't know why) in every directory I've tried to put that. The only directory that work for me is the one that contain the file my.ini ( C:\programData\mySql ). The solution is to copy the certificates in ...


0

As I mentioned in the comment, I installed MySQL 5.6.24 for Windows. I have a 4-year-old post in ServerFault (Installing isolated instance of MySQL on Windows using silent install with .msi) I outline how to install MySQL as a service by hand with Custom Folder for MySQL Binaries Custom Folder for MySQL Data Custom Name for MySQL Service I also have ...


3

I would like to know if it is possible to share the structure and data between the two systems without duplicating and/or having to copy everything each time I load a new OS. Effectively, I would like all the data to be available to Ubuntu when it is created in Windows, and vice versa. You can't. Just not supported, not possible. No can do. PostgreSQL ...


1

You can run a query similar to the following that will show the number of reads and writes for files since SQL Server started. Change the number in line 6 to get stats for different databases. 1 = master, 2 = tempdb, 3 = model, etc. 5 and up will be for your user databases. SELECT files.physical_name, files.name, stats.num_of_writes, ...


0

If the crux of the question is, "How do I get correct data to size my storage subsystem?" and you want to it fairly repeatedly across many servers, use windows performance counters. Here is the list I would minimally have: Logical Disk(*)\Current Disk Queue Length Logical Disk(*)\Disk Read Bytes/Sec Logical Disk(*)\Disk Reads/Sec Logical Disk(*)\Disk Write ...


0

I had a key in this registry path that was not pointing to anything. So I removed it. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI (this is the 64 bit window that pops up) Realize that there is also a 32 bit window for ODBC that exists for this registry path: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI C:\Windows\SysWOW64\odbcad32.exe (Yes, ...


0

Yes, you will need Oracle Advanced Security to be installed. See http://docs.oracle.com/cd/E25054_01/network.1111/e10746/asointro.htm#i1008433 However a license for Oracle Advanced Security is no longer needed with 11g Release 2, but you will apparently need a license for "Oracle Identity Management Directory Services Plus". See PDF page 10 of ...


0

The problem has something to do with permissions on the underlying server and not SSIS or the MSDB. We had the same problem. Temporarily adding the user's AD account to the local administrators group fixed this for us. Adding their AD account to PowerUsers or Users did not; however, I am certain that we could have found what was missing in the Local Security ...


0

OK, I posted a link to my compiled Slony 2.2.4 for Windows 64-bit under postgres 9.3.6. However, it was deleted I'm assuming because people may not trust my compile. Hence, here's the link to the Slony-I site with the instructions that I followed to compile Slony. It's section 3.1.6. Building on Win32 ...



Top 50 recent answers are included