My bose ask me to convert a CentOS system password like "LMPQSMTE0nHlQ" to postfix MySQL MD5 Hased password, I find CentOS seems has 2 kinds of password form, one is shorter and the other is very long like"$1$C2MSk16n$WT5JWnzYH7XpCCjsiE2bd1", however I find postfix is exactly the later long one, so does any one know how to convert the short form to the later one
I have two systems at hand. One a Debian box, the other a RHEL5 box. On the Debian box there is a MySQL server (5.0.32-Debian_7etch1) running which hosts Databases from a customized content management system. This system has grown over time and the tables are stored with different collations. Now I want to export and reimport the data on the RHEL5 MysQL server (5.0.45).
And here the special character hell begins. It doesn't matter if I reimport the data as utf8, as latin1 or latin1_swedish_ci. Everytime the special characters are wrong and distorted. Surprisingly the data that is shipped with the unmodified CMS displays the special chars correctly after installation. But I have to import the modified version from the old server as there are lots of modifications to import.
Old server:
Quote:
character set client utf8 (Global value) latin1 character set connection utf8
[code]....
New server:
Quote:
character set client utf8 (Global value) latin1 character set connection utf8
I am not having any knowledge of mysql database & in my present jobs i have to solve problem on mysql database. need some commands which are used regularily in database.
I used this command to Backup a mysql database [name is cacti]- /usr/bin/mysqldump -uroot -proot cacti > cacti-metadata-backup.sqlHow do I restore Restore this database, on a system that has a clean install of mysql on it. Also I need to restore the owner of this data [in this case cacti]How do I restore the owner and password for create a new one.
Our hardware that is running DNS is very old (Pentium 1 Redhat release 6.2), and I want to migrate the DNS Records to a new computer (Pentium 4 Debian Lenny). There is no GUI environment on the old server: no Gnome or KDE. I may consider using VMware Workstation for this project.
1. I don't have very much DNS experience. Is this a painless process?
2. Are there commands that I can run to export the DNS records from the old server?
3. Are there commands that I can run to import the DNS records to the new server?
4. What other advice do you have that could help this process?
I need to migrate data from Lotus Notes (LN) to MySQL system. I googled around, but didn't find much information about it. The LN has an option to export data like Lotus 1-2-3, which allows you to open the data into excell, but nothing apparently to MySQL. I also opened the MySQLMigration-ToolKit. In the import DataBase System, it doesn't appear LN as an option of supported systems. We are trying to keep things using freeware and cross-platform, although sometimes providing final customer products that run on MS. There is any tool available around, or should we go and code the routines to read the tables from Lotus to MySQL using a programming language like C?
I have postfix and mysql set up on one server running Ubuntu 6.10. I have to upgrade all them at their current versions and ensuring current email service on line. So, I installed in other machine the current versions of the same programs. The oldest server is the current MTA, the new machine is on line but I don't know where I should make changes that allow me move some mailboxes from one to other. I tried reassigning priorities in them MX's records but it didn't work.
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
I have an existing proxy server which connects to my main office in London. I would like to move this server to a guest in Xen environment. Or i can install the proxy server on the guest and copy some relevant files? But please note that the environment is slightly different
Old Server: Redhat 4 with proxy 5.1 New Xen guese: Redhat 5
we are planning to migrate from RHEL 4 to higher version. Latest RHEL available is RHEL 5.5 and also RHEL 6 BETA is released which will soon available for production.
I want to Migrate Win2003 Domain Controller to Samba with All Settings Current Setup: Working Win2003 Domain Controller (DC)with home directories, group policies, shared printer, disk quotas. how to migrate all these settings to Samba Domain Controller. I have tried to search but didn't get detailed information.
I have a problem relate to posttfix.I want to mirgare postfix mail server to exchange 2010 mail server but I can't do it,u can help me.You can show me have to do configure postfix and exchange how to?
I am looking for ideas for getting windows users into an ldap server. I am currently running a Linux server for my department and need to create an LDAP server which mirrors the username/password information for all of us as they are stored in the windows server here. I have the openldap server up and running on Ubuntu 8.04 and it works great; I now need to find some way to import user info into this from windows. I've seen discussions of using ldifde.exe to export the AD users into an ldif file. Is this the simplest way to go about it?
Our Linux server is currently providing us with much needed services using apache, and apache is authenticating using LDAP to our windows server (Using our windows username / password is required functionality). This windows server has some problem which causes it to delay for inordinate amounts of time between authentication requests and responses. The situation is such that this problem will not be addressed by IT staff. However, I have control over the Linux server so I am looking to just mirror the windows server on an LDAP server of my own. I could get away with updating the passwords in the Linux server.
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql; Could it be RAM? or the SQL itself?
I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:
Code: LOG: autovacuum launcher shutting down LOG: shutting down LOG: database system is shut down FATAL: could not load server certificate file "server.crt": No such file or directory code....
I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
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.
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company Password: createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
I have suse linux 10.1 that came with whats looks to be a incomplete sql server. If it works I don't know how to use it because w3schools instruction guide does not work with sql. Anyways I was wondering if there's any database software for linux that could be installed in my webpage directory and used by html files. Or if theres any free cgi database software for linux that i could use with html to create database web pages.
I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:
