-
Created Running Apache Tomcat behind a IIS reverse proxy with SSL termination
Hello Havent been here in a while but might as well give it a shot. I have several Apache Tomcat instances running on a Windows Server on different ports. They … -
Replied To a Post in Script that mounts and checks if a file has been modified
#!/bin/sh # How many seconds before file is deemed "older" # 86400 = 1 day # 172800 = 2 days FILENAME=$1 WARNTIME=$2 CRITTIME=$3 # Get current and file times CURTIME=$(date … -
Replied To a Post in Script that mounts and checks if a file has been modified
Bash would be fine -
Gave Reputation to rproffitt in Script that mounts and checks if a file has been modified
While your tags including linux the specific shell wasn't called out. So for you to proceed you'd have to find which shell you want to write for as not all … -
Created Script that mounts and checks if a file has been modified
First, it has been a LONG time since Ive been here. Good memories from when I was young. Anyways In a monitoring system I have, I had a plugin that … -
Created Where is the section to post code snippets?
Where is the section to post code snippets? -
Replied To a Post in Write out a DXF file in Delphi?
I see...not exactly what I was looking for but... -
Created Write out a DXF file in Delphi?
I want to write out a DXF file with line arc and maybe spline. My issue is documentation; While I have looked at AutoCAD's site I feel that there isnt … -
Replied To a Post in Access the description of a security group of Active Directory?
Helps 0 with modifying the code I have -
Replied To a Post in Shell script that looks for the two oldest files and deletes them
None of these links really help out with the code. -
Created Shell script that looks for the two oldest files and deletes them
(Ubuntu Server) I have a folder full of files in pairs (one is a log, another is a DB backup) They are basically create/modified at the same time. I need … -
Created Access the description of a security group of Active Directory?
Im doing some work with C# and AD and Im missing something right now that I cant seem to see. I want to get a description of a security group … -
Created C# get last row inserted
Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by … -
Replied To a Post in Getting information from a Excel
Sadly, I cannot edit but I want to make clear that oledbcmd = "Select * From [CLIENTES$]"; Works. It isnt a connection issue or anything else (the connection code is … -
Gave Reputation to ddanbe in Getting information from a Excel
Guess you forgot to open your connection. -
Created Getting information from a Excel
I have the following: string oledbcmd = ""; string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Excel.xls;@Extended Properties='Excel 8.0;HDR=Yes;"; oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; OleDbCommand oconn = … -
Created Should PowerShell get its own section?
I see most PowerShell questions being asked in Shell Scripting and its not really a scripting language per say as it is much deeper than that. I porpose it gets … -
Created PowerShell script: Backup copies of email on client computers
I'm looking for the best way to back cold backups of the email on my client's PC. Starting off with PowerShell, I would run this: Get-ChildItem -Path 'C:\' -Filter '*.pst' … -
Created Powershell script to backup from server to mobile VPN client
I have a mobile VPN client that I want to backup to. The problem is that it does not have a static IP to due it being L2TP/IPSec. Thats the … -
Replied To a Post in Making backups of MySQL database over WAN?
Like I said I dont want to backup the FULL database each time over and over again. -
Replied To a Post in Making backups of MySQL database over WAN?
> > Here is one link for your help http://blog.mwpreston.net/2011/11/24/moving-your-veeam-backup-replication-database/ MySQL, not MS SQL Server. -
Replied To a Post in Making backups of MySQL database over WAN?
> If the main plays as master then it's ok, just open 3306 at let the slaves connect to it, you do not need to open ports on slaves because … -
Replied To a Post in Making backups of MySQL database over WAN?
Would replication require opening ports on the site's side? If so, I cannot open ports on the site's side. Only on the main side. -
Created Making backups of MySQL database over WAN?
I have several databases located over the world, this all have the same structure, with the same tables and triggers. For clarification purposes: Site 1: database_1 (with all its tables … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
The device would be a basic Synology NAS; Apache, PHP, etc.... Just to note some of the technologies that would be avaliable. -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
If it helps the web service and the database will be on the same device. -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
For example, lets make a simple web service app that I put two numbers, adds it up and it gives me the result of the sum :) What is the … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
> What's your language choice for the SOAP server? Would make finding a possible tutorial easier. http://msdn.microsoft.com/en-us/library/ms862153.aspx Personally, I perfer C#. Realistically, I want the easiest one. -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
The dotConnect seems to work (because it accepts the connection) but it has some stupid license issues that dont allow me to use it. So right now we are with … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
Ive also found: http://www.devart.com/dotconnect/mysql/editions.html -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
The web service route has been discarded. That "ADOCE DLL" seems intresting. I just need the files. -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
Im trying to download it but it gives me a .exe which I do not trust. Any place to directly download those .dll? -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
> a > > What IDE is that, Visual Studio? Talking to a REST service requires not much more than a (Http)WebRequest. We are talking about a embedded industrial application. … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
> That's why I suggested a REST server at first, the implementation and usage is much simpler. The thing is that the IDE I use for developing a embedded app … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
> Yes, that works too. So basically I would build a "SOAP server" and then my application running in Windows Embedded Compact 7 would call it and it would get … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
The MySQL server runs on a Synology NAS which I BELIEVE also has the ability to run as a web server. How do you find how exactly I would set … -
Replied To a Post in Connecting from a Windows CE to a MySQL Server
> Haven't been able to find any yet. I think your best bet is to create a webservice as intermediairy. > This actually could be a intresting solution. I would … -
Created Connecting from a Windows CE to a MySQL Server
I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86? Thank you -
Replied To a Post in Get row before SELECT query
> But, I don't know how you're going to query this - from a form? Drop down box to make sure that a idiot doesnt insert "hi" or anything. Depending … -
Replied To a Post in Get row before SELECT query
The "simpler query" never gave me results as I imagine it goes thru EVERYTHING. While the one where I filter by date and time does take a while (a minute) … -
Replied To a Post in Get row before SELECT query
Could you explain the query? I know it first does a first query getting the maxcycle between two dates. But then Im not completely sure the grouping... -
Replied To a Post in Get row before SELECT query
select mytable.* from mytable inner join (select *, max(cycle) as maxcycle from mytable WHERE ('2014-04-24 09:09:37' < Time_Stamp OR ('2014-04-24 09:09:37' = Time_Stamp AND 765 <= Time_Stamp_ms)) AND ('2014-04-24 09:10:38' … -
Replied To a Post in Get row before SELECT query
This query seems to be better: select mytable.* from mytable inner join (select *, max(cycle) as maxcycle from mytable group by cycle_id) as grouped on mytable.cycle_id = grouped.cycle_id and mytable.cycle … -
Replied To a Post in Get row before SELECT query
> UPDATE: http://www.screencast.com/t/uoIMkRWgAX0q > SELECT: http://www.screencast.com/t/LbrMHsPLY3 > Join and Group will take a long time :( > You didn't say how often you are thinking of running this query. Basically, … -
Replied To a Post in Get row before SELECT query
This query never finished: SELECT times.* FROM times INNER JOIN (SELECT *, MAX(cycle) AS maxcycle FROM times GROUP BY cycle_id) AS grouped ON times.cycle_id = grouped.cycle_id AND times.cycle = grouped.maxcycle … -
Replied To a Post in Get row before SELECT query
That query never finished BTW. Just in case the table isnt clear:  I insert cycle each time one until it reaches n (n right now is 250) and … -
Replied To a Post in Get row before SELECT query
Lets see how long this one takes.... -
Replied To a Post in Get row before SELECT query
Done. Took 37 minutes :P Trying now: 1.SELECT times.* FROM times 2. INNER JOIN (SELECT *, MAX(cycle) AS maxcycle FROM times 3. GROUP BY cycle_id) AS grouped 4. ON times.cycle_id … -
Replied To a Post in Get row before SELECT query
Didnt see that SQL sorry... Running it now. Its gonna take a while to update 5 million records. Option 1 is not possible. Option 2 is possible but using a … -
Replied To a Post in Get row before SELECT query
Well, how do I currently fill up "cycle_id" with 1,1,1,1,1,1,1,1,1;2,2,2,2,2,2,2,2,2,2,2,2;3,3,3,3;4,4,4,4,4 In my current table data? Also by a autoincremental, do you mean that each time I enter a new row, …
The End.