Search Results

Search: Posts Made By: Astrocloud
2,249
Posted By Astrocloud
Run sql script and send to mail if not empty?
Thanks again for helping me out.

I was wondering if anyone else has encountered this issue.

I have a SQL script that produces a list -however we are only interested in that list if the length...
Forum: Web Development 07-29-2013
1,791
Posted By Astrocloud
(WHM) Primary Resolver and Nameserver confusion
Okay,

I know generally how the internet works but here I am confused. Every website that I've worked on prior to this had a vendor providing Nameserver services -Meaning that I just pointed my DNS...
Forum: IP Networking 06-20-2013
1,348
Posted By Astrocloud
Internet QOS woes
I'm looking for recommendations for a general problem.

Apparently (that is according to my boss and coworkers) I am responsible for guaranteeing quality of service to our remote MySQL server...
4,719
Posted By Astrocloud
I found a tutorial ...
I found a tutorial

https://blogs.oracle.com/jkini/entry/how_to_scp_scp_and

---------- Post updated at 04:03 PM ---------- Previous update was at 03:26 PM ----------



I got my original...
4,719
Posted By Astrocloud
Man Page for sshd (linux Section 8) - The UNIX...
Man Page for sshd (linux Section 8) - The UNIX and Linux Forums (https://www.unix.com/man-page/linux/8/sshd/)

Helps
4,719
Posted By Astrocloud
When I went onto my foreign server there was...
When I went onto my foreign server there was already a file called ~/.ssh/authorized_keys and there was another called ~/.ssh/authorized_keys2 so I made one called

~/.ssh/authorized_keys3

I'm...
4,719
Posted By Astrocloud
I'll try this. Generally, if a...
I'll try this.




Generally, if a question is misinformed -it's because the questioner doesn't understand something. So to answer your question: exactly as it sounds. How does SCP use keys to...
4,719
Posted By Astrocloud
Public and Private Key generation for scp
Hi,

What tool is used to generate public and private keys for SCP?

Do you have an example script that generates these keys, puts them in files and then another example script that references...
Forum: Red Hat 06-01-2012
1,483
Posted By Astrocloud
check system resources (VPS) to see if match what I paid?
-bash-3.2$ cat /etc/redhat-release
CentOS release 5.8 (Final)

Hello,

Our company recently paid a hosting company (who shall remain nameless) with certain service guarantees. Is there a simple...
4,919
Posted By Astrocloud
I think this is the right way to go. In the above...
I think this is the right way to go. In the above example something like;

#! /bin/sh
expect -c 'spawn scp -P 22 astrocloud@www.mywebsite2.com:/home/mywebsite2/www/gcc/cb/test.txt...
10,962
Posted By Astrocloud
After pointing to a direct location of DB.php...
After pointing to a direct location of DB.php -the error was:

"DB Error: not found"

Now (miraculously) the error is gone.

Then again it could be that I asked the hosting company to...
10,962
Posted By Astrocloud
I did it is above. -bash-3.2$ ls -al...
I did it is above.
-bash-3.2$ ls -al ~/public_html/include/DB/DB.php -rw-r--r-- 1 mywebsiteDirectory mywebsiteDirectory 38997 Apr 16 10:44 /home/mywebsiteDirectory/public_html/include/DB/DB.php
But...
10,962
Posted By Astrocloud
Unfortunately it is still no dice. I...
Unfortunately it is still no dice.

I 'chmoded' the file in question so that it executes.

The error is the same.

"DB Error: not found"
10,962
Posted By Astrocloud
I've tried that with the full path (that I think...
I've tried that with the full path (that I think it is), I listed a search for the full path and tried replacing it with several.

When I replace it with

require_once...
10,962
Posted By Astrocloud
Line 7 is; require_once 'DB.php';----------...
Line 7 is;
require_once 'DB.php';---------- Post updated at 09:58 AM ---------- Previous update was at 09:54 AM ----------


1 <?php
2
3
4 //require the PEAR::DB...
10,962
Posted By Astrocloud
No problem; require_once 'DB.php'; ...
No problem;


require_once 'DB.php';

$db_engine = 'mysql';
$db_user = 'mywebsiteDirectory';
$db_pass = '*********';
$db_host = 'localhost';
$db_name = 'mywebsiteDirectory_testlogin';
...
4,919
Posted By Astrocloud
Having a hell of atime with KSH -ftp automation
Following this thread:
https://www.unix.com/ip-networking/1935-automated-ftp-task.html
I have created the following script:

#! /bin/ksh

HOST=ftp.mywebsite2.com
USER=astrocloud
PASSWD=8****
...
10,962
Posted By Astrocloud
Migration of website... PHP/Mysql -which path for DB.php
Hi,

I have two websites:

website1.com and website2.com

I didn't write either but have successfully moved all the files from website1.com to website2.com

I (thought) I installed all the...
Forum: Programming 05-04-2012
4,996
Posted By Astrocloud
So when I do the "having" clause it returns the...
So when I do the "having" clause it returns the first value on the list because it only scans the first element and then reads in this first value as being max -so "done"

Well, I guess code is...
Forum: Programming 05-02-2012
4,996
Posted By Astrocloud
Getting Rows from a MySQL Table with max values?
I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work.

Basically I wrote code like this:

select * from `Test_DC_Trailer` HAVING...
15,978
Posted By Astrocloud
Every file ending with php (*php) in every...
Every file ending with php (*php) in every directory below a given location

so I execute it in /root then it will execute in
/root/home,
/root/home/astrocloud, ...
15,978
Posted By Astrocloud
sed through all subdirectories?
I found this awesome sed script here:

https://www.unix.com/shell-programming-scripting/48228-perl-search-string-line-then-search-replace-text.html

sed -i '/MatchText/ s/ReplaceMe/REPLACED/'...
Forum: Web Development 12-01-2011
19,380
Posted By Astrocloud
If you have more than just a term, you may try...
If you have more than just a term, you may try open office for linux

OpenOffice.org - The Free and Open Productivity Suite (http://www.openoffice.org/)
Forum: Web Development 11-29-2011
6,518
Posted By Astrocloud
Well I removed the hyphens but still get the...
Well I removed the hyphens but still get the error:


Set @BFBW = CONCAT("BFBW", DATE_FORMAT(CURDATE(), '%m%d%Y'));
#Select @BFBW;
CREATE TABLE (SELECT @BFBW) (
TenantId LONG
, PostDate...
Forum: Web Development 11-29-2011
6,518
Posted By Astrocloud
MYSQL: Creating Dynamic Table Names 5.1
Hey everyone. Thanks for looking at this.

I'm trying to create a table with the dynamic name of TableName + today's date.

My variables are all happily created but the system chokes when I try...
Showing results 1 to 25 of 43

 
All times are GMT -4. The time now is 10:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy