I've got several servers running RedHat4 ES, alongside several Windows 2003 servers with MS SQL on them.
Is there a MS SQL Client for Linux so I can connect to the SQL Server databases?
I'ev got Oracle running as well, and I can back these up from my linux boxes easily as there is a Linux ORacle client. I'd like to do the same with MS SQL, so I have one central location doing my database backups .
all of the website content will be on a separate partition called "/websites". I've got SELinux enabled, and set the context on /websites and subdirectories to "public_content_t", so that httpd (Apache) can access this partition. This works. However we also have mysql databases stored on this partition as well, and we are getting errors like this in /var/log/auditd/audit.log: type=AVC msg=audit(1286249333.390:326): avc: denied { search } for pid=6167 comm="mysqld" name="/" dev=sda3 ino=2 scontext=system_u:system_r:mysqld_t:s0 tcontext=system_u:object_rublic_content_t:s0 tclass=dir
I've tried setting the context to "mysqld_db_t" on the MySQL database folders, but it appears that it cannot get to the partition at all, or anything outside of /var/lib/mysql/. How can we get mysqld to access databases on this partition? Right now there are symlinks from folders in /var/lib/mysql/ that go to each database on /websites partition. Setting SELinux to Permissive mode gets everything to work fine. Basically with SELinux in Enforcing mode, we're getting errors in the PHP applications that httpd can't connect to the databases.
I have installed mysql ,php ,apache,phpmyadmin i have create a forum on mysite check it on[URL]..Now i have create a database with name login and then i create a table with name loginn ..After that in loginn table i create colums with name username (data type=varchar),and password(data type=int);i want when someone entered username and password in my sql ,it goes to database and userconnect to next page as we generally do in orkut or other social sites;I dont know how to connect with php with mysql and how to do it whole
View 3 Replies View RelatedI need to move mysql databases from my hard drive which is currently in external box. I can't boot the drive since the laptop is down. Nothing of the distribution on the drive is missing. I just need to know which files/folders copy to my new computer to have all databases running. Old computer ran on Dreamlinux (Debian-based). I'm currently running Ubuntu 9.10.
View 5 Replies View RelatedI just found that PMON and SMON are running (i.e., showing in the output of ps -ef | grep -i [o]ra)but when I check MMAN (used for internal database tasks), nothing comes up:
Code:
ps -ef | grep -i [m]man
Is that okay or could there be some problem?
So, what are the essential processes of an Oracle Databse that we must check for their status to make sure that the Oracle Databse is up and running fine? What steps do you usually take to validate an Oracle Databse on a Unix / Linux (Production) Server (specifically immediately after a CR has been worked upon)?
I have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
Rebooted my server after some funky stuff started happening with mysql. Turns out the drive that stores the mysql databases has gone missing. I did an fdisk, and the partition table is gone. I used gpart to see if there were any partitions available & there were -- two + one swap. Can you help me put this back together I know very little about reconstructing a table to use... Here is the output of what I've talked about...
b14:~# fdisk -l
Disk /dev/sda: 164.6 GB, 164696555520 bytes
255 heads, 63 sectors/track, 20023 cylinders
[code]....
how can I display all databases and their size using command lines (linux) in a mysql server?
View 3 Replies View RelatedI was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
I have fedora 11 installed for over 6 months, and I love it. I do have a problem and forthe life of me can't figure it out. This problem started overnight: When i click to places----connect to server
I put ftp with login I also put the server ip address and the username. After about 2 minutes, i get this error Cannot display location "ftp://myusername@29.98.201.213/" cannot connect to host
[Code]...
i want to share my problem that after updating fedora 12 by my mobile broadband. mobile broadband connection stopped working. i mean now it can't connect to the server.
View 1 Replies View RelatedI have a fedora machine have apache server and from the .php on this page I am trying to connect to mysql database on another pc on my lan. But I get this error Failed to connect to server: Can't connect to MySQL server on '192.168.1.21' (13). What can be possible error? I dont know what else to search? I have php info page and can see the mysqli on this apache server?
View 9 Replies View RelatedAt first, I was trying to update Yum and it gave several messages saying it can't connect to the website.
This problem has happened in Fedora 12 for a week now.
I can use the Internet in Windows but not Linux? All the settings are correct: It just won't connect to the Internet.
I use a version of Ubuntu Desktop Edition 9.04 and installed various server software useful for my needs.
New issue. How do I get MySQL databases working on this system, and how do I get myPhpAdmin to help manipulate said databases onto the system?
My /var/database/ directory is filled..!
Is there any way to redirect some databases to another directory .
I'm trying to record video of a game I am playing. I am using gtk-recordmydesktop but it records the audio from my mic. This is obviously not what I want. The apparent solution was jack, but I've been having a hard time getting it to run. According to #fedora I was told to get qjackctl and jack capture. When I try to run qjackctl and click the "start" button I get this long nasty error:
Code:
15:11:41.006 Patchbay deactivated.
15:11:41.008 Statistics reset.
15:11:41.024 ALSA connection graph change.
15:11:41.240 ALSA connection change.
15:11:42.091 Startup script...
15:11:42.091 artsshell -q terminate
15:11:42.532 Startup script terminated with exit status=256.
15:11:42.533 JACK is starting...
15:11:42.533 /usr/bin/jackd -R -dalsa -dhw:0 -r48000 -p1024 -n2
15:11:42.538 JACK was started with PID=4302.
*** buffer overflow detected ***: /usr/bin/jackd terminated .....
15:11:42.589 JACK has crashed.
jackd: no process killed
15:11:43.015 Post-shutdown script terminated with exit status=256.
15:11:44.683 Could not connect to JACK server as client. - Overall operation failed. - Unable to connect to server. Please check the messages window for more info.
If I use Nautilus server conect, I can see my NAS smb shares, but I keep getting asked for password and cannot get into these shares.If I do a mount on these same shares, as root, they mount no problem using same username and password.
View 1 Replies View RelatedI've got a FC PPTP server up and running but can't connect to it using VPN. I'm using NetworkManager but the connection fails each time. On the server, I'm seeing the following in the /var/log/messages:
Quote:
May 8 16:37:05 li99-23 pppd[2113]: Plugin /usr/lib/pptpd/pptpd-logwtmp.so is for pppd version 2.4.3, this is 2.4.4
May 8 16:37:05 li99-23 pptpd[2112]: GRE: read(fd=6,buffer=8059780,len=8196) from PTY failed: status = -1 error = Input/output error, usually caused by unexpected termination of pppd, check option syntax and pppd logs
[Code].....
Ive checked that the name,passwords all match, which they do. Has anybody seen this before ?
I recently wanted to connect to a vpn server which its tunnelling mode is L2TP.how I can configure my FC 12 to connect to this vpn server?I mean in which files I should enter that server's IP and my username and password.
View 3 Replies View Relatedi can't connect to my server using putty.
I have a virtual dedicated server, running - Linux Red Hat Fidora core 6- Pentium 4, 3ghz
I'm attempting to use Putty to log in SSH, but I'm getting an error.
Saying the sever unexpectedly close network connection.
I don't know if this has anything to do with it. This is a new computer, that hasn't logged in using putty before. Also I'm on a home wireless network. It dosen't seem to be a firewall issue, the error message pops up, when the firewall is disabled.
And I just had Go Daddy do a reboot. Oh, and I think I might have entered my password incorrectly a few times, last night.
I remember the Go Daddy rep, saying that my IP address may be flagged, but that it would unfilter and unlock it self within an hour or so. It's been over 24 hrs.
Before the password issue, i was able to log in.. But i can't now.
Others can log in. So there unable to duplicate the problem.
I'm new to Linux, and SSH.
Any help
I'm trying to install some software...
How often are dns queries sent? Assume I want to connect to a ssh server, will I send one dns-query in order to do that or do I send multiple during my connection? What if I request web-pages, do I send a query only when I enter a site or will I send queries every time I visit a new page on that site?
I'm asking since I'm considering getting an account at dyn.com (the standard account for $30/yr) and it comes with 600 000 queries per month (which is way more than I expect to get but knowing exactly what it means is always good).
I am not able to connect to server through putty, my collegue is able to connect to same server from his desktop through putty.
I am getting ssh session and after providing user id an password its stays still and no error message. firewall and se linux is disabled and also i checked tcpwrappers there is not restriction given.
I am very new to Linux, 1 week old. Have just installed fedora 5 days ago and I now need to get hosts to connect to this server through telnet. I downloaded a xinetd rmp file but do not know what do next to get it installed and configure it.
View 4 Replies View RelatedIs there any program to create databases graphically? Something like Glom maybe?
View 3 Replies View RelatedQuick searches did not bring forth any standard solution.
I have installed Ubuntu Server 10 (x64) using LVM with two disks (this is a Virtual Machine on VMWare ESXi4)
During install I selected only disk 1, and LVM guided Installation Added LAMP and SSH
Server gives only a text mode configuration, great if you are a linux guru, but I am not so it took a bit to find a stripped down GUI. None could be found but I did the following:
apt-get install xorg gdm gnome-core (minimal Gnome install)
apt-get install gnome-system-tools (users and *****s, time)
apt-get install gnome-network-admin (network config)
apt-get install update-notifier (updates)
[Code].....
I have created a similar system with Ubuntu, now I wish to move the var/www directory to sda1, and the databases from MySQL.
Trying to set up a backup for mySQL databases in CRON.
I've entered the following line in /etc/crontab:
Code:
7 13 * * * root mysqldump -u root -pMYPASSWORD --all-databases | gzip > /home/myuser/mysql_backups/database_`date '+%Y-%m-%d'`.sql.gz
grep CRON /var/log/syslog shows:
[Code].....
If I run the command outside of CRON, it creates the backups no problem, but CRON is not doing anything.
I have a laptop and a desktop PC, both running Ubuntu 10.04 and both are configured the same way. I am using Unison-gtk to sync the data between both computers... This works for everything... except for my mysql databases. Any way to simply sync my mysql databases on both computers. Right now I need to do this table-per-table... and it is quite long to proceed like this. What I need is a script or a program (open and preferably free) that would just compare both databases (all the tables) and sync them either by updating existing tables or by creating them. This should work both ways... obviously. I could write a script for this, but I am sure there already is something for this out there.
View 9 Replies View RelatedI was wondering if there is any linux command to list all the databases on the system. I have PostgreSQL databases on my system. I can list them through the psql console, but I cannot do that in a shell script. Hence the need for a linux command.
View 2 Replies View RelatedI succeeded in setting up a vnc server on a fedpra9 tested it locally and it was successfully connected but no connection done from other machine in the network , even though they can see each othervnc server is pingable se linux is disabled
View 9 Replies View RelatedI have just migrate from UBUNTU to Fedora 11. Tried to install cacti by 'yum install cacti' everything presumably went correctly. But when trying to get cacti running on a browser it's showing:
Code:
FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
Checked everything else including installing new mysqld-server (using yum install) and still not working.
Trying the installation steps from [URL], but could not find where mysql was installed. Mysqld should already be running, cos I can see it using webmin-server-mysql. Did a test as shown on [URL], everything seems ok. No major problem when using UBUNTU with apt-get install.
