Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup.
The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information.
I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration.
I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Complete Forum Thread with Replies
Related Forum Messages:
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to install the binaries recommended on MySQL. However, when I run the mysql client, I get simply: Segmentation fault. So I tried to do a basic source compile, which went fine, but when I run mysql client, I get this: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 4.1.12 Segmentation fault When I try the flags recommended by MySQL (--with-extra-charsets=complex among others), the make test fails on ucs_binlog - something to do with charsets I believe? The mysql user, group etc. are all set up. Strangely, the mysql client works in batch mode so if you make a file that reads: SHOW DATABASES; Then type: mysql < commandfile It'll display Database mysql test Without any faults.... Anyone any ideas or suggestions?
View Replies !
Foreign Key Constraints Dont Work (suse Linux, Innodb)
i changed standard storage engine to innoDB and created tables to test the foreign key constraints: create table prof ( id integer auto_increment, name varchar(30) not null, primary key(id) ); and create table lesson ( id integer auto_increment, profid integer, name varchar(30), primary key(id), foreign key(profid) references prof(id) on delete cascade); now, when i delete a dataset in "lesson", it should delete the corresponding dataset in "prof" right? also, i shouldnt be able to create a dataset in "lesson", when there is no prof with the provided id i think. but it doesn't get deleted, and i also can create lessons with any profid, even if the prof with that id doesnt exists.. somehow the foreign key constraints dont work
View Replies !
MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us. What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job. Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days. So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery. How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
View Replies !
Windows Mail Server
I'm curious what mail server is reccommended for interaction with mysql on windows. Our basic requirement is to have the mail client send e-mails based on addresses in the db (not spamming - for password resets, etc).
View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
View Replies !
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it. When i try to connect the ODBC allways returns the following error: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001) I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc... The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.
View Replies !
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net. Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine So please tell me process 1 have to simply upload my mySql database in Public Html folder or else where i m using cPanel file manager to upload files
View Replies !
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: [root@psiche root]# mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the mysql_install_db it reports some errors: "asked for 196608 thread stack, but got 126976" and "to start mysql at boot time you have to copy support-files/mysql.server to the right place for your system".
View Replies !
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting. I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.
View Replies !
MySQL Not Integrating
It appears that my the MySQL server on my machine is not integrating or being loaded in order to be utilized. I have both installed and configured it myself, along with installing and using the installer configuration, yet neither seem to solve the problem. No matter what, MySQL web sites such as PHP-Nuke, or any forums I attempt to install do NOT read that MySQL is available for use. The port is forwarded, it's installed and configured, yet it won't read it.
View Replies !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux ) WHM 11.11.0 cPanel 11.16.0-S18450 REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0 after update apache then all websites on server can not connect mysql from WHM > Tweak Settings > Mysql > 5.0 and used old style (4.0) passwords with MySQL® 4.1+ also command /scripts/mysqlup but no way still same error can not connect to Mysql
View Replies !
Integrating Two MYSQL Databases
I would like to merge two mysql databases. Any idea on how this can be done? My table only have two fields (name and surname). No primary keys or codes. I would like that if one of the registries is repeated in both databases one of the registers is overwritten.
View Replies !
Integrating MYSQL And Crystal Reports XI
I have successfully created an ODBC connection with my MYSQL database remotely. The issue I am having is that Crystal Reports XI does not see any of my tables in the database. I have MYSQL 5 running on my server and I want to build reports of my database using Crystal. I have searched everywhere for answers and wanted to try this forum first to see if anyone had the answer.
View Replies !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
Mysql Suse 10
I face the problem named here but it seems that nothing works for me. The only thing I didn't manage to do is Code: su mysql It requires password. I tried ,mysql,root,nothing but I can't get access.
View Replies !
Mysql On Open SUSE 10.2
I installed open SUSE 10.2 and it works fine. I tried to look at Mysql. No it didn't work. --------------------------------------------------- niss@linux-flei:~> mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) niss@linux-flei:~> show databases; bash: show: command not found niss@linux-flei:~>
View Replies !
Connect To Mysql After Install Via YAST Under Suse 9
i have installed mysql via yast under suse 9 linux:/home/mcollin # rcmysql start Starting service MySQL i try to change the password i get: linux:/home/mcollin # mysqladmin -u root -p password Enter password: mysqladmin: connect to server at 'localhost' failed mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' how to resolve that?
View Replies !
MySQL 4.0.18 InnoDB Configuration Issues On SuSE 9.1 Pro
I've tried resolving this issue in a SuSE newsgroup, but after trying their suggestions and working on this issue for far too long already, I decided to try this list as it may be a more appropriate discussion area. I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using the default RPM's that came with the distribution. I created a simple database (one table with InnoDB engine type) and have tried running some ODBC source against it to test transactions, but I get the error that the server does not have transactions enabled. I was directed to enable transactions in the configuration file (/etc/my.cnf) by uncommenting the lines for innoDb use. However, after uncommenting these lines and running mysqld from the commandline (according the online Manual), to generate InnoDB support tables, I get the following error: mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/' I've tried removing the RPM's and starting from scratch, but cannot get past this error and successfully test transactions in my unit tests.
View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server. If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields? In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names? Or do they matter?
View Replies !
Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local. 1. I have installed MYSQL Server to my localhost [Windows]. MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt. 2. I have installed the MYSQL Network Monitor to my local system [Windows] With all options like admin login, agent and other details. But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor. I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor. We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
View Replies !
MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like. The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead. I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims. By no means do I want to get into 'down with Microsoft' thread here. Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?
View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located. I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side? I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit. But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts? I'd like it to be command line, so it can be run from another application which would then run this from a shell.
View Replies !
Importing .sql File In SQL 3.23 On Linux 7.1 Server
I've got a .sql file and was going to import it into mysql. The file contains around 30000 data but after i've typed: mysql> source /xx/file_name.sql; Table of the sql file is created but contains no data. But it poped an error notice without any message: ERROR: <----like this the .sql file is version 4.0. Is there any problems on version 3.23 while importing a v4.0 file? If so, could any brother please help on resolving this problem?
View Replies !
Command Line Mail Merge From Mysql Db
I would like to be able to mail merge records from multiple mysql tables using a simple template, preferably via a command line script. MSWord mail merge via ODBC will not work for me as it only supports a single table. Are there any utilities or simple scripts avaialble that would accomplish this?
View Replies !
Upgrading MySQL - Send Mail Stopped Working
I recently upgraded my Mac (running OS 10.4.8) to Apache 2.0.52, MySQL 5.0.24 and PHP 4.3.9. While I seem to be accessing the latest MySQL from the Terminal, Apache seems to continue to use the previous install of MySQL. Is there some config file I need to edit so the new install of MySQL is used by my Web server? While I'm at it, my PHP seems to no longer be able to send email, though I added "sendmail_path = /usr/sbin/postfix" to the php.ini file.
View Replies !
MySQL VIEW -> MS Word Mail Merge - Grouping Problem
Basically I am trying to create a simple invoice system that takes a query of a particular set of customer orders in the form of a VIEW (see below) and then Microsoft Word's mail merge facilities access this VIEW and then do a mail merge based upon it. The fields in each invoice are things like ShopperID, address1, address2 and other customer info as well as the products bought along with the corresponding quantity, price and amount (this essentially being quantity*price) etc. MySQL CREATE OR REPLACE VIEW invoice AS SELECT o.*, i.Product AS Product, i.price AS Price, i.qty AS qty, i.amount AS Amount FROM orders o INNER JOIN items_ordered i ON i.ShopperID = o.ShopperID WHERE o.DATE BETWEEN ��-10-01' AND ��-10-31' MS Word's mail merge connects to the database and accesses the VIEW query results just fine. The problem arises with the grouping of products (along with their associated quantity, price etc.) under each Shopper (or ShopperID to be more precise). Now, in the VIEW above I did not GROUP BY ShopperID so I used GROUP_CONCAT in conjunction with GROUP BY ShopperID to get all the products bought by a customer on the same record. MySQL CREATE OR REPLACE VIEW invoice AS SELECT o.*, GROUP_CONCAT(i.Product SEPARATOR ' ') AS Product, GROUP_CONCAT(i.price SEPARATOR ' ') AS Price, GROUP_CONCAT(i.qty SEPARATOR ' ') AS qty, GROUP_CONCAT(i.amount SEPARATOR ' ') AS Amount FROM orders o INNER JOIN items_ordered i ON i.ShopperID = o.ShopperID GROUP BY o.ShopperID HAVING o.DATE BETWEEN ��-10-01' AND ��-10-31' I thought this would work just fine but the strange thing is that MS Word displays the Product field correctly (which has been concatenated using a new line ) but it doesn't display anything for the quantity, price or amount fields. I have tried using different separators like ' / ' and ',' but the same problem occurs. Does anyone have any ideas about why it is doing this and how I can find a solution?
View Replies !
What Is The Best File Type To Output For A MSWord Mail Merge From A Mysql Database?
I'll be working on a project soon which will involve outputting a list of names and addresses from a database, these will then be used in an MS Word Mail Merge. I need to know how best to create the file for use as a datasource in the MM. So far I have found that a fairly easy method is to output a txt file which contains a tab delimited list of the names and addresses. This can then be used as a datasource in MSWord, afterwhich fields can be selected and the Mail Merge created. I've not coded any of this so far, I've only created the text file manually. I was wondering though, how do you get carriage returns into the address? At the moment when I used the file, the addresses all appear on one line?
View Replies !
MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant". Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service. Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?
View Replies !
Install On Suse 9.3 Professional
I'm looking at MySQL 4.1 for a project and am a newbie (to MySQL). I have a 32-bit Suse Linux 9.3 professional installation which has plenty of disk space that I can play with. I see that the 4.1 downloads only have binaries for Enterprise Edition. Will this work on 9.3 Pro? If not, is there a binary version I can use or do I need to compile the source?
View Replies !
Query Browser Won't Install On SuSE 9.2
MySQL Query Browser won't install on SuSE 9.2 because it requires the following: libgal-2.0.so.6 libgal-a11y-2.0.so.6 These do not appear on the SuSE installation disks. I googled and didn't find them available for download What can I do?
View Replies !
Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP. I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects Does anyone know a tool like the one I just described in my dream
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
Eventum E-mail
Eventum is installed and running perfectly, but I am having a bit of trouble with having the e-mail integration work. My only wish is to have e-mails generated when a request or ticket is assigned to someone. This being the case, the only script that concerns me is the 'process_mail_queue.php' script in the 'misc' directory. When I run the script from the command line, it runs without a problem. When I set the script to run as a cron job, nothing happens. If I check the cron logs, it appears as if the script ran perfectly. The following line was added to crontab: * * * * * root php -q /_path to eventum_/misc/process_mail_queue.php The cron log just shows the job running every minute as it should. Is there something that I'm missing here or a reason why it shouldn't run correctly as a cron job?
View Replies !
Get Mail Between Dates
I have the following table: mail_id, mail_name, mail_start, mail_finish What I want to do is get ALL the mail between the start and finish date.
View Replies !
Mail Merge
I have a client who is using Microsoft Access and Word to do a mail merge to create one email per name. They want to convert to Linux. I have been told MySQL owuld handle this. What will I need on the Linux computer? Server or client? Hardware requirements? What word processing program? It needs to merge to email. I prefer to use Suse or Novell (based on Suse) linux.
View Replies !
PHP Mail Function
We are using PHP and MySQL technologies in site running on Linux. We are using PHP mail function to send emails to our site users on different occasion unfortunately we found that mail could not delivered on AOL IDs so all our site users who has AOL email IDs are not able to receive any email those we have sent through PHP mail function.
View Replies !
|
TRACKER
