 |
| At CodeProject we spend an awful lot of time playing with room heaters, or as others like to call them, "servers". Over the years we've seen it all, some of it smoking, most of it usually working just nicely until something happens.
What that something is can be hard to find so we've created a quiet place for those battle scarred and frustrated to get a little help.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
| I need to move a set of databases from a Windows 2008r2 server to a new Windows 2012 database server. I have looked at several articles but have not found the best one listing all of the complete steps in doing this the in a way that seems to have the complete process. Can someone direct me to a good article for me to follow in doing this?
|
|
|
|
| holdorf wrote: I have looked at several articles but have not found the best one listing all of the complete steps in doing this the in a way that seems to have the complete process
SQL Server 2012 Upgrade Technical Guide[^] from MSDN. Won't be "complete" in the sense that it will provide steps on how to proceed for each possible scenario.
Bastard Programmer from Hell  If you can't read my code, try converting it here[^]
|
|
|
|
| Backup, copy, restore. What's the issue?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
| I understand what your saying about it being very easy but the main issue is we are creating a 200Rr2 server from scratch and want to ensure everything is done right. This includes server setup, settings, etc.
|
|
|
|
| holdorf wrote: server from scratch and want to ensure everything is done right. This includes server setup, settings, etc.
There is no way to know without doing it. I assume you are also upgrading SQL from 2008 to 2012? If so, it depends on if you are using anything in sql 2008 that is no longer supported in sql 2012.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
| Thank you for your advise. I will look further into our situation and try to get a better understanding of all of the moving parts before we even start with the database copying.
|
|
|
|
| Hello!
Suppose you purchase a piece of server software and install it on a machine. Now, ideally I would like to tie it to the underlying machine, but it may not be a machine at all, it may be a VM.
Now, if you want to start up a second instance, I want to ensure that you are paying for that second instance.
Because of this, I need to find a way to distinguish them even though the underlying hardware may be the same.
I thought of using the PC name, but even that may be problematic because I can't be totally sure that *ALL* cloud vendors (hence, not just the VM vendors, but also their customers who, in turn, become sellers to my customers) will allow to change it.
Suggestions?
Thanks!
A
|
|
|
|
| Hey
The common way to implement such a thing is using some unique data from the server to identify it.
For example, you can check the server MAC address when your software start, send it to your management server and find out if this server allowed to run your software or not.
You can also check if there more than one server with this MAC address, so on, but this is just an example nothing more.
Most software using this principle but real implementation can vary.
|
|
|
|
| I'm a freelance, junior sys-admin who is currently tasked with setting up the hardware for a tech startup. We're hosting a software service and need a system solution that makes sense within our budget and requirements.
The ideal goal would be n + 1 design, high security, long-term high availability without breaking the bank. Budget is ~6k for initial round of investment towards gear only. Additionally funds will be allocated for a year of quarter rack space in a datacenter local to my location.
I'm a bit over my head with my current knowledgebase, and intend to bridge the gap with a lot of pre-planning over the next 60 days. I figure 60 days before ordering any gear, 30 days to have it all come in, and get it initially configured at the datacenter, then 90 days to build out our hosting interface and properly test the system before going production. 6 months would be nice, but 8 months is being allocated for project.
Okay, so onto the gear and setup:
(2) Cisco SG-300-10 Switches, 1 wired & active, the second rack-mounted ready for wiring in case of failure.
PFSense:
Primary <> Secondary
With heartbeat in load-balancing + fail-over mode
Nginx Load-Balancers:
Primary <> Secondary
Configured in PFsense for failover
App/Data Servers:
A 4:1 ratio of active to failover App/Data Servers. I think failover can be configured with the Nginx Load-Balancer else PFsense.
Initial deployment is the two firewalls, two LBs, and 4+1 App/Data servers, with expectations to grow more App/Data as demand increases.
The service runs on LEMP stack. A master to master MySQL link between each A/D and the failover exists on separate partitions, separate instances of MySQL. It continuously synchs database with each active A/D, ready for activation in the event a LB declares an active dead. Higher resources in the form of more memory, higher thread count CPU, and n(A/D) hard disk space is allotted for failover.
Additionally, I plan to use an Anycast DDos prevention serviced by my colocation provider. I am wondering what drawbacks there are to my model.
The first 3-4 months is designing and deploying the system, the next 3-4 is linking the system to the software with the developers so that we can auto-provision services. I plan to utilize scripts heavily for this.
modified 19-Mar-16 13:45pm.
|
|
|
|
| Hi,
Scenario: There are two isolated networks A and B with systems and applications (all Windows environment)
Network A
- Client AC1
- Server AS1
Network B
- Server BS1
"AC1" initiates a VPN-like connection and connects to Network B.
"AC1" then connects to a web application hosted on "BS1"
"BS1" in turn needs to connect to a Web Service hosted in "AS1" using Network A credentials of user on "AC1".
Is this possible? What do we need to ask the Network team of A and B to do in order to achieve this?
Thanks in advance.
|
|
|
|
| Should be easily do-able via tunneling. VPN on AC1 alone won't get your BS1 server a good route back to AS1. If it's a simple web service that doesn't require a lot of security, you could always give AS1 a real internet addressable address (from your ISP) and BS1 can access AS1 web service over the web. The thing about web services is that they typically aren't blocked by firewalls, but you still need to have an IP address facing the internet for AS1.
|
|
|
|
|
| There is a good discussion on how to configure a reverse VPN tunnelling. Look like connecting back to the system is complicated issue. The essence of your problem is that even you can do the DNS registration (which makes eligible for the servers to find each other), the actual ip connection between your machines is further impossible.
|
|
|
|
| Message Removed
modified 29-Jan-16 12:03pm.
|
|
|
|
| It depends what you need or want from your server. And, btw, a third option "between" these two, is a Virtual Private Server (VPS) which, IMO, is as good a dedicated server (but much cheaper) unless your site is particularly large (or attracts lots of traffic) or resource heavy.
But the main advantage of a VPS or dedicated server is that you have full (virtual) control over the server, so can configure it as you want - obviously only an advantage if there is something particular you need to configure - and that you can also install and run your own programs (exe's) in the background to perform all sorts of related tasks.
|
|
|
|
| I need to discover the IP address of a specific Ethernet switch on my LAN. What tool must I use for this?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
| I first thought of SNMP, but that's obviously wrong (you need to know the tcp/ip address before you can query a device about its abilities) ... SNMP does have a discovery process, but Im not sure how it works
.. then I remembered that ICMP has/had a 'sub protocol' for router discovery .. and tippity tap, https://tools.ietf.org/html/rfc1256[^]
not sure if either of those will serve as a starting point for you .....
|
|
|
|
| Thank you. I looked at the page you link to, but it seems to be only for router discovery. I would like to discover a switch.
I did find a number of tools for network enumeration at Network Enumerators - securitywizardry.com[^], but I don't know what tool is good for what.
Are you able to recommend any of them?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
| I'd have a look at SolarWinds NPM Network Monitoring Software - Network Monitor | SolarWinds[^] - it has a discovery tool - but cheap it is not  I only know of them because I used to use KiwiSyslog a toolset they bought
(I used to have a discovery tool based on WNETEnum ... that fed the data to Visio to draw, but have log lost where I put it - it was a DDJ tool, and I cant recall if it did switches or just 'anything ip')
Check out SPLUNK while you're at it and see if it does discovery
|
|
|
|
| Thank you Garth, I appreciate it. 
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
| I dont know if you found anything useful .. I found the original article I thought of (but it only does PC's, Printers etc) Visualizing Network Resources Using Visio | Dr Dobb's[^]
Im not sure what your motivation is Richard - if you were being paid, and had to write a tool (that was cheaper than SolarWinds for example), Im sure you could gather a list of all the tcp/ip addresses on your network, and then reduce/filter the list perhaps (eg remove PC's, printers ...) , leaving a list of addresses you could then issue SNMP calls against (for instance) ... thats what I would do
|
|
|
|
| Depends on the switch.
Normally I would use a tool from the manufacturer.
Otherwise you would use a tool that implements LLDP (Link Layer Discovery Protocol) for low level switches, unless it's a Cisco, they have their own protocol (CDP).
If it's a high level switch SNMP should suffice.
|
|
|
|
| Thank you.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
| I think this will ease out the problem, let me try this. Thank you
|
|
|
|
| Message Automatically Removed
|
|
|
|
|
| hi..everyone..i want to install ]project open[ version 4 on fedora server.can anyone tell me what are the exact procedure/steps to install it from scratch..any help would be appreciated..
|
|
|
|
|
| a. I have a Sony Vaio Notebook with a nearly full 256GB SSD drive, 8GB Ram - its seems like its quick to overheat and shuts itself down frequently, especially if there's a lot of network traffic
b. I have a MacBook Pro, 15", 500GB SSD
c. I cant afford to purchase a new system (Windows or Mac) AND I'd like to migrate the 'content' off the Sony Vaio
My plan/thoughts goes something like this
- Upgrade the SSD in the Macbook Pro to 2TB
- Install Mac Parallels on the MacBook Pro
- Import the Sony Vaio as a VM onto the MacBook Pro (yeah, its going to be a mutha of a VM)
- If the 'Vaio VM' is usable, good, if not, continue
- Create a new Windows 7 VM on the MacBook under Parallels (maybe on an external drive), Install VS 2015 Onto it (the Sony Vaio only has VS2010 on it)
If I can get past step (3), my big worry is if Parallels can actually handle a VM that size
Any thoughts ? or do I download the 14 day trial of Parallels and 'jfgowi' (just freaken get on with it)
|
|
|
|
| I don't have a Mac, but a quick Google shows a lot of results for using large VM images. Most VM software can support VMs of >= 1TB, so I don't think it will be a problem.
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
| cheers - Im on pain meds for a back issue at the moment, its affecting my google-fu 
|
|
|
|
| I hope you feel better soon! One of my friends has a Hyper-V VM with a 64 TB drive and it works fine (he is using a RAID system to store it). I don't know what he has on it, but I do know it is about half full.
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
| I don't do Mac, but a previous coworker swore by Parallels. He had a Mac with Ubuntu and Windows VMs, that's how he did all his work.
|
|
|
|
| lately since I did a code release for a Webforms project running on Server Core 2012 IIS, I've been getting a much larger number of these errors.
Most of them come from bots and crawlers, but a majority are coming from lets say Android phones from Sprint.
I did the machine key in the web config, really didn't make a difference.
The errors are on embedded scripts and images in a DLL. I can see now that there coming from encypted pages, SSL pages. Hmm?
I've been getting reports of users being kicked out when this error occurs on mobile phones.
Request information: Request URL: https: Exception information: Exception type: HttpException Exception message: Unable to validate data. at System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Boolean useValidationSymAlgo, Boolean useLegacyMode, IVType ivType, Boolean signData) at System.Web.UI.Page.DecryptString(String s, Purpose purpose) at System.Web.Handlers.AssemblyResourceLoader.System.Web.IHttpHandler.ProcessRequest(HttpContext context)
|
|
|
|
| I have installed SQL server 2008 R2 and I have created databse engine instance. I am configuring mail setup. What should be in the field of server name? I am new to this and don't know what to put there. Please help me out.
|
|
|
|
| The name of your SMTP server that will be used to send the mail
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
| On New Database Mail Account screen, for Server Name specify your SMTP Server name like
Hotmail: SMTP server name: smtp.live.com, Port number: 587
Gmail : SMTP server name: smtp.gmail.com, Port number: 587
Yahoo : SMTP server name: smtp.mail.yahoo.com,Port number : 25
AOL : SMTP server name: smtp.aol.com, Port number : 587
The server requires a secure connection (SSL) - check this box
|
|
|
|
| Here's what's going on...
- I have 18 URLs with approaching renewal dates at GoDaddy
- Prices range from $9 to $20 depending on the top level domain
- The prices seemed inconsistent to me; fred.info had a different price from barney.info
- Called a couple of other places
- Domain.Com[^] seemed to have better prices
GoDaddy wants me to (but is not requiring me to) renew for 2 years on each name.
The total is about $510 (five hundred, ten dollars) for the two year package.
The average price works out to a little over $14 per domain name. (I think it's $14.14)
Is it time to stick with the same place I've been for five or ten years, or jump ship ?
|
|
|
|
| At home I got Windows 10 Pro.
I also have Hyper V with a few virtual machines, including another (virtual) Windows 10 (pro) machine.
I am trying to share file between the two! Doesn't work!
My VM use an External (Virtual) Network switch
On my local (real) PC I have a file share available to everybody (read/write access).
On my VM, in the file explorer > network, I can see my (real) PC, but I can't open the file share!!
Any idea how to progress from there?! 
|
|
|
|
| OK.. so I have an application built on the .NET 2.0 framework with a MySQL database which needs to run on a 64-bit Windows 2008 Server (with service Pack 1)
After installing it, in order to get it to run, I have to go to the application pools in IIS, find the relevant one, click on Advanced Settings, and set "Enable 32-bit applications" to True.
That works - otherwise I get a "Server Error in '/' Application. ... is not a valid Win32 application" page.
Trouble is though, as soon as I do set this, while simple pages display al;right, as soon as I get to one that requires database access I get this error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
If I set "Enable 32-bit applications" to False, I can run a simple test page that access tha database (uncompiled, with inline server code) and this works fine - so the connector is working adn the connectionstring correct.
All of which kind of leaves me between a rock and hard place. Any ideas gratefully received!
|
|
|
|
| You've created an ODBC data source using the 64-bit version of the ODBC Administrator tool. You need to create it in the 32-bit version of the tool, which is located at: %SystemRoot%\SysWOW64\odbcad32.exe
Data Source Names and 64-Bit Operating Systems[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
| I have no idea how to even do that... I ahve never "created an ODBC data source" in my life. All I do is add some code to create it in my asp.net code behind, then assign it a connectionstring "Provider=MSDASQL;Driver={MySQL ODBC 5.1 Driver};server=localhost;database=xxx;uid=xxx;pwd=xxx"
|
|
|
|
| Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC.
When I tried to connect through ODBC driver GUI, I get [Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)] error.
On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.).
But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ?
Thank you.
|
|
|
|
| You have to check with the hosting services in what way MySQL configured...You have two main options...
1. MySQL accessible only from applications running on the hosted server...
2. MySQL made public and you can use it from the outside world...
In my experience it is always the first option you get...
But! also in this case you can access your data from outside, by adding a layer - of some API - of software to it...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
| I doubt I that have these options (1 and 2) on my CPanel ... I have to check it, though ...
|
|
|
|
| If it is a hosted database that comes with one of the website-packages, then it won't work. There's a firewall preventing connections from the outside.
Bastard Programmer from Hell If you can't read my code, try converting it here[^]
|
|
|
|
| I think you are right ...
|
|
|
|
| Can you connect to the database with other than your project? i.e. MySQL workbench or putty?
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
| I only have tried to connect to DB by ODBC driver GUI ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip 
