Server :: Migrate DB From Lotus To MySQL?
Sep 11, 2009
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?
View 3 Replies
ADVERTISEMENT
Feb 27, 2009
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
[code]....
View 1 Replies
View Related
Aug 20, 2009
I am trying to launch the IBM installer on RedHat ES 5.2 and getting "the installer is unable to run in graphical mode". I am able to do xclock and made sure the export Display=:0.0.
View 3 Replies
View Related
Aug 29, 2010
I'm installing Lotus Domino on Linux Server. Did anyone know how to reverse proxy for HTTP and POP3/IMAP on linux ? I've problem when try to open webmail from internet. I can't access webmail and POP3 from internet. Seems because connection from internet can't directly to Domino through Firewall. If using apache seems no problem with the webmail, but POP3 still can't access.
View 5 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Oct 10, 2010
this is vinoth. im using redhat el5 . i want to migrate windows 2003 server active directory with redhat linux el5 2.6.18-8.el5
View 2 Replies
View Related
Nov 3, 2009
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?
View 2 Replies
View Related
Nov 8, 2010
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.
View 1 Replies
View Related
Feb 15, 2010
I'm migrating a mailserver from an old to a new mailserver. The new mailserver is based on ISPConfig 3.0.6.1.
I would like to migrate what spamassassin learnt in the past from the old mailserver to the new one. Now the question:
- The 2 spamassassin versions are different. Is it a problem?
- Can I just migrate the database with this commands???
Code:
sa-learn --backup > sadb.bkp
sa-learn --restore ./sadb.bkp
-how to migrate SpamAssasins Auto White List and all others SpamAssassins databases?
View 3 Replies
View Related
Jun 16, 2010
I need to make a backup of the ldap (users and passwords). Is there a tool to do this? I've found o the internet only the shadow to ldap version
View 1 Replies
View Related
Jul 20, 2009
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
View 1 Replies
View Related
Jun 3, 2010
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.
View 1 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Sep 27, 2010
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.
View 14 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
Nov 3, 2010
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?
View 1 Replies
View Related
Jun 18, 2010
I 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?
View 1 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
Jan 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 3, 2009
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies
View Related
Nov 18, 2009
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.
View 1 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Nov 20, 2009
I am running Lotus Notes on top of openSuSE since 10.3 and version 7 of Lotus Notes. The last packages provided by IBM (8.5 and 8.5.1) provide a smooth and easy way of installing it through rpm packages. Some issues had appear and I solved them (or lived with ), but this time I did a full fresh install of 11.2 64bits. I then install the brand new packages of Notes 8.5.1 and had the following problem : The Notes GUI wasn't able to display some elements of the interface (i.e. small view of calendar, search bar, popups, Notes basic settings in the properties etc...). Searching by big blue, I found out a solution for Ubuntu that I customized for openSuSE 11.2 64bits.
Step one : Install Lotus Notes: Have a copy of the .tar package from IBM. untar it into a new directory. With YaST add the directory to the repositories Install all the packages provided (the ones with Symphony are really optional).
[Code]....
View 8 Replies
View Related
Apr 1, 2010
I am trying to get Notes to run on Ubuntu 9.10 karmic x64 and haven't had any luck. I started off by following the steps from the following location [URL] This didn't work and I had the symptoms listed below. I then looked at the following guide and did all the steps that were not on the above link: [URL] However I still had the same issue. So the symptoms:
1) I don't see notes in the apps->office menu, but I am able to start it via:
cd /opt/ibm/lotus/notes/framework
../notes
2) I get the login window and am able to go through the setup (pointing to the notes id file, and my domino server etc). However at the end of it all, no GUI is displayed. Even though lnotes shows up in the running processes.
3) In the terminal window I get the following error:
Gtk-Message: Failed to load module "canberra-gtk-module": /usr/lib/gtk-2.0/modules/libcanberra-gtk-module.so: wrong ELF class: ELFCLASS64
(:6077): Gtk-WARNING **: /usr/lib/gtk-2.0/2.10.0/engines/libmurrine.so: wrong ELF class: ELFCLASS64
(:6077): Gtk-WARNING **: /usr/lib/gtk-2.0/2.10.0/engines/libmurrine.so: wrong ELF class: ELFCLASS64
[code]....
View 2 Replies
View Related
Aug 27, 2010
With the release of Lotus Notes 8.5.2, it looks like Ubuntu 32bit support is there, however I am running 64bit Ubuntu 10.04.
I had 8.5.1 (32bit) installed and it was working fine. I did take alot of tweaking to get it running.
Just wondering if anyone has tackled the new 8.5.2 which is supposed to be much nicer in Ubuntu.
I've tried removing the old 8.5.1 and the install for the 8.5.2 doesn't really work correctly even with "--force" commands.
Always a challenge with Notes and Ubuntu Why they didn't make 64bit debian packages is beyond me.
View 2 Replies
View Related
