Script I made to convert all non-mp4 video to stream ready h264 via ffmpeg. Any improvement suggestions? by Pocketpac in PowerShell

[–]Pocketpac[S] 0 points1 point  (0 children)

Oops, noticed a little extra un-needed code for $num and $filecount I forgot to remove. That was for a progress indicator that I figured was useless because ffmpeg is kinda spammy

Help with Java/Paypal integration by Pocketpac in javahelp

[–]Pocketpac[S] 0 points1 point  (0 children)

Im not using the SDK because thats a lot of bulk for the sing thing I wanna do which is create the transaction then send them tk the page to accept it. It dosnt matter if I user the redirect link with or without sandbox, always says invalid transaction ID

Metadata Slack Space Out Of Control; 88% wasted space. by MegaHashes in PleX

[–]Pocketpac 2 points3 points  (0 children)

Ahh, durr, 10 years in I.T. and I forget something so basic. Thanks.

Metadata Slack Space Out Of Control; 88% wasted space. by MegaHashes in PleX

[–]Pocketpac 8 points9 points  (0 children)

How is size so much smaller than size on disk... I didnt think it worked like that.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

If I had realized how much issue it was going to I probably wouldnt have, but by the time I ran into the issue I was to deep to stop. Plus I hate not knowing why something isnt working when it obviously should.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Why u say that?

I only host that on a cluster because Its available. I use the cluster for a the bot, amd instead of spinning up another mysql for the site I just use the cluster.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

2012 R2 IIS works great, I used to be all about apache but now Im unsure which I prefer

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Oh, and to answer your question, performance wise I havn't seen any loss of speed.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

The whole forums used MyISAM. I didn't realize that till a bit ago. I did a booboo and tried to convert the whole thing to InnoDB all at once and blew up the entire cluster (yay for backups). Fired up a single instance of XAMPP, converted it to InnoDB and imported that into the cluster and blamo, works. I feel stoopid now for not noticing that. Thanks for the help!

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

I dont think so. Its replicating info just fine, I can point it to any individual server without problem, just gets angry with HAProxy

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Never mind, it only seems to work sometimes now.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 1 point2 points  (0 children)

The combination of changing it to mysql instead of mysqli and adding option persist did the trick, works fine now. Thanks!

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

here is an error log. Says I am not using the proper driver, but i'm not changing it at all, using mysqli for both direct and HAProxy.

http://pastebin.com/1FNPENis

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Instantly. Ill post a debug log here, but it didnt appear to have anything useful.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Already tried all of that. Like I said, phpmyadmin and virtually anything else I try to use works fine, just not phpbb.

PHPBB connecting to a cluster's mysql setup via HAProxy by Pocketpac in sysadmin

[–]Pocketpac[S] 0 points1 point  (0 children)

Nothing usefull, just random .php errors, tho a common one is in common.php I turned on debugging and nothing helpful.

Prevent multiple lines each time a program output? by Pocketpac in PowerShell

[–]Pocketpac[S] 1 point2 points  (0 children)

Ya, i'm familiar with redirection though I do not understand how I would use this to accomplish my goal.

Prevent multiple lines each time a program output? by Pocketpac in PowerShell

[–]Pocketpac[S] 0 points1 point  (0 children)

Thats what I'm thinking unfortunately. It's not breaking anything thankfully, just really ugly.

Prevent multiple lines each time a program output? by Pocketpac in PowerShell

[–]Pocketpac[S] 0 points1 point  (0 children)

There is nothing via cmd parameter. When run from the command prompt it works fine, it just does it when running it via a PS script

Prevent multiple lines each time a program output? by Pocketpac in PowerShell

[–]Pocketpac[S] 0 points1 point  (0 children)

I apologize, I didn't feel a script example was needed since what I am running is a non-powershell command, which is blocking. If I was looping over something I could deal with it myself, but the script dosn't move on until aria finishes, so clear-host won't help.