Menu
▾
▴
sql-ledger-users
|
From: Honest to G. <h2...@sy...> - 2002-04-07 04:25:22
|
I fought all day against mysql and was thrown back in defeat. I tried installing from source, from rpm and through red-carpet, I have configured everything a dozen times and I still can't connect to port 3306. I get this error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Yet mysql put that file there when the daemon started, and removes it when it's stopped. The error log never shows any errors, just ok startups and shutdowns. I always see the errors on the command line. I try to telnet to 3306 and the connection is refused. My firewall allows 3306 and even with firewall disabled I get the same thing. I see files created and deleted in /var/lib/mysql as I start and stop the server, it looks ok. Webmin can't connect and neither can mysqlgui nor can root at the command line. Everything looks fine but I just can't connect. After install I ran mysql_install_db and it seemed to work but I don't see any databases. I think that's where the problem is, no databases. What do database tables look like? Where? How big? What extension? I really need to get sql-ledger up and running. Can I use a different database? How about postgres? Maybe I can get that one to work. Any help will save my life ... |
|
From: mark h. <ma...@ac...> - 2002-04-07 05:21:47
|
SL on MySQL? Have I missed something? SQL-Ledger only runs with PostgreSQL. Install Postgres. You'll also need DBD/DBI I believe. Read the docs at the SQL-Ledger web site to get the info you'll need. --Mark At 11:27 PM 4/6/2002 -0500, you wrote: >I fought all day against mysql and was thrown back in defeat. I tried >installing from source, from rpm and through red-carpet, I have >configured everything a dozen times and I still can't connect to port >3306. > >I get this error: >Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > >Yet mysql put that file there when the daemon started, and removes it >when it's stopped. The error log never shows any errors, just ok >startups and shutdowns. I always see the errors on the command line. > >I try to telnet to 3306 and the connection is refused. My firewall >allows 3306 and even with firewall disabled I get the same thing. I see >files created and deleted in /var/lib/mysql as I start and stop the >server, it looks ok. > >Webmin can't connect and neither can mysqlgui nor can root at the >command line. Everything looks fine but I just can't connect. > >After install I ran mysql_install_db and it seemed to work but I don't >see any databases. I think that's where the problem is, no databases. > >What do database tables look like? Where? How big? What extension? I >really need to get sql-ledger up and running. Can I use a different >database? How about postgres? Maybe I can get that one to work. Any help >will save my life ... |
|
From: Tom L. <to...@re...> - 2002-04-07 14:35:38
|
I too was unaware that SQL-Ledger ran with MySQL. I'm pretty sure it doesn't. That aside, it sounds like a privilege problem. I fought with this one for awhile. Although you say you can't login through command line either? Anyway, you need to 'grant privileges' to the host AND user that you want to connect from, and you need to 'flush privileges' or reload mysql after granting privileges. If you don't flush them, you will be scratching your head wondering why the settings didn't work. I don't remember the exact procedure, but look in the MySQL docs and it is described in great detail. Tom PS Install Postgres, that is the one that WILL work! :) --On Saturday, April 06, 2002 11:22 PM -0600 mark hees <ma...@ac...> wrote: > SL on MySQL? > Have I missed something? > SQL-Ledger only runs with PostgreSQL. > Install Postgres. You'll also need DBD/DBI I believe. Read the docs at > the SQL-Ledger web site to get the info you'll need. --Mark > > > At 11:27 PM 4/6/2002 -0500, you wrote: >> I fought all day against mysql and was thrown back in defeat. I tried >> installing from source, from rpm and through red-carpet, I have >> configured everything a dozen times and I still can't connect to port >> 3306. >> >> I get this error: >> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) >> >> Yet mysql put that file there when the daemon started, and removes it >> when it's stopped. The error log never shows any errors, just ok >> startups and shutdowns. I always see the errors on the command line. >> >> I try to telnet to 3306 and the connection is refused. My firewall >> allows 3306 and even with firewall disabled I get the same thing. I see >> files created and deleted in /var/lib/mysql as I start and stop the >> server, it looks ok. >> >> Webmin can't connect and neither can mysqlgui nor can root at the >> command line. Everything looks fine but I just can't connect. >> >> After install I ran mysql_install_db and it seemed to work but I don't >> see any databases. I think that's where the problem is, no databases. >> >> What do database tables look like? Where? How big? What extension? I >> really need to get sql-ledger up and running. Can I use a different >> database? How about postgres? Maybe I can get that one to work. Any help >> will save my life ... > > |
|
From: Honest to G. <h2...@sy...> - 2002-04-07 14:59:28
|
Things are looking much better. I got postgres up in 1/15 of the time it took to go nowhere on Mysql. I can create databases from the command line and Webmin is giving me a nice postgres interface. The problem is when I try to load admin.pl I get this error: ERROR! No Database Drivers available! I haven't tried any other postgres clients, will SL give me a log somewhere? Could be just a permission thing ... |
|
From: Dr D. <drd...@ho...> - 2002-04-07 15:29:12
|
You need DBD-Pg and DBI Try to find them as RPM, the make make install part killed me too.. Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the moment, I could email to you if needs be. That one got me online, it's intended for redhat but Mandrake likes it just as well.. So do I ;-) > -----Original Message----- > From: sql...@sq... > [mailto:sql...@sq...] On Behalf Of > Honest to Goodness > Sent: zondag 7 april 2002 17:02 > To: sql...@sq... > Subject: [SL] can't connect to postgres > > > Things are looking much better. I got postgres up in 1/15 of > the time it took to go nowhere on Mysql. I can create > databases from the command line and Webmin is giving me a > nice postgres interface. The problem is when I try to load > admin.pl I get this error: > > ERROR! > No Database Drivers available! > > I haven't tried any other postgres clients, will SL give me a > log somewhere? Could be just a permission thing ... > > |
|
From: Honest to G. <h2...@sy...> - 2002-04-07 17:45:39
|
OMG! I got it working, achhh it voiks like a chom! Thanks for all your help! On Sun, 2002-04-07 at 11:27, Dr Default wrote: > You need DBD-Pg and DBI > Try to find them as RPM, the make make install part killed me too.. > > Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the > moment, > I could email to you if needs be. That one got me online, it's intended > for redhat but > Mandrake likes it just as well.. So do I ;-) > > > -----Original Message----- > > From: sql...@sq... > > [mailto:sql...@sq...] On Behalf Of > > Honest to Goodness > > Sent: zondag 7 april 2002 17:02 > > To: sql...@sq... > > Subject: [SL] can't connect to postgres > > > > > > Things are looking much better. I got postgres up in 1/15 of > > the time it took to go nowhere on Mysql. I can create > > databases from the command line and Webmin is giving me a > > nice postgres interface. The problem is when I try to load > > admin.pl I get this error: > > > > ERROR! > > No Database Drivers available! > > > > I haven't tried any other postgres clients, will SL give me a > > log somewhere? Could be just a permission thing ... > > > > > > |
|
From: lee j. <le...@im...> - 2002-04-07 23:50:27
|
On Sun, 2002-04-07 at 08:27, Dr Default wrote: > You need DBD-Pg and DBI > Try to find them as RPM, the make make install part killed me too.. > > Or get the SQL-Ledger RPM , it seems www.lillepuu.com is oflline at the > moment, > I could email to you if needs be. ---------------- could you ftp it to me? ftp.imyourhandiman.com put in incoming and just let me know when its there ie: le...@im... thx mucho lee |
|
From: Nicholas T. <ne...@ta...> - 2002-04-08 08:22:46
|
Honest to Goodness wrote: > > Things are looking much better. I got postgres up in 1/15 of the time it > took to go nowhere on Mysql. I can create databases from the command > line and Webmin is giving me a nice postgres interface. The problem is > when I try to load admin.pl I get this error: > > ERROR! > No Database Drivers available! > > I haven't tried any other postgres clients, will SL give me a log > somewhere? Could be just a permission thing ... Did you read the installation notes for SQL-ledger at all???? Try putting DBD and DBI on your system and making them available for SQL Ledger, then you might not have so much trouble, but above all, read the instructions pleeeaaase before posting any more enquiries. Regards,. Nicholas Tomlin. |
|
From: Terry C. <tc...@se...> - 2002-04-07 12:12:54
|
On 6 Apr 2002, Honest to Goodness wrote: > I fought all day against mysql and was thrown back in defeat. I tried > installing from source, from rpm and through red-carpet, I have > configured everything a dozen times and I still can't connect to port > 3306. > > I get this error: > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Have you checked to see if 'skip-networking' is uncommented in the global mysql configuration file. Mine is in /etc/mysql/my.conf. Regards, Terry. tc...@se... ---------------------------------------------------------- Public PGP Key: http://www.selterra.com/pgpkey/tcarney.asc |
|
From: Kenneth G. <la...@th...> - 2002-04-08 06:31:48
|
are you using redhat 7.1? if so, in some copies of the distro, mysql on the cd will not only not work, but will mess up any subsequent installation. you need to physically delete everything to do with mysql, and then install it from another source. kg On Sunday 07 April 2002 09:57, Honest to Goodness wrote: > I fought all day against mysql and was thrown back in defeat. I tried > installing from source, from rpm and through red-carpet, I have > configured everything a dozen times and I still can't connect to port > 3306. > |
Thanks for helping keep SourceForge clean.
X