This situation after a mains power failure took server down.Log oonto server with root, go to Admin > users and get this message:" The user database cannot be read. This problem is most likely caused by mismatch between /etx/password and /etc/shadow or /etc/group and /etc/gshadow. The program will exit now."
View 2 RepliesUnless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run
mysql - p program </usr/share/program/mysql.sql>
It asks for a password. how do i find out this password.
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 RelatedI'm running RHEL 5. When using the GUI System>Administration>Users and Groups, I get the error: The user database cannot be read. This problem is most likely caused by a mismatch between /etc/passwd and /etc/shadow or /etc/group and /etc/gshadow. The program will exit now.
Some research showed that I need to use vipw and vigr respectively to find an inconsistency between these two sets, which I did - to make it easy I copied each from [vipw | vigr] to an excel file and did =exact(%1, %2). There are no inconsistencies.
[Code]...
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
I Have Configure Samba server in Centos, I need give permission like for some user(5User) can able to read and write the particular folder, and again i need give some another user(6user) can only read permission for same folder.
View 1 Replies View RelatedThis may come across as a bit of an isolated and complex problem, but I haven't been able to get my iPod Nano 5th Generation to have any sort of compatibility with any iPod management programs (except with using Nautilus I guess). This includes gtkpod, Banshee and Rhythmbox.With Rythmbox, my iPod shows up in the pane, but I cannot interact in anyway except ejecting it. There aren't any msgbox errors.Banshee cannot read the iTunes database or something and insists that I rebuild the database on the ipod so I can use it with banshee. I did and gained full access to Banshee's iPod management with all the features it carries. I moved my music library on to the ipod but the thing states that I have zero songs whilst banshee states otherwise.
iTunes on my Windows PC will show that I have x number of GB of "other" information after using Banshee to move music. It seems that it is transferring data sufficiently but is not recognising it as "audio" gtkpod wont let me manage the iPod before or after Banshee's tampering.
I had my server going pretty good. Two sites being hosted. Wilmingtoncoc and Mikealrhughes. Last night we had Thunderstorms and Tornadoes come through. While I was out Tornado chasing. We lost power here for an instant and back on. When I came in the server was off. So I booted it back up. The mikealrhughes site is still working good. The Wilmingtoncoc site is giving me a Database read error, it is a WordPress site. Also I can't log into the Server using SSH. Where do I start to repair the problem? Do I reinstall SSH if so what is the command I use? Then how do I solve the WordPRess Database problem? Also when I try and issue a command from the Server with sudo in front of it I get an error message that says - sudo: must be setuid root - whatever that means. I couldn't find that in any of the books I have.
View 6 Replies View RelatedWe have a Dell PE6600 with a QLA2460 FC HBA in it. Server is running RedHat AS 4.7 (kernel 2.6.9-78), FC driver used is the file qlafc-linux-8.02.23-3-install.tar downloaded from the QLogic website. On this server is an Oracle database running (11.1.0.6). Files for the Oracle database are located in mountpoint /u02. The SAN is an iQStor 2880. Since several weeks we suddenly have problems with the Oracle database after a reboot of the server. After a reboot the mountpoint /u02 is readable and writable (tested by creating, opening and removing files).
However, when we try to start the database we get an error which give you the idea that the database is corrupt. The Oracle error is quite a general error. After doing a lot of testing we found out that if we unmount /u02 and mount it again (using mount -a so it reads the /etc/fstab), the database can be started after all. So the database is not corrupt but for some weird reason we have to remount /u02 first before the Oracle database can use it. We don't know if it's a linux issue, fibre issue, san issue or an oracle issue.
I built the indexes, but when I search I get this: Top-Level Documentation Application Manuals
openSUSE Documentation (en)
Htdig error: Unable to read word database file '/home/philip/.kde4/share/apps/khelpcenter/index//opensuse-manuals_en.words.db'
[code]...
the UNIX manual pages work, the Application Manuals show nothing, and the openSUSE Documentation shows the same error. This is the same no matter what I search for.
I would like to make a script which reads a POP3 mailbox on another server and saves the items in the mailbox to a MySQL database. Is this possible? I have to make this script to create monitoringen scripts which has to use the messages in the mailbox.
View 2 Replies View RelatedI'm attempting to install OpenBiblio to give it a test drive. I'm having trouble with one of the first steps within the openbiblio install guide. The step is dealing with MySQL in creating user priveleges to the db created. The step is:
Create an OpenBiblio database user. To do this, login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice.
mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
-> identified by 'obiblio_password';
When I run the "grant all priveleges" command I receive a syntax error. I've spent some time googleing and it comes up with the same command. There has been a few variations attempted such as 'obiblio_user'@'localhost' but still recieve a syntax error.
Though this might seem like a [URL] question at first glance I don't think it is. I have a mysql database on a server at work. Every time I log in to execute a query, I have to manually select the one database I want from the one database I have, which is a waste of time. Is there any way for me as an end user to set a default?
View 2 Replies View RelatedDoes anybody know if it is possible to hide certain databases from the root user in MySQL?
It may sound stupid, since the root is the root and all that, and it may feel strange but it kind of adds a level of abstraction which I want to give the "root user", and I want to avoid going down the route of creating a new mysql instance on the server.
I had wondered if there is some kind of 'hide' parameter for a database or whether it is possible to change the root username to something else (e.g. 'realroot') and then create a new user 'root' with all the same privileges (except those on the hidden databases).
i'm trying to use the database that was used by vpopmail and vqadmin with postfix and dovecot. By setting up dovecot to use mysql, i can query username and password for authentication but how do i create a user and edit its information in the database? Poastfixadmin only use database that was created along when installing it.
Any viable option aside from recode postfix to meet my criteria?
I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
Error: Cannot connect to the database because: INSERT command denied to user 'webuser'@'localhost' for table 'visitor'
[Code]...
I am looking for advice on a what I am sure is a very basic procedure but I have never had to set this up before and am not sure where to start.
I am running 2 CentOS5.3 boxes. I have one webserver connected to the internet and behind a firewall. I would like to set up the 2nd server (database) behind the webserver and completely inaccessible from the internet. Ideally so it can only be accessed by first ssh'ing onto the webserver and then ssh'ing from there onto the database. The webserver connecting locally to database.
From what I have seen it looks like I need to set this up using NAT but I have never done this and do not know what is involved. Can someone point me in the right direction and optimally outline the steps I need to take to hook this up? Do I need to worry about any specific hardware configuration as well?
Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies View RelatedI have a dedicated server running Centos 5.2. I have a Wordpress MU site that's setup over apache 2, mysql 5, php5, and I use phpmyadmin as well. I'm able to read the database as my website appears perfectly fine, however, I can not write to it. What exactly do I need to install on my Centos sever to allow my site to interface with the database? I've used shared servers and VPS's with no problems but this just won't work. The support team seems clueless and I'm ready to ask them to reinstall my entire OS and everything else again.
View 2 Replies View RelatedI am trying to get a script to run, that will backup all my databases. The script is called automysqlbackup.sh (chmod 744), I have filled in the blanks and placed this into /etc/cron.daily I have checked that crond is running. Nothing happens, the databases are not backed up. I am at a loss, can anyone tell me what i am doing wrong. The script is shown below:
[Code]...
I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard
100m ext2 boot
2000m swap
* / ext3
now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?
I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies View RelatedI just installed mysql and need to move the databases to a new location.I say 'no problem' I shutdown mysql (service mysqld stop) I configure my.cnf to point to the new location, which in my case is: /mnt/data/mysql. I know not very original naming. I do the old chown -R mysql:mysql /mnt/datal/mysql AND I copy all the files over (cp -R /var/lib/mysql /mnt/cgsvol/mysql) chmod 777 /mnt/data/mysql I ensure the chown worked (ls -a -l) and the files are there from the old directory. I can't load the daemon again. I check the log (/var/log/mysqld.log) and it can't write any test file to that directory.
(log file exact data).
091107 23:22:21 mysqld started
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
[code]....
I would like to install this software on linux server for purpose of system reporting. I have all the installation software and the system's specification is based on system need.
View 1 Replies View RelatedHello, I'm trying to set up a read only FTP user; basically, they have the ability to browse a particular images folder and download, but not write (or delete accidentally). I've got it set up so the FTP user logs in directly to the folder, so I'm good with that; but they still have write permissions. We have an application built in PHP that copies image uploads to this folder; it also resizes them in the same folder. So in addition to the main FTP user (me) who needs write access to this folder, whatever the Apache/PHP user is (not sure?) also needs write access. Is there a simple way to affect read/write permissions on a user level?
View 4 Replies View RelatedThis is my first post and there probably will be many more. I've used linux before for short periods but never really tried to learn it. I've decided that I want to study linux and learn as much as I can about it. I dont hate windows or OSX but I really like problem solving and using the command line. Which I used to love with DOS.
I'm going for a complete career change so I want to get certified in Linux by taking the LPI test so I can show employers that I have some computer certification(In Japan it really helps). Now, I'm studying commands and trying to do simple tasks(just playing now) but want to get into it more.
Question: What books do you recommend for a begginner with just dos and windows problem solving experience to start learning linux? Also, what programing language should I pick up a bit for linux?
Assumed I have user called myUser. How to set this user to have the read-right as the root?
View 4 Replies View RelatedI'm facing a problem in a - at least I though it would be - simple BASH script. I use 'awk' to find matching lines in a file, and then use while-read to modify each line matching the expr casted in awk. It looks like this:
Code:
function foo() {
awk '$NF~/^./{print $NF}' FILE.TXT|while read line; do
bla bla bla ...
[code]....
However, each time the execution hits the 'read choice' line, it doesn't prompt - as well as pause the excution - the user for a choice: it just passes it. This problem just happens inside the while loop.
I just installed apt-doc package. My question is how do I read the User Guide in this package ? In general how do I use the items from a package once I install it ?
View 2 Replies View Related