General :: Safest Place To Put Database Connection File?
Dec 8, 2010
When connecting to a database in a php script, where would be the safest place to store the connect.php file. I am thinking it should not be in public_html, but is it safe in sub folders or is there a method people generally use to keep such files secure and inaccessible.
The file I mean is one including the database name, user and password etc.
View 2 Replies
ADVERTISEMENT
Sep 28, 2011
I am trying to parse a line from a file and place the values into separate variables:
input.txt:
Code:
CreateVegaFeed-20110928-before-skip-start
this is the code i have done so far:
Code:
$input_file="input.txt"
INPUT_FILE=`cat $input_file`
for i in $INPUT_FILE
[Code].....
View 14 Replies
View Related
Sep 19, 2011
I want to copy all files with the name XYZ* into one folder. The problem is that the files are in different subfolders and that not even the depth of the folder structure is the same for all files. Luckily, at least each file has a unique name.
Of course, I thought about the cp command but I guess the depth of the folder structure needs to be the same for this to work.
View 3 Replies
View Related
Jan 24, 2011
i resently bought HCL ME with windows, i formatted and installed Ubuntu netbook version. i am getting wifi is not connection it looks disabled in network place. my network controller is Realtek semiconductor co., ltd rtl8191sevb rev 10, i am unable to get this driver to install can anyone help me ?
View 2 Replies
View Related
Jul 14, 2010
parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle database.
View 3 Replies
View Related
Jun 26, 2011
i want to write a program that need to know how much data has transmitted in network usage _how much send and how much received_which file , record or structure in which library i have to follow ?
View 2 Replies
View Related
Aug 15, 2010
I am now using SLES11. My web server now error mysql. However, when I restart mysql using "rcmysql restart" the message display:
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL done
but when I start to access via browser using my name virtual host (url) the message display "Error establishing a database connection"
when I go to mysql using command "mysql" the message display"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
After that I try to edit file mysql.sock but on the bottom of file display message (permission denied)
View 6 Replies
View Related
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
View Related
Jan 24, 2010
I'm interested in using pam_mysql or pam_ldap for authentication with my vsftpd server on CentOS. Does anyone know if, when pam_mysql connects to a remote database, whether or not the connection is, or can be, encrypted with SSL or some other means? While I know that passwords are hashed, I'd rather not have my usernames or my pam-related SQL queries travel in the clear.
If pam_mysql DOES communicate only in the clear, what about pam_ldap? I'm more familiar with LDAP than pam_mysql, and have always secured my conversations with LDAP servers when using an LDAP client or my own LDAP connection libraries.
View 3 Replies
View Related
Jun 2, 2010
I have a script that among other things generates a makefile with an error that causes make to fail. specifically, the string "-Wimplicit-function-dec" should be changed a bit to "-Wimplicit-function-declaration". Is there a way to have bash add the new eight characters in the right place (on line 105)?
View 2 Replies
View Related
May 21, 2010
First i get drupal package :-
"sudo wget http://ftp.drupal.org/files/projects....tar.gz"
this will download the Drupal file into current directory.
> unpack the files issue the command
"tar -zxvf drupal-6.13.tar.gz"
this will extract the files into a folder in home directory > make a directory in the web root folder to keep the Drupal files in. To do this type in
"sudo mkdir /var/www/drupal"
> move the Drupal content over to the web folder. Type in
"sudo mv drupal-6.13/* drupal-6.13/.htaccess /var/www/drupal"
> set up folders for media associated with the site to do this issue "sudo mkdir /var/www/drupal/sites/default/files"
[Code]...
View 2 Replies
View Related
Apr 24, 2010
I was wondering if you could help me how to measure the time needed for Ubuntu to copy a file from one place to another.
View 2 Replies
View Related
Mar 27, 2010
I wanted to know how can I change the default place of shared object files of a program in a system. let me explain it better for you : I have an embedded computer with Linux OS that its file system is read only and I can not add any file to /usr /lib and ..... and I can just mount a SD memory card to it and copy all of my programs to it and run them from there as you understand I have two choices to choose, first make one big binary file for each program that I am doing it now and it is not a suitable solution and the second is finding the way to change default place of shared object file of my program.
View 1 Replies
View Related
Mar 2, 2010
I'm try to setup a database server using mysql, the server starts fine, and I can access it using the built in mysql client via console (adding databases and tables works fine), but the problem is... I always get a connection refused error whenever I access the database outside the built in mysql client (example, if I write a code that connects to mysql). So, I tried execute an nmap command and the only ports open are these ports:
[Code]....
there's no 3306 for mysql... I'm thinking that the firewall is just blocking the port that mysql is using, but my question is, how could the built in client connect to the server if there's no open port for mysql server? Don't clients usually access a servers through ports?
View 4 Replies
View Related
Jul 10, 2010
got a weird one with an upload script.Max upload sizes all set v high (200m)Works fine with 100Mb+ files on the linuxbox, but when I try from my mac via network ip address there seems a fils size limit of somewhere between 15 - 20 Mbis there a place to set remote file sizes differently to localbox settings
View 1 Replies
View Related
Jan 3, 2010
I downloaded the ubuntu server (command line only) iso and set up a server on a spare computer. The only partition is ubuntu. LAMP server installed, and runs. Its plugged into my home network and the router assigns it a DMZ. I use ptty and that allows me to connect the server from my Windows PC. I installed samba and that works, I set up the server as Z: to my windows PC, and I can now use Filezilla FTP to move gigs of files over from my windows PC to the ubuntu server. I have to log in to activate the connection to Z: but it works.
Problem is getting a database connection from my windows PC (client) to my ubuntu server. Server is running a MySQL server and an Apache Derby server but both give connection:refused every time I try to connect with a java app, or with ij from my client. I tried MySQL Workbench, as that has a GUI, that doesnt connect to MySQL either. Every time I start my server I have to add lots of jar files to the CLASSPATH just to get the Derby server running. The Derby client connection on my client PC is also properly set up with PATH and CLASSPATH etc etc all configured and tested. But the server refuses every attempt to connect even though it tells you the Derby server is up and runnign as listening on port 1527!!!
What I want is a script or app that will "unlock" my server so I can actually do something with it instead of constantly trying new settings and packages in the vain hope it will then actually 'serve'. I am missing something here. There is nothing of value on this server that cannot be 'exposed' to the internet, so I'd be happy to turn off all the security just so the damn thing allowed connections...!
View 2 Replies
View Related
Jan 5, 2011
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies
View Related
Sep 8, 2010
I'm running MySQL 5.0 on a production server and I require to upgrade mysql to version 5.5 to get a new collation support. What is the best procedure to follow? I cannot find MySQL 5.5 on the standard repositories. A yum install would be the safest, correct?
View 2 Replies
View Related
Apr 6, 2010
I would like to change my username (or login name) and am wondering what the safest route to do so is. The install is on a headless server, which I just use ssh.There's a) using usermod -l newname oldname. The line in the usermod man that says that changing the login name doesn't change anything else, which makes me think that something else is bound to break. I've also considered b) creating a new user, moving the contents of my home directory to the new user, and deleting the old user. This is kind of cumbersome, but would this be the recommended way to ensure everything goes well (considering I still have to redo some config files).
View 5 Replies
View Related
Mar 9, 2010
The latest kernel(2.6.32.9-67) is causing problems for my laptop.What are the best practices for safely removing a kernel?( Yum wants to remove gcc and friends also...)How can one prevent Software Update from relisting the bad boy?
View 6 Replies
View Related
Feb 5, 2010
So what is the easiest way to install Ubuntu with win7 also on the computer?I'm asking because last time I ran Ubuntu it was Wubi'd into XP and then it broke, breaking XP's bootkernel and then keeping me from booting into anything...
View 5 Replies
View Related
Jun 24, 2010
Want to know if using a live CD, say Knoppix, gives a good level of protection when moving money about? I am very unsophisticated on the subject of security.This question has been addressed before on this site Code:if you have enough RAM you can ignore your local disks all together, and avoid the security risk of a swap file
How you do that then?Perhaps it would be better to use an operating system inside the software computer, virtual box, that only ever gets used for this b*nking purpose?
View 14 Replies
View Related
May 31, 2011
I have a script which when invoked will generally su into being a number of different users (for those that have read other threads from me, you will know.I am building my own user based package management system).Whilst 75 - 80% of the time there will be no need to be anyone other than the original user, there are times when the root password is required. Currently this is presented to the administrator at exactly the point in the script that it is required.At times this may be more than once and it may also happen for multiple users in a row.
What would be the best / safest method (in your opinion) of capturing the password at the start of the script and then delivering it when required?I have looked at expect ( I am not at all familiar ), but on the examples dealing with passwords, that I could find, they all seem to store the password in a simple bash like variable (which does not excite me at all from a security point).I can also potentially go down the sudo road, but the issue here is that I would either have to find a list of commands that an entire group can have access to without passwords (doesn't sound safe) or I am back to square one of then requiring a password for each individual user to be entered, which if at the start would still need to be captured and saved until necessary.So as I have said, I am open to any and all (constructive) advice
View 14 Replies
View Related
Mar 5, 2010
I need to run fsck on a large partition on my server on a periodic basis. In many cases, however, files are left open on the partition, e.g. XMing sessions are often left open for weeks at a time because connection is hit-or-miss, or jobs are left running.
My first thoughts are to shut down the daemons I know are using the partition, then traverse lsof for processes that have files open on the partition and do a SIGHUP, SIGTERM, SIGKILL sequence on them. One problem I see with this is that in some cases a script might be running a loop that performs a process on the partition. For example, suppose loop.sh is running from ~ and it loops process.sh over the files in /data (i.e. the partition in question.) The first signal would end process.sh, but loop.sh wouldn't be touched, which would allow it to proceed to the next iteration, etc. until the final instance of process.sh would get the SIGKILL and yet another iteration would start. Killing process groups might help here, however.
Ideally I would just go to init 1, check the filesytem (maybe run a backup,) then go back to init 4 (running Kubuntu, so no init 3.) I'm not exactly sure how to pull that off without the filesystem check happening every time the server goes to init 1, however.
View 6 Replies
View Related
Jan 5, 2009
I am trying to unload file from a database. Which contains few lines with the character below. Rest of the data was unloaded appropriately.
Code:
a) What does this below character means?
b) How can i remove it,
I already have
Code:
sed '/^$/d'
c) Will this effect the file by any means (If I am guessing properly, this is the eof notation)
View 5 Replies
View Related
Jul 28, 2011
I would like to attempt creating a cron job to backup my root (/dev/sda1) & home (/dev/sda3) partitions to an external USB drive.I have been using Clonezilla to make image backups but, I have to physically do it, when I remember or have the time. I have never created a cron job, and worse, I have never created a .sh file which, I think, is what I need to do.
View 12 Replies
View Related
Jun 12, 2010
I have a software program that when you try to install it on Centos it returns "This programs requires RHEL 4" Is there a work around to get the software to use the Centos software the same as it would RHEL 4?
View 6 Replies
View Related
Mar 12, 2010
I have just installed slackware 13 on an old machine I am bringing back into use. As I have a spare Linksys wmp54g card I would like to try to get the wireless networking in place.From reading the forum the relevant advice seems to be fairly old (2004-2006). I wonder if anyone can advise me what the current steps would be?
View 3 Replies
View Related
Aug 8, 2011
I have migrtaed from Arch, my first experience with linux for the past 2 months, to Debian and i'm currently setting up my system. I have a X61s Thinkpad with a cracked screen which i use with the ultrabase with an external monitor and keyboard. The monitor requires me to use fbset on console and xrandr for a graphical enviroment Whilst i was using Arch i used 'startx' to access openbox and placed my xrandr configuration in ~/.xinitrc but with debian i have wanted to use a login manager, Slim.
Because i am using KMS for my intel based system i don't have an xorg.conf and because i am using slim i am not using ~/.xinitrc I read somwhere that creating an ~/.xprofile file would solve this but i have not had any luck. So i am wondering where would be the best place to put the xrandr configuration?
View 1 Replies
View Related
Oct 20, 2010
I'm using kubuntu 10.04 LTS and i need to open a wdb or a mdb (database file) and then save in one of those formats for a computing course I'm doing.
View 2 Replies
View Related