Posts made by mzprays

mzprays

I ended up adding MaximumPoolSize=25; to the connectionString for all of the Toec-API instances and everything seems happy now. Increasing the max connections would have likely had the same effect, but I'm not seeing all the connections utilized even at peak checkin times. HeidiSQL is a great troubleshooting tool.

mzprays

@theopenem_admin I'll try these one at a time and report back. Thank you!

mzprays

The errors in Event Viewer are pretty much constant, with over 40 per second. They're accompanied by failed scheduled tasks, and this in the logs:

2024-12-19 12:41:45,199 [Worker #19] ERROR Hangfire.Server.Worker 10 state change attempt(s) failed due to an exception, moving job to the FailedState
MySqlConnector.MySqlException (0x80004005): Too many connections
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at MySqlConnector.Core.ServerSession.<ConnectAsync>d__68.MoveNext() in /_/src/MySqlConnector/Core/ServerSession.cs:line 385
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySqlConnector.Core.ConnectionPool.<GetSessionAsync>d__10.MoveNext() in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 111
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at MySqlConnector.Core.ConnectionPool.<GetSessionAsync>d__10.MoveNext() in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 140
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySqlConnector.MySqlConnection.<CreateSessionAsync>d__115.MoveNext() in /_/src/MySqlConnector/MySqlConnection.cs:line 819
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySqlConnector.MySqlConnection.<OpenAsync>d__27.MoveNext() in /_/src/MySqlConnector/MySqlConnection.cs:line 407
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 365
at Hangfire.MySql.MySqlStorage.CreateAndOpenConnection()
at Hangfire.MySql.MySqlStorage.UseConnection[T](Func`2 func)
at Hangfire.States.BackgroundJobStateChanger.GetJobData(StateChangeContext context)
at Hangfire.States.BackgroundJobStateChanger.ChangeState(StateChangeContext context)
at Hangfire.Server.Worker.TryChangeState(BackgroundProcessContext context, IStorageConnection connection, IFetchedJob fetchedJob, IState state, String[] expectedStates, CancellationToken initializeToken, CancellationToken abortToken)

mzprays

@theopenem_admin The issue is back, unfortunately, it just took a couple days to show up again. I set innodb_buffer_pool_size=10GB, and it is using 5.2GB of memory. Should it be using that variable's worth of memory?

The results of show processlist; in MariaDB are here.

mzprays

@theopenem_admin This solved the issue, thank you!

mzprays

Hello!
I have an install of Theopenem at a school system with five com servers in a cluster and 4178 endpoints. Every morning from around 7:45-9, it becomes unusably slow, with weird errors and access denied pages. After this period every morning it's fine, with everything checking in and responding normally. Digging into the logs, MariaDB is having a fit, giving this "too many connections" error up to around a dozen times per second. Is there anything I can do to lighten the load on the database? What causes this?

mzprays

I created a super basic implementation of a self-service portal using the API, it works in a pinch but I wouldn't use it in production without heavy improvement. Mostly just curiosity about what's possible with the API
https://github.com/AidanRB/toem-store

mzprays

I did some digging and it appears bootType is being incorrectly detected as legacy, so the script is formatting the drive as MBR. $env:firmware_type contains the correct value, EFI. I found that the boot type is determined using Confirm-SecureBootUEFI, interpreting a failure to run as legacy boot. This system does not support secure boot, causing Confirm-SecureBootUEFI to crash, although it does use UEFI. Is there a reason Confirm-SecureBootUEFI is used instead of $env:firmware_type for the boot type?

mzprays

I'm having issues deploying an image onto a specific device model, other devices are fine. It seems to be a problem with partitioning, but I can't figure out why.


WinPE Version:

10.0.25398.0

System Architecture:

@{OSArchitecture=64-bit}

Using Legacy BIOS

 ** Looking For Active Task For .MT43I28SF-2XZ2103040540010009.23A728AC-658E-8E45-BFB1-77447A51C546 **

{"computerId":"false","task":"ond","taskId":null,"computerName":null}

 ...... This Computer Was Not Found

 ** Looking For Active Task For EC:D6:8A:83:21:1A.MT43I28SF-2XZ2103040540010009.23A728AC-658E-8E45-BFB1-77447A51C546 **

{"computerId":"5531","task":"deploy","taskId":"89","computerName":"BX40T-A4"}

 ...... Success

 ** Verifying Active Task ** 

computer_name=BX40T-A4
image_name=Windows11_23H2_On-Prem
profile_id=3
pre_scripts=""
before_file_scripts=""
after_file_scripts=""
file_copy=True
sysprep_tags=""
image_type=File
set_bootmgr=True
display_sleep_time=5
web_cancel=true
task_completed_action="Reboot"
direct_smb=true
change_computer_name=true
skip_expand_volumes=true
fix_bcd=true
randomize_guids=true
skip_nvram=true
fix_bootloader=true
force_dynamic_partitions=true
partition_method=dynamic
image_server="http://covs-toemweb.hcps.k12.local:8888/clientimaging/"


 ...... Success

Current Boot Order


Firmware Boot Manager

---------------------

identifier              {fwbootmgr}

displayorder            {bootmgr}

timeout                 2



Windows Boot Manager

--------------------

identifier              {bootmgr}

device                  partition=\Device\HarddiskVolume1

path                    \EFI\MICROSOFT\BOOT\BOOTMGFW.EFI

description             Windows Boot Manager

locale                  en-US

inherit                 {globalsettings}

default                 {default}

resumeobject            {98dae182-9de5-11ed-95a6-ecd68a839e4b}

displayorder            {default}

                        {98dae180-9de5-11ed-95a6-ecd68a839e4b}

toolsdisplayorder       {memdiag}

timeout                 0


 ** Mounting SMB Share ** 

 ...... Connecting To //COVS-TOEMWEB/toems_local_storage
The command completed successfully.




 ...... Success

file_copy_schema: profileId=3


Count FilesAndFolders                                                                         

----- ---------------                                                                         

1     {@{DestinationFolder=; DestinationPartition=; FileName=drivers_tested.zip; ModuleGuid...






 ** Looking For Hard Drive(s) **

 ** Displaying Available Devices ** 


Number F Serial Number                    HealthStatus         OperationalStatus    Total Size

       r                                                                                      

       i                                                                                      

       e                                                                                      

       n                                                                                      

       d                                                                                      

       l                                                                                      

       y                                                                                      

                                                                                              

       N                                                                                      

       a                                                                                      

       m                                                                                      

       e                                                                                      

------ - -------------                    ------------         -----------------    ----------

0      K 50026B7684785F75                 Healthy              Online                238.47 GB






 ...... Found 1 Drives

 ** Displaying Current Partition Table On 0




   DiskPath: \\?\scsi#disk&ven_&prod_kingston_om8p0s3#4&2b547927&0&000000#{53f56307-b6bf-11d0-

94f2-00a0c91efb8b}



PartitionNumber  DriveLetter Offset                            Size Type                      

---------------  ----------- ------                            ---- ----                      

1                           1048576                         100 MB System                    

2                           105906176                        16 MB Reserved                  

3                C           122683392                    237.86 GB Basic                     

4                           255520145408                    515 MB Recovery                  






 ** Processing Hard Drive 0

Get hd_schema:  profileId=3&clientHdNumber=0&newHdSize=256060514304&schemaHds=&clientLbs=0

{"BootPartition":"","Guid":"{9f23656f-e22e-42b0-9a5c-95c42987f7a5}","IsValid":"true","Message":null,"PartitionType":"GPT","PhysicalPartitionCount":4,"PhysicalPartitions":[{"Compression":null,"EfiBootLoader":"","FileSystem":"FAT32","Guid":"{69088a00-e706-481b-8367-59d15c8f3ba9}","ImageType":null,"Number":"1","PartcloneFileSystem":null,"Prefix":null,"Type":"System","Uuid":"","VolumeGroup":null},{"Compression":null,"EfiBootLoader":"","FileSystem":"","Guid":"{bd23da07-dea8-4ca5-b7d4-6b207aec4b41}","ImageType":null,"Number":"2","PartcloneFileSystem":null,"Prefix":null,"Type":"Reserved","Uuid":"","VolumeGroup":null},{"Compression":null,"EfiBootLoader":"","FileSystem":"NTFS","Guid":"{e96f0c84-a44d-4ee4-951e-f5b592e2b9d8}","ImageType":null,"Number":"3","PartcloneFileSystem":null,"Prefix":null,"Type":"Basic","Uuid":"","VolumeGroup":null},{"Compression":null,"EfiBootLoader":"","FileSystem":"NTFS","Guid":"{d853c12f-b7a4-4109-9f62-97e73770e35e}","ImageType":null,"Number":"4","PartcloneFileSystem":null,"Prefix":null,"Type":"Recovery","Uuid":"","VolumeGroup":null}],"SchemaHdNumber":0,"UsesLvm":"false"}

 ...... HD Meets The Minimum Sized Required

imageProfileId=3&hdToGet=0&newHDSize=256060514304&clientHD=0&taskType=deploy&partitionPrefix=&lbs=512 http://covs-toemweb.hcps.k12.local:8888/clientimaging/GetPartLayout

 ** Partition Creation Script ** 
New-Partition 0 -GptType '{c12a7328-f81f-11d2-ba4b-00a0c93ec93b}' -Size 100MB 2>&1 >> $clientLog

New-Partition 0 -GptType '{e3c9e316-0b5c-4db8-817d-f92df00215ae}' -Size 16MB 2>&1 >> $clientLog

New-Partition 0 -GptType '{ebd0a0a2-b9e5-4433-87c0-68b6b72699c7}' -Size 239044MB | Format-Volume -FileSystem NTFS 2>&1 >> $clientLog

New-Partition 0 -GptType '{de94bba4-06d1-4d40-a16a-bfd50179d6ac}' -Size 800MB | Format-Volume -FileSystem NTFS -NewFileSystemLabel WindowsRE 2>&1 >> $clientLog

New-Partition : A parameter is not valid for this type of partition.

 

Extended information:

The parameters GptType, IsHidden, and IsDAX cannot be used on an MBR disk.

 



Activity ID: {d7502885-d397-0001-392d-50d797d3da01}

At X:\newPartLayout.ps1:1 char:1

+ New-Partition 0 -GptType '{c12a7328-f81f-11d2-ba4b-00a0c93ec93b}' -Si ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : InvalidArgument: (StorageWMI:ROOT/Microsoft/Windows/Storage/MSF 

   T_Disk) [New-Partition], CimException

    + FullyQualifiedErrorId : StorageWMI 41006,New-Partition

 

New-Partition : A parameter is not valid for this type of partition.

 

Extended information:

The parameters GptType, IsHidden, and IsDAX cannot be used on an MBR disk.

 



Activity ID: {d7502885-d397-0001-392d-50d797d3da01}

At X:\newPartLayout.ps1:2 char:1

+ New-Partition 0 -GptType '{e3c9e316-0b5c-4db8-817d-f92df00215ae}' -Si ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : InvalidArgument: (StorageWMI:ROOT/Microsoft/Windows/Storage/MSF 

   T_Disk) [New-Partition], CimException

    + FullyQualifiedErrorId : StorageWMI 41006,New-Partition

 


boot partition is 

 ** New Partition Table Is ** 

@{Compression=; EfiBootLoader=; FileSystem=FAT32; Guid={69088a00-e706-481b-8367-59d15c8f3ba9}; ImageType=; Number=1; PartcloneFileSystem=; Prefix=; Type=System; Uuid=; VolumeGroup=}

@{Compression=; EfiBootLoader=; FileSystem=; Guid={bd23da07-dea8-4ca5-b7d4-6b207aec4b41}; ImageType=; Number=2; PartcloneFileSystem=; Prefix=; Type=Reserved; Uuid=; VolumeGroup=}

@{Compression=; EfiBootLoader=; FileSystem=NTFS; Guid={e96f0c84-a44d-4ee4-951e-f5b592e2b9d8}; ImageType=; Number=3; PartcloneFileSystem=; Prefix=; Type=Basic; Uuid=; VolumeGroup=}

 ** Starting Image Download For Hard Drive 0 Partition 3
Set-Partition : The requested object could not be found.

At X:\wie_deploy.ps1:275 char:5

+     Set-Partition -DiskNumber $($hardDrive.Number) -PartitionNumber $ ...

+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : ObjectNotFound: (PS_StorageCmdlets:ROOT/Microsoft/..._StorageCm 

   dlets) [Set-Partition], CimException

    + FullyQualifiedErrorId : MI RESULT 6,Set-Partition

 


wimapply s:\images\Windows11_23H2_On-Prem\hd0\part3.winpe.wim C: 2>>x:\clientlog.log > x:\wim.progress
wimapply : 

At X:\wie_deploy.ps1:301 char:13

+             wimapply $script:imagePath\part$wimSource.winpe.wim C: 2> ...

+             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    + CategoryInfo          : NotSpecified: (:String) [], RemoteException

    + FullyQualifiedErrorId : NativeCommandError

 

[WARNING] Failed to get volume information for "C:" (err=3): The system cannot find the path 

specified



[WARNING] Ignoring FILE_ATTRIBUTE_COMPRESSED of 48 files



[WARNING] Ignoring FILE_ATTRIBUTE_SPARSE_FILE of 6 files



[WARNING] Extracting 46031 hard links as independent files



[WARNING] Ignoring reparse data of 58 files



[WARNING] Ignoring Windows NT security descriptors of 173642 files



[WARNING] Ignoring extended attributes of 39720 files



[WARNING] Ignoring object IDs of 32 files



[WARNING] Ignoring DOS names of 148687 files



[ERROR] Can't open or create directory "C:" (status=c000003a): {Path Not Found}



The path %hs does not exist

ERROR: Exiting with error code 48:

       Failed to open a directory.


 ** Processing File Copy ** 

@{Compression=; EfiBootLoader=; FileSystem=NTFS; Guid={d853c12f-b7a4-4109-9f62-97e73770e35e}; ImageType=; Number=4; PartcloneFileSystem=; Prefix=; Type=Recovery; Uuid=; VolumeGroup=}

Updated Boot Order
The boot configuration data store could not be opened.

The requested system device cannot be found.


 ** Closing Active Task **

mzprays

I'm trying to download the update for 1.5.6, but it's being detected as a virus by my machine. VirusTotal isn't happy about it either: https://www.virustotal.com/gui/file/1f6cc11bec13944ab4a15a860f3bdf6388781e6acb144de41069f52cb883a4de/details

Is this the correct file? I checked previous versions and they do not have the same warnings. What changed that's triggering all these AVs?

mzprays

@mzprays https://docs.theopenem.com/changelog/version-history.html#154-6-2-23 ah, nevermind

mzprays

I found this, is there another way to access the help?

mzprays

@theopenem_admin Was this added in a release? I'm running into the same problem. I'm unsure how to script a condition as well, where can I find that?

mzprays

Nevermind, it fixed itself.

mzprays

Just installed a new instance of Theopenem, and after getting through the setup process, I'm not seeing the "i" icon in the top right of each page with the documentation. In the HTML, it's there, but commented out, and uncommenting it and clicking it does nothing. Did I miss something in the setup process? I went back and checked all the steps.

mzprays

Hello! I'm setting up a new environment, and I'm having an issue deploying TOEC. After installing on the clients, it isn't connecting to the server. I ran it in the terminal, and got the following output:

PS C:\Program Files\Toec> .\Toec.exe --console
2023-10-19 08:54:43,728 INFO [1] Host ****\**** - Starting Toec Service

Toec Running
Press [Enter] to Exit.
2023-10-19 08:54:44,009 INFO [4] ServiceInitialize ****\**** - Toec Version: 1.5.4.0
2023-10-19 08:54:46,092 ERROR [4] ServiceInitialize ****\**** - Database Access Failed.  Service Cannot Continue.  Exiting....
2023-10-19 08:54:46,092 ERROR [4] ServiceInitialize ****\**** - An exception occurred while initializing the database. See the InnerException for details.

mzprays

Hey, I'm back with a likely related problem. Trying to use a command module to use netsh to add a wifi profile via XML:

2022-10-06 14:52:41,855 INFO [22] ModuleCommandManager DOMAIN\user - Running Command Module: Add wifi
2022-10-06 14:52:41,858 DEBUG [22] ServiceProcess DOMAIN\user - Starting Command: cmd.exe /c  "netsh" wlan add profile filename="Wi-Fi-wifiname.xml" user=all
2022-10-06 14:52:41,896 INFO [22] ModuleCommandManager DOMAIN\user - {"ExitCode":1,"StandardError":"'netsh\" wlan add profile filename=\"Wi-Fi-wifiname.xml' is not recognized as an internal or external command,\r\noperable program or batch file.\r\n\r\n","StandardOut":"\r\n"}
2022-10-06 14:52:41,897 INFO [22] ModuleCommandManager DOMAIN\user - Command Module: Add wifi Finished
2022-10-06 14:52:41,898 ERROR [22] PolicyExecutor DOMAIN\user - An Error Occurred In Module Add wifi
2022-10-06 14:52:41,898 ERROR [22] PolicyRunner DOMAIN\user - Aborting Current Policy```

mzprays

Yeah, thought it might be good to point out. The documentation on that page also says nothing about the uploads right there, it actually points to a file copy module.

mzprays

@theopenem_admin That worked, thank you! I didn't know I could reference files uploaded there like that, I tried .\ and it didn't work.

mzprays

@theopenem_admin [module-2eb9ecc7-db9c-434e-b824-aa7b9cb4ff22]Check-Ins-Setup-1.10.0.exe
And in the arguments field: /S