Will Marcouiller's questions

Summary

I mounted a local Jenkins Build Server in a local Docker Container and exposed ports 8080 both from the host to the Jenkins container.

I want to test the integration of Jenkins with Azure DevOps so Jenkins is the build server for the project.

Docker

I simply used the official jenkins/jenkins Docker image from Docker Hub and ran it like so:

docker run -d -p 8080:8080 --name jenkins jenkins/jenkins

Container is reachable from localhost:8080 and responds well.

Windows 10 Pro

In Windows 10 Firewall I created two port rules:

1. Inbound, TCP, Local Port: All, Remote Port: All
2. Inbound, UDP, Local Port: All, Remote Port: All

Bell Fibe HomeHub 2000

I created a port forwarding for my IP address which the modem did assosciate to the correct computer where the Docker container is running.

Internet

When I try to access my [public ip address]:80 that I obtain by googling "what's my ip address", I hit this page.

Related SF Question

Webserver in Docker container is not reachable via the Internet

And I'm unsure as to how to proceed or even if it's necessary. I'm rather a software architect than a system admin, and I don't really understand the need of a Docker network if my ports forwarding is right.

I have rebuilt my IBM x360 server.

Now, I am reinstalling my VMware ESX Server 3 on it, and I have the following drive arrays:

1. Array A is set of 3 36GB U160 (directly on server, channel 1 of my IBM ServeRAID 6M)
2. Array B is set of 6 146GB U320 (on my EXP300)

3. Array C is set of 2 73GB U320 (on my EXP300)

   • Array A is RAID 5.
   • Array B is RAID 5EE.
   • Array C is RAID 1.

Now, I'm at the step of configuring the partitions. I have found the following which seems to look good:

Planning Partitions for ESX Server 2.5 (1506)

Based on this knowledge base article, I thought of doing the following:

Mount Point | File System Type | Size(MB) | Add. Size Opt. | Force Primary Partition
      /boot        |           ext3              |  192MB    |     Fixed size      |             Select
       N/A         |           swap             |   384MB   |     Fixed size      |            Select
      /(root)      |           ext3               |  1800MB  |     Fixed size      |            Select
      /home      |           ext3               |  1800MB  |     Fixed size      |       Do not select
   /vmimages  |           ext3               | 10000MB |     Fixed size      |       Do not select
       N/A         |       vmkcore            |   100MB   |     Fixed size      |       Do not select
       N/A         |          vmfs2             |   RoDisk   |     Fill to max.     |       Do not select

• Array A: /boot, N/A-swap, /(root) and /home
• Array B: vmfs2
• Array C: /vmimages

Are my partitioning intentions looking good?

My x360 server has only a CD drive in it.

I wish to upgrade and install a DVD drive, so it is easier for me to install software without sharing my workstation DVD drive all the time.

According to IBM ServerProven Compatibility, only those two are compatible with my x360:

• 10K3798
• 22P7047

Reference: x360 (8686) compatibility

Is it all that fits, or can I use any IBM DVD laptop drive to fit it, like faster than only 8x?

I own an IBM x360 server in which I have an IBM ServeRAID 2 channels SCSI controller for which I use the two channels.

• Channel 1: the server's HDD.
• Channel 2: IBM EXP300 HDD Enclosure.

Will this IBM ServeRAID SCSI controller work and allow me to use my EXP300 HDD Enclosure with the x366 server, though the x366 has SAS onboard?

I'm not sure whether this question belongs here or to StackOverflow. I'm attempting here, since my question is in regards of memory leaks and management stuff more than programming.

I have a SQL script which I attempt to run and everytime the server response is:

No sufficient memory to complete this query (that is the main idea, not the exact message)

Now, the script has more than 50 000 rows to insert like the example below:

1=>

insert into Cities ([Name]) values (N'MyCityName')

2=>

insert into Sectors ([Name], [Description], City_CityId)(
    select N'FirstSector', N'1at Sect. Desc.', c.CityId 
        from Cities c 
        where c.[Name] like N'MyCityName')

3=>

insert into Streets ([Name], Direction_Value, Type_Value, SectorId, City_CityId)(
    select N'1st Street', 0, 10, s.SectorId, c.CityId
        from Cities c
            inner join Sectors s on s.City_CityId = c.CityId
        where c.[Name] like N'MyCityName' 
            and s.[Name] like N'FirstSector')

4=>

insert into Addresses (StreetNumber, NumberSuffix_Value, UnitSuiteAppt, StreetId, SectorId, CityId)(
    select 999, 0, N'', st.StreetId, s.SectorId, c.CityId 
        from Cities c
            inner join Sectors s on s.City_CityId = c.CityId
            inner join Streets st on st.SectorId = s.SectorId and st.City_CityId = c.CityId
        where c.[Name] like N'MyCityName'
            and s.[Name] like N'FirstSector'
            and st.[Name] like N'1st Street')

5=>

insert into People (Surname, FirstName, IsActive, AddressId)(
    select N'TheSurname', N'TheFirstName', 1, a.AddressId
        from Addresses a
            inner join Cities c on c.CityId = a.CityId
            inner join Streets s on s.StreetId = a.StreetId
        where a.StreetNumber = 999
            and a.NumberSuffix_Value = 0
            and a.UnitSuiteAppt = N''
            and c.[Name] like N'MyCityName'
            and s.[Name] like N'1st Street')

So, I have the number of each instruction as follows:

1=> 2;

2=> 5;

3=> ~700;

4=> ~35000;

5=> ~35000;

Executing those thousands of instruction will drive me to the unsufficient memory issue. And while I open Task Manager, I have SSMS necessitating more than 400MB of RAM.

My configuration is as stated below:

Lenovo W700ds
2x320GB HDD 7200RPM RAID 0
4GB RAM DDR3
Intel Core 2 Quad 2.0GHz 6MB L2
Windows 7 Professional 64bits (/w all updates)
SQL Server 2005 Express services running 
    (That is my data server, I'm not using 2008 for this project)
SQL Server Management Studio 2008 Express 
    (SP3 installed /w all updates)

I only have SSMS2008 application running while executing the inserts instructions.

Any thoughts to render this situation doable either by system optimization or other updates are greatly appreciated.

It's been a few days now that I have gotten problems and problems with my network connection, though my other computer works fine!

The problematic computer is operating with (PC2)

Windows 7 Professional

The running-fine computer is running (PC1)

Windows Vista Business

The problem occured when I turned off my Cisco Catalyst 3500 series switch so that I can move it to another location (5 feet away). I then recoeecnted the Ethernet cables and my cable modem to the switch.

The PC1 then reinitialized the network, found the settings and reconnected properly! Internet is then running just fine as if I had never touched it in my life! Great!

I can't tell the same with PC2, sadly. It began to identify the network, then set it to Unidentified network over and over again though I have tried solving with the troubleshooter. Here's what I did so far:

I read this linked in answer article to know what's NLA.
What settings does Windows use to determine network location?

I have also read this: LAN - Unidentified Network (No Network Access) on Windows 7

I have also tried:

1. Setting the DHCP Broadcast Flag to 0 so no more broadcast;
2. Running a Powershell script that was suppoed to set all Unidentified network to private;
3. Went and change manually Unidentified network setting from "unknown" to "private";
4. Forced ipconfig /release, typed in a fake IP in my Local Connection, saved the seetings, then clicked the "Obtain an IP automatically option, and ipconfig /renew;
5. Setting proper DNS IP though PC1 is set to obtain them automatically (and works, not PC2);
6. Disabled the adapter, uninstalled and reinstalled it, and enabled it;
7. To stop the NLA and related services with no luck (didn't solve my problem);
8. Rolledback to previous working settings/configuration with a restore point, and it netiehr solved the problem.

Many of the above-mentioned tries come from ServerFault.com and I simply can't find the questions anymore, so please believe me, I DID search! I've been working for about 6 hours on the problem, that is, probably becuase I am no network nor system administrator.

Any one who has something relevant is welcome to answer and help me. I'm desperate. =( I just want it to work!

While trying the ipconfig thing, it said that the DHCP request timed out. I tried to ping some other IP addresses as well, and it seems PC2 is totally lost. I can't find a solution, I have done everything I could, I knew, and learned for the last two days.

Thanks for your help!

This question is issued from the following:
Will a Cisco 2514 router work properly with a Cisco Catalyst 3500 series switch?

Following the inner requirements, I have searched for a more recent router. As such, I have found a 3620 and a 3640 routers.

As mentionned in the linked question, these routers are to be connected with 3500 Series Cisco switches.

What router would I profit the most from:

1. Considering performance;
   
2. Considering equipment ease of use.

I am no system administrator but a developer understanding most of the basics about networks, and have already installed some networks, but no Cisco stuff so far.

Thanks for your kind guidance! =)

I'm looking forward to build my own network infrastructure, and for that, I have bought a Cisco 2514 router and two Catalyst 3500 series Cisco switches.

I have been advised, after the purchase, that a Catalyst 2500 series would work better with my 2514 router than a 3000 series one.

So, will my 2514 router work properly with my Catalyst 3500 switch, or shall I consider to buy another router before trying to mount them together?

Thanks for your inputs! =)

I'm sneeking around online store for used stock of hubs, routers and switches for a project I have to build a network infrastructure.

So far, I have bought:

1. 1x Cisco 2514 Router;
2. 5x Cisco Serial Transceivers;
3. 1x 24-port Cisco Catalyst switch.

I have souvenirs of having seen switches and hubs connected altogether, and remember that there is an advantage of some sort using such architecture, but I don't remember correctly, it's quite fuzzy in my mind as I am no network administrator, but a system developer.

I know that a switch builds itself a table of something to map the different connections, but can't remember excatly what it is. So my question is the following:

What is the difference between a hub and a switch?

Any answer is appreciated!

Thanks! =)

Summary

I'm currently trying to pickup the data of a HDD which PC is now dead (the M/B). I connected the HDD to my PC using an External IDE->USB Enclosure and can navigate thoughout some of the alien drive folders.

Aside, when I attempt to access some of the folders, like the ones in Documents and Settings\*, I always get the message that I need to go to the Security Tab.

Security Issue

The problem I'm having is because the ownership of the Document and Settings subfolders is undefined. Changing the ownership to MyPC\Administrators suffice to let me continue exploring the folder I just double-clicked. Then, I have to do it for all, and I mean for all the subsequent subfolders.

Wanted

I would like to get a workaround as per setting the ownership all at once to all of this HDD's folders and subfolders, without being obliged to click [Continue], when I'm asked to, or going to the Security Tab to change the ownership manually for each single folder.

Configuration

My PC:

1. Microsoft Windows 7 Professional;

Alien HDD:

1. Was using Windows XP.
2. Currently connected through an external IDE/USB hard drive enclosure.

Purpose

I need to retrieve important business files, since the PC this drive was installed on just died.

Question

Is there a way to allow me to change all of the ownership of this external drive folders and subfolders so that I don't need to change it manually for each and every single folder again?

Please feel free to ask whatever question that may help you help me! I will be more than pleased to give the more accurate answer that I can with my basic knowledge as a system administrator (I'm a software developer).

Thanks for your kind help everyone! =)

Here's my situation. A project has as objective to migrate some attachments to another system.

These attachments will be located to a parent folder, let's say "Folder 0" (see this question's diagram for better understanding), and they will be zipped/compressed.

I want my batch script to be called like so:

BatchScript.bat "c:\temp\usd\Folder 0"

I'm using 7za.exe as the command line extraction tool.

What I want my batch script to do is to iterate through the "Folder 0"'s subfolders, and extract all of the containing ZIP files into their respective folder.

It is obligatory that the files extracted are in the same folder as their respective ZIP files. So, files contained in "File 1.zip" are needed in "Folder 1" and so forth.

I have read about the FOR...DO command on Windows XP Professional Product Documentation - Using Batch Files.

Here's my script:

@ECHO OFF

FOR /D %folder IN (%%rootFolderCmdLnParam) DO 
    FOR %zippedFile IN (*.zip) DO 7za.exe e %zippedFile

I guess that I would also need to change the actual directory before calling 7za.exe e %zippedFile for file extraction, but I can't figure out how in this batch file (through I know how in command line, and even if I know it is the same instruction "cd").

EDIT #1

The below-given answers are both close to what I need. But for some unknown reasons, sometimes the batch file, when I give a parameter, just won't do anything and bring me back to prompt.

I haven't written a batch file for about 15 years, so I completely forgot about the logic behind, etc.

Someone can help, please?

EDIT #2

It seems, without any certitude, that the batch file script can't handle folder names with space character. Can one of you confirm and propose a solution for counter this please?

I'm going completely blind here... Thanks for your help! =)

EDIT #3

I need the solution to be fully recursive as I don't know the directory structure against which this will be used. Sorry for not having mentioned before.

EDIT #4

I have been inspired by all of your answers and other's to come up with the following (which works at 98%):

@echo off

setlocal enableextensions enabledelayedexpansion

rem
rem Display instructions when no parameter is given.
rem
if "%1" equ "" (
    echo Syntaxe : od.bat ^<directory mask>^
    echo Exemple : od.bat *
    goto :Eof
)

rem
rem Setting the PATH environment variable for this batch file for accessing 7za.exe.
rem
path=c:\temp;%PATH%

rem
rem Removing quotes from the given command line parameter path.
rem
set root=%1
set root=%root:~%1
set root=%root:~0,-1%

rem Searching directory structure from root for subfolders and zipfiles, then extracting the zipfiles into a subfolder of the same name as the zipfile.
for /F "delims==" %%d in ('dir /ogne /ad /b /s %root%') do (
    echo Traitement du dossier : "%%d"

    for /F "delims==" %%f in ('dir /b "%%d\*.zip"') do (
        rem Getting filename without extension.
        set subfolder=~n%f
        mkdir "%%d\%subfolder%"
        rem Extracting zipfile content to the newly created folder.
        7za.exe e "%%d\%%f" -o"%%d\%subfolder%"
    )
)

:Eof

endlocal

The only trouble I get is that it wants to create, to stick with my example, File5 subfolder in order to extract the zipfile into. This is no problem when extracting the actual File5.zip file. But when it digs deeper in the directory structure to subfolders, since it has gotten the last File5 filename, it wants to create File5 subfolder into Folder 1\Folder A, for example, to extract File1.zip. Here's an example of structure:

║
║═════ Folder 1
║         ║
║         ║══════ Folder A
║                     ║
║                     ║═════ File1.zip
║
║═════ Folder 5
          ║
          ║═════ File5.zip

So, considering the above-illustrated structure, it wants to create File5 in Folder A, when it should intend to create File1 instead.

Thanks for your support and help! =)

Anyone's help is gratefully appreciated.

EDIT #5

I have accepted @Dennis Williamson's answer since his solution fulfills what I have asked on the first place. Otherwise, if one is looking for a fully recursive solution, please follow the link provided in my own answer, which will bring you to the StackOverflow website.

I need to write a batch file to unzip files to their current folder from a given root folder.

Folder 0
    |----- Folder 1
    |          |----- File1.zip
    |          |----- File2.zip
    |          |----- File3.zip
    |
    |----- Folder 2
    |          |----- File4.zip
    |       
    |----- Folder 3
               |----- File5.zip
               |----- FileN.zip

So, I wish that my batch file is launched like so:

ocd.bat /d="Folder 0"

Then, make it iterate from within the batch file through all of the subfolders to unzip the files exactly where the .zip files are located.

So here's my question:

Does the Windows (from XP at least) have a command line for its embedded zip tool? Otherwise, shall I stick to another third-party util?