Slackware :: Error 1146 - Basic MySQL Configuration / Initialization
Oct 22, 2010
Do I have to do a basic configuration / initialization of mysql, like described in the following link, before I can use it? [URL] The background is, that I want to use mythtv and therefore I need a working mysql. When I tried to create the needed database, as described in the file README.SLACKWARE (included in mythtv.Slackbuild package from slackbuilds.org) with the following command, I got an error:
# mysql -u root -p < /usr/share/mythtv/database/mc.sql
The error message was:
ERROR 1146 (42S02) at line 3: Table 'mysql.servers' doesn't exist
-- integrale
I don't remember that I ever did a basic configuration but mysql was already used by joomla, and it worked right out of the box.
View 5 Replies
ADVERTISEMENT
Jan 12, 2010
Im trying to migrate mysql to a new server, the first server is FreeBSD 6.2 and the second server is ubuntu, so I used rsync for that, on ubuntu:show database; works successfully and shows the database imported from the FreeBSD box, show tables; also works, but select data from any didn't work, I keep getting "ERROR 1146 (42S02): Table 'DATABASE.TABLENAME' doesn't exist", although .frm .MYI .MYD are available in /var/lib/mysql/databasename
View 2 Replies
View Related
Jul 30, 2010
So I installed the Unison synch software with sudo apt-get install unison-gtk. When I set up the two directories for synchronization it looks like this: $ unison ssh:\SERVER\pathpath /var/www/path/path/path
I am getting this error in terminal Uncaught exception Gtk.Error("GtkMain.init: initialization failed ml_gtk_init: initialization failed") Fatal error: exception Util.Fatal("Error in getLogch: /home/path/.unison/unison.log: No such file or directory"
View 1 Replies
View Related
Jul 13, 2010
Does anyone know how to write this command for mysql version 4? (The command is for mysql version 5, I guess since when I check database in mysql server version4 there is no database name information_schema ) command:select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc; meaning:show all database,table name and row count from all databases that has table row more than 1000000
Run result with mysql version 5: mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;
[Code]....
View 3 Replies
View Related
Jun 18, 2010
Recently I got a very rare database issue, it says: Error: Couldn't read status information for table clients_copy () mysqldump: Couldn't execute 'show create table `clients_copy`': Table 'adm_retail.clients_copy' doesn't exist (1146) Error: Couldn't read status information for table dt_mx_emp ()
[Code]...
View 2 Replies
View Related
May 28, 2010
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
100527 18:26:49 [ERROR] Aborting
100527 18:26:49 [Note] /usr/local/libexec/mysqld: Shutdown complete
Installation of system tables failed!
View 6 Replies
View Related
Mar 5, 2011
At the moment I am having a problem with the MySQL server on my VPS. It's a completely fresh install of both Debian 5 and MySQL but the problem is upon logging in I get:
[root@boris ~]#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[code]....
View 8 Replies
View Related
Feb 27, 2010
I want to learn Java programing language and MySQL in linux.What packages do I've to install?Are there any sites providing basic tutorials of java and MySQL?
View 1 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
Mar 22, 2010
Hi when i run the updater or through yast i get the following
There was an error in the repository initialization.
[URL] Valid metadata not found at specified URL(s)History:- [|] Repository type can't be determined.
looking through my repositories list it seems it has added one from anything i have installed. What are the necessary ones?
View 9 Replies
View Related
Aug 9, 2010
'm new to linux as of today, and I'm really liking it so far, but I've already run into issues. When I open up the software manager in openSUSE 11.3 (KDE), I receive the following warning message:
There was an error in the repository initialization.'repo-update': [URL].. Repository is not cached From there, I'm unable to install anything (I want to install WICD because KNetworkManager is not working for me). How do I resolve this issue?
View 9 Replies
View Related
Feb 19, 2011
trying to install broadcom-wl-kmp-desktop and broadcom-wl-5.100.82.38-7 for my wireless driver. The yast2 keep saying error. Don't know why. I installed opensue11.3 with not problem. Missing packman when i zypper repos command.Do anybody know why.I am very new to linux.I always been window user.
View 6 Replies
View Related
Sep 8, 2010
Whenever I open software repositories or management via YaST I get an error message about a Repository initialization error From Software Repositories
[Code]...
View 9 Replies
View Related
Apr 19, 2011
I just installed 11.4 and was adding a new repository which I entered incorrectly. Yast2 complained and did not add it to the repository list. Now when I run Yast2 Software Management.
I get the following error message...
"There was an error in the repository initialization.
Error refreshing service Packman 11.4 (vaval.com - Islam Resources and Information. This website is for sale!
Parse error: repoindex.xml[3] Opening and ending tag mismatch: meta line 2 and noscript"
Since this line does not show up in my repository list I cannot remove it. How do I edit the data file directly and where is it located?
View 2 Replies
View Related
Mar 18, 2011
Earlier I have no problems when I install opensuse. After installation the network runs and I can run online updating in yast for the system. But since a few version it doesn't work after installation and I don't know why. I think maybe the errors could happen because I have no
internet connection. Today I install 11.4 and get this message when I want to run online updates in yast.
There is an error in the repository initialization
'repo-update' [URL]
[repo-update URL]
Repository is not cached
I think this problem stars with 11.1 or 11.2.
View 5 Replies
View Related
May 10, 2011
Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
View 3 Replies
View Related
Apr 7, 2011
On Ubuntu 10.04 with Apache and PHP installed, I can execute a test.php file
Code:
If I specify it on my Apache web server
Code:
However, I am not able to configure the web site to execute index.php automatically.
These are the settings I have.
Code:
View 2 Replies
View Related
Jun 28, 2010
i know debian and ubuntu but i dont know slackware.i got this mini linux that can run in a 386 with 8mb ram and with GUI really awesome.but i dont know how to renew ip or setup the network card.i tried ifconfig but i see the loopback only nt ip.i tried ipconfig eth0 up and nothing.
View 1 Replies
View Related
Jun 5, 2011
I installed slackware 12.1 from files i downloaded and converted to cd (images). There are six "disks" i downloaded from the slackware site and converted to images via a homemade .cmd in windows xp and then burned using imgburn.
I partitioned my hd (canibalized from an acquaintance's emachine and connected it to my desktop (1G ram, 2Ghz processor). Booted from disk 1 and fomatted the 80G HD for 2 partitions of linuxswapable at 2G apeice and 2 partitions of bootable linux. (Because i want to try another distro later). I ran the setup installing most everything and all seemed to go well. After i exited setup and restarted, it identifed the cd/hd as normal and then went into some sort of recovery mode with the emachine logo call pcangel, after which it tells me.
STOP: c0000021a (fatal system error) The session manager initialization system process terminated unexpectedly with a status of 0xc000003a (0x00000000 0x00000000). the system has been shut down. So, is this indeed an xp error message, and if so, why am i getting it after formatting everything?
View 3 Replies
View Related
Nov 18, 2010
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
View 6 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
Dec 6, 2010
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 6 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[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
May 5, 2011
I recently took my Compaq Presario 2175US notebook completely apart and resoldered the power jack so that it could be used again (after 2 years of dormancy). After successfully putting it back together (with a handful of leftover screws ) , I was able to successfully install Ubuntu 10.04 (Windows XP seemed silly at this point and I really like using Open Office). Anyway, after a couple of days looking for the wireless driver for the internal wireless, I found the answer and got that working.
Unfortunately, the video does not seem to be working other than a basic VESA configuration. The notebook has the ATI Radeon IGP 320M video chip installed. I have searched for many days (about a week) on the internet for a way to get this working, but have been unsuccessful. Although I have found many posts all over the net (here included) that list folks with similar problems, and having tried many of the "fixes", I am still unsuccessful at getting the video card to work in any more than a minimal manner (no games, no 3D of any kind...etc.)
View 5 Replies
View Related
Feb 8, 2011
I have finished reconfiguring my 1st PC Centos 5.5 with Squid and Dansguarian. Works fine the configuration is basic.lets name it to 1st PCeth0 - modem ip (public)eth1 - 172.16.1.1 (LAN)Then I've decided to change and add another Centos 5.5 for Firewall Service that is directly connected to the modem and then shares internet connection and some ports to 1st PC.
lets name it to 2nd PC, it also has two NICSeth0 - modem ip (public)eth1 - 10.0.0.1 (ip to connect to the 1st pc with squid services)so I changed the ip of the 1st PC with theseeth0 - 10.0.0.2eth1 - 172.16.1.1 (LAN)and connects the eth0 (10.0.0.2) of the 1st PC to the eth2 (10.0.0.1) of the 2nd PCthen I've tried browsing on the network but it does not work...is there a simple iptables command for the 1st PC and 2nd PC?ere are the iptables script and lists of my 1st and 2nd PC 2nd PC (firewall to be)
#vi /home/user1/fw.sh
#!/bin/sh
123=/sbin/iptables
[code]....
View 7 Replies
View Related
Jan 16, 2011
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
View 6 Replies
View Related
Sep 26, 2010
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
View 9 Replies
View Related
Apr 3, 2010
I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:
ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include
[Code].....
I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?
Is it possible to install snort from repositories using yum?
View 3 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
